topic Re: Percentage in SAS Programming

Percentage

Ivy — Thu, 24 Mar 2016 18:57:17 GMT

Dear all,

I would like to calculate mutiple percentage by treatment and put it to one table . Is there any efficeint way for this ?

proc freq data = t ;

tables treatment *( d1 d2 d3 ................................ d100) ;

run;

With the following output table :

treatment disease count percentage

1 d1

.......

..........

Thank you,

Ivy

Re: Percentage

Reeza — Thu, 24 Mar 2016 19:01:27 GMT

Transpose your data and use proc freq.

Re: Percentage

Ivy — Thu, 24 Mar 2016 19:12:03 GMT

Thank you, I do not think that works .

Re: Percentage

Reeza — Thu, 24 Mar 2016 19:27:17 GMT

Yes it does.

Why do you think it won't work? In fact, I think it was also suggested yesterday when you were looking for the maximum value.

Re: Percentage

Ivy — Thu, 24 Mar 2016 19:31:43 GMT

Transpose worked for yesterday data, but not today's freq. The following is the codes I used, I am not sure whether this is the way you suggested . Thank you.

proc transpose data = ads out= ads_t;
by index_year ;
var COPD Chronic_kidney_disease
Congestive_heart_failure Coronary_Heart_Disease Dementia Diabetes HIV_AIDS Hemiplegia
Infectious_hepatitis Peripheral_vascular_disease Rheumatoid_arthritis Stroke Ulcer_disease
Venous_thromboembolism Alcoholic_liver_disease ;
run;

Re: Percentage

Ivy — Thu, 24 Mar 2016 19:33:47 GMT

I would like to compare the different diseases percentage at different year. Thank you.

Re: Percentage

Reeza — Thu, 24 Mar 2016 19:36:54 GMT

The word year doesn't appear in your initial post...

Please post sample data and sample expected output. You can make fake data for 5 or 10 d's rather than the full 100.

Re: Percentage

Ivy — Thu, 24 Mar 2016 19:55:31 GMT

Thank you, Reeza.

Sample data&colon;

treatment id d1 d2 d3
a 1 0 1 0
a 2 1 0 0
a 3 1 0 1
a 4 0 1 0
b 1 0 0 0
b 2 1 0 0
b 3 0 1 1
b 4 1 0 0

Output :

Treatment_a Treatment_b P-value
d1 (percent)

Re: Percentage

Reeza — Thu, 24 Mar 2016 19:53:28 GMT

Because you've coded your data as binary, transpose and use proc means. Sum will provide count and mean will provide the percentage.

Re: Percentage

Ivy — Thu, 24 Mar 2016 19:58:13 GMT

Thank you, Reeza. I just realized I forgot to add P-value to the output. So maybe I use proc freq to loop the variables and combine the output together instead of doing the task in one step.

Re: Percentage

Reeza — Thu, 24 Mar 2016 20:18:38 GMT

I have no idea what you want anymore...good luck.

Re: Percentage

ballardw — Thu, 24 Mar 2016 20:33:17 GMT

What test will you be running to get a p-value?