topic stacking variables in proc report in ODS and Base Reporting

stacking variables in proc report

Simmi — Wed, 27 Mar 2013 22:31:38 GMT

Hi All,

I'm creating a table using proc report and would appreciate some insight on stacking multiple variables into a single column in a table in proc report. I have done this using proc tabulate but struggling to produce the same report using proc Report.

My question would be how would I stack multiple column variables in a single column in table so that it becomes easy for me to compute count and percentage on the data across.

my column variables are

sex Age County total

M 57 Travis 120

F 13 William 100

M 21 Bexar 123

F 19 william 145

proc report data=test2;

column SEX AGE COUNTY total, (n pctn);

define sex/group;

define age/ group;

defineCounty/across;

define total/analysis;

run;

final output

Demographics Count percentage

M 2

F 2

50-57 1

10-17 1

19-29 1

Re: stacking variables in proc report

Cynthia_sas — Thu, 28 Mar 2013 04:32:00 GMT

Hi,

What you want to do is not an "out of the box" type of report that PROC REPORT will create. First, you have to presummarize the data. Then generally with reports like this you will need to massage the data a bit in order to make variables in the order that you want. In my paper, called "Creating Complex Reports", I show 3 different examples of somewhat similar demographic reports. (http://www2.sas.com/proceedings/forum2008/173-2008.pdf)

The code is too lengthy to post here, but the general outline of the code process is in the paper. The zip file of program examples, can be found at Technical Papers and Presentations made by SAS staff you will need to scroll down to 2008 to find the paper by title.

cynthia

Re: stacking variables in proc report

Simmi — Mon, 01 Apr 2013 16:47:09 GMT

Thanks for the info Cynthia!