proc tabulate data=R.THEOFFSITEWORK order=data;
class CDPRMASS *THEFACILITY/ASCENDING;
tables THEFACILITY *CDPRMASS/rts=25.row=float;
keylabel n=' ';
run;
I need "THEFACILITY" data to output in ascending order ?? its not working...it should be New Hanover then Orange, then Wake?
Solved: I removed "rts=25.row=float", every facility is in alphabetical order now. Whew!!
thanks
Correct, I just want the facility names to be in order not too concerned with the actual data within each cell. My output has about 70 facility names (new hanover, orange, wake, johnson etc.. and the requester said she needs them in order. So should I put the order statement in place of the ascending command? ?
proc tabulate data=R.THEOFFSITEWORK order=freq;
class CDPRMASS *THEFACILITY;
tables THEFACILITY *CDPRMASS/rts=25.row=float;
keylabel n=' ';
run;
I would try this, but not 100% sure what you want is actually possible.
So far no luck but thank you very much for assisting. I' think you're right maybe its not possible...I figured ascending would do the trick. I'll have to sort each manually in excel
Solved: I removed "rts=25.row=float", every facility is in alphabetical order now. Whew!!
thanks
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.
Find more tutorials on the SAS Users YouTube channel.