2 Answered Questions for the topic proc sql
Proc Sql Sas
Limiting results in PROC SQL?
I am trying to use PROC SQL to query a DB2 table with hundreds of millions of records. During the development stage, I want to run my query on an arbitrarily small subset of those records (say,... more
Is it possible to do a case-insensitive DISTINCT with SAS (PROC SQL)?
Is there a way to get the case-insensitive distinct rows from this SAS SQL query? ... SELECT DISTINCT country FROM companies; The ideal solution would consist of a single query. Results now... more