Your problem is not the same one. The original question was about SASUSER.PROFILE, your issue is with WORK.SASMACR. Different catalog file, different location. You probably exceeded your quota in the WORK location, maybe because of remnants of crashed or improperly terminated SAS sessions. ... View more

made all the changes, and works like a charm. thanks guys. ... View more

The format associated with the analysis variable will also be associated with the statistics, MIN and MAX. RTM ... View more

This is basically the same idea as suggest already. I don't know how long it would take to sort the data. You might want to do sort the data in groups then combine and count. Be sure to keep only the variable that needs counting. Should save a lot ot time if the data set has lots of variables. [pre] proc sort data=sashelp.shoes(keep=Subsidiary firstobs=1 obs=200) out=bin1; by Subsidiary; run; proc sort data=sashelp.shoes(keep=Subsidiary firstobs=201 obs=max) out=bin2; by Subsidiary; run; data freq; do Frequency=1 by 1 until(last.Subsidiary); set bin1 bin2; by Subsidiary; end; CumulativeFrequency + Frequency; run; proc print; run; [/pre] ... View more