If you are working with UE, it may also be that forcibly terminated sessions have clogged up the VM (it has a maximum internal space if 10 GB, and that limits the WORK location). To remedy that, you need to re-install UE.
Please show us the sizes of yor datasets (number of obs, observation size)
How large are the datasets you are merging?
Why not just use a data step instead of letting PROC SQL fill up your disk space with temporary files?
data _null_;
merge class1.smb work.mismatches2;
by product_id ;
put (_all_) (=);
if _n_ > 20 then stop;
run;
If you are working with UE, it may also be that forcibly terminated sessions have clogged up the VM (it has a maximum internal space if 10 GB, and that limits the WORK location). To remedy that, you need to re-install UE.
Please show us the sizes of yor datasets (number of obs, observation size)
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.