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.
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 25. Read more here about why you should contribute and what is in it for you!
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.