The SAS Output Delivery System and reporting techniques

Best way to rearrange columns in PROC REPORT?

Not applicable
Posts: 1

Best way to rearrange columns in PROC REPORT?


(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.



Super User
Posts: 13,350

Re: Best way to rearrange columns in PROC REPORT?

Posted in reply to Sandra_Tilmon

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.

Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation