I'm running a merge on a rather big dataset. The problem is it sloooows my PC down it becomes annoying. I've tried using bufsiz and bufno to reduce the amount SAS uses and in desperation set them to 1 but to no discernible difference. I don't mind if the process takes longer, but is there a way so it only uses 1 GB of RAM? The two tables are 17,396,594 and 1,763,513 rows and sit on my C Drive. I'm using SAS Base 9.3 (Windows 7) and I don't want answers offering me a different 'Technical' solution (i.e. SAS Server etc.) but are there any settings I can change in my current environment? Thanks for any help offered! /* adding sequence count to records - in case incorrect #'s were given */ data clean.UPDT UCST; merge clean.UPDT (in=a) SEQ_LST (in=b rename=SEQUENCE_COUNT=LSEQ); by CUST_ID TMP_CUST; if SEQUENCE_COUNT < LSEQ then output UCST; else output clean.UPDT; run;
... View more