Hello,
(1) What would be the best way to rearrange columns in PROC REPORT?
I am doing a number of reports, so I would like to do this column rearranging as automatically as possible.
The source data file is complex survey data. I'm running PROC SURVEYFREQ on composite variables (combined age category and gender, for example), for which I would like to insert subtotals. I have the subtotals appearing in the report, but not in the correct place.
I would like to hide column 4 (_col4_), have column 8 appear where column 4 was.
(2) Another option would be to use the root variables of age category and gender, but this was complicated with the PROC SURVEYFREQ output.
Best,
Sandra
Some code and output of what you currently have needs rearranging and the rules would be helpful.
Also what defines the groups that need subtotaling.
Also you might show some of the SurveyFreq code, the input and output you're using and what you would actually like to have. It may be that the approach you used for Surveyfreq could be improved. Or possibly start a separate thread for this part.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.