|
proc sort data=temp.lab (keep=id sample_dt lab_id) out=test (keep=id
sample_dt) THREADS;
On Fri, 27 Aug 2010 14:37:20 -0400, Bin Zhu <bxz01@HEALTH.STATE.NY.US> wrote:
>Hi,
>
>I am querying a table with 5 millions records and 5 fields using the
>following SQL code:
>proc sql;
>create table test as
>select l.id,l.sample_dt
>from temp.lab l
> where =lab_id in ('8888-8','9999-1')
>order by id, sample_dt;
>quit;
>
|
