calculating a percentage based on different counts at each time point.

Kc2 — Tue, 09 Aug 2016 09:14:16 GMT

Hello,

I am doing a summary by category of response and by visit for a group of people.

proc means data=all noprint;

by visit cat ;

var aval;

output out=final_cat n=n mean=mean min=min ;

run;

proc means data=all noprint;

by visit cat under;

var aval;

output out=final_under n=ns ;

run;

I then do a proc transpose and set the 2 datasets together;

proc transpose data=final_cat out=Tr_cat;

by visit;

var n mean min;

id cat;

run;

Proc sort data= final_under ; by visit under ; run;

proc transpose data=final_under out=Tr_under;

by visit under;

var ns;

id cat;

run;

data final;

tr_cat tr_under;

by visit;

set

run;

I get :

category 1 category 2 category3

Day1 N 18 19 6

Mean 0.5 0.6 1.34

Min 0.1 0.5 0.2

under 12 17 (%) 17 (%) 5(%)

over 12 1(%) 2(%) 1(%)

Day4 N 8 3 32

Mean 0.4 0.35 0.73

Min 0.1 0.2 0.1

under 12 7 (%) 3 (%) 23(%)

over 12 1 (%) 0 (%) 9(%)

Day8 N 3 1 39

Mean

Min

under 12 3(%) 1(%) 29(%)

over 12 0 (%) 0(%) 10(%)

I need to calculate the percentage in red based on the count of people at each visit.Ex for Day 1, in category 1, under 12 it should be (7/8)*100.

How can I do it?

Thanks

Re: calculating a percentage based on different counts at each time point.

RW9 — Tue, 09 Aug 2016 09:27:58 GMT

Please post some test data so that we can run code:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

Re: calculating a percentage based on different counts at each time point.

Kc2 — Tue, 09 Aug 2016 09:47:52 GMT

Thanks but I resolved my problem.

I cretaed an intermediate merge data step in which I merge the two datastep, calculate the percentage and then do the transpose.

topic Re: calculating a percentage based on different counts at each time point. in SAS Programming

calculating a percentage based on different counts at each time point.

Re: calculating a percentage based on different counts at each time point.

Re: calculating a percentage based on different counts at each time point.