Creating percentages of a population within a proc report 1

[JamesH122]

I'm producing a series of reports from one dataset using proc report. In each report there are the volume of individuals by category - I want to get each one of these volumes output as a pecentage of the total.
e.g.

Vol Perc
10 ?%
10 ?%
10 ?%
10 ?%
40 100%

Is there anyway of doing this within the proc report or am I going to have create separate data sets for each series of reports and create a total number of Volumes within that?

Many thanks

James

 

[ChrisW75]

I don't fully understand your problem here, but I think that this article might help you out.

http://support.sas.com/rnd/papers/sgf07/sgf2007-report.pdf

I hit something similar when I was trying to do percentages across a dataset. I think in the end I actually ran a step prior to that to get a total count into a macro variable, then used that macro variable to calculate the percentages.
Something like this:-

proc sql noprint;  /* Noprint supresses printed output */
  select sum(vol)
  INTO :TOT_VOL
  from mydset 
  ;
quit;

data mydset2;
  set mydset;

  pct = vol/&TOT_VOL ;
run;

You could also do this last step in a compute statement in your proc report if you're comfortable with proc report. I quite often prefer to do it in a datastep befor the proc report so that I can see the actual results in a dataset, makes it a bit easier to debug at times.
If you DO choose to do this in the Proc Report step, make sure that your calculated variable (PCT) appears AFTER the variable it depends on (VOL) in the list of columns, otherwise you'll just get missing values as your result. This is because Proc Report, as it processes each column, only knows about the previous columns, not ones further along its list.
Let me know how it goes.

Chris
Business Analyst, Code Monkey, Data Wrangler.
SAS Guru.

 

[JamesH122]

Thanks for your reply Chris.

The article you attached had just the code I was looking for on page 15 - effectively it does what a proc freq does but within the proc report and you can accumulate the percentages on a number of different columns.

This is a very useful bit of code - nice one!

Cheers

James