The SAS Output Delivery System and reporting techniques

Best way to rearrange columns in PROC REPORT?

Reply
N/A
Posts: 1

Best way to rearrange columns in PROC REPORT?


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

Grand Advisor
Posts: 9,748

Re: Best way to rearrange columns in PROC REPORT?

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.

Post a Question
Discussion Stats
  • 1 reply
  • 399 views
  • 0 likes
  • 2 in conversation