topic Re: Calculate percentage in SAS Programming

Calculate percentage

Q1983 — Sun, 15 Mar 2020 22:06:58 GMT

data have;
length Status $25.;
input Status cnt;
return;
datalines;
Tot_pop 10
Curr 5
_30_day 1
Paid 4
;run;

Status	cnt
Tot_pop	10
Curr	5
_30_day	1
Paid	4

Is there a way to calculate the percentage change using Tot_Pop as the base line. Idea is to divide Curr/Tot_pop and show results on Curr row, then _30_day/tot_pop and show on _30_day row?

Re: Calculate percentage

PaigeMiller — Sun, 15 Mar 2020 22:11:04 GMT

Its really hard to generalize from your example

If tot_pop is the sum of the other CNT values, then you don't need it. (Is it always going to be the sum of the other CNT values?)

But assuming it is the sum of the other CNT values, get rid of the tot_pop line, delete it from your data set, and then run PROC FREQ to get your percentages.

Re: Calculate percentage

ballardw — Mon, 16 Mar 2020 19:42:53 GMT

@Q1983 wrote:

data have;
length Status $25.;
input Status cnt;
return;
datalines;
Tot_pop 10
Curr 5
_30_day 1
Paid 4
;run;

Status cnt

Tot_pop 10

Curr 5

_30_day 1

Paid 4

Is there a way to calculate the percentage change using Tot_Pop as the base line. Idea is to divide Curr/Tot_pop and show results on Curr row, then _30_day/tot_pop and show on _30_day row?

I would call this a good example of why not to include summary data in data if Tot_pop is supposed to be the sume of Curr, _30_day and Paid. Especially if you calculated it previously.

One take on what I think is similar to what you want:

data have;
length Status $25.;
input Status cnt;
return;
datalines;
Tot_pop 10
Curr 5
_30_day 1
Paid 4
;
run;

proc tabulate data=have;
   where status ne 'Tot_pop';
   var cnt;
   class status;
   table status all='Tot_pop',
         cnt *(sum pctsum)
   ;
run;