|
hello, Happy new year to all,
I need to get the distinct recip_id from a big file (100 million records
with 8 variables). I tried the following code:
proc sql;
create table recip_id as
select distinct recip_id
from srcdata.98statin;
I got the error: Insuffient memory, then I tried:
proc sql;
create table recip_id as
select distinct recip_id
from srcdata.98statin(keep=recip_id);
Still, it not working. I also tried:
proc sort data=srcdata.98statin(keep=recip_id) out=recip_id nodup;by
recip_id;run;
this run out work space.
Is there any other ways I can slover this problem. at end, I will use this
recip_id as look up table to pull information related to thoes recip_id.
thank you,
| 
