topic Re: Frequencies and percentages in multiple columns with same variable in SAS Enterprise Guide

Frequencies and percentages in multiple columns with same variable

ThomasRDaugaard — Thu, 02 Feb 2017 07:59:48 GMT

Hello people

I'm new with SAS and have just started using Enterprise Guide. I've got a bit stuck with the statistics and I hope you can help me.

A segment of my sheet looks something like this:

id graft_comp1 graft_comp2 graft_comp3

1            Ascites                           Rejection
2            Hypoalbuminemia           Hypoalbuminemia
3            Hypoalbuminemia           Ascites                   Ascites
4            Rejection                        Rejection
5            Ascites

I would like to get the frequencies and percentages of each complication (after surgery) from all the columns. I have tried with this:

proc freq data=komplib.cdmerged;
tables graft_comp1 graft_comp2 graft_comp3 / nocum ;
run;

But this way I get the data in tree different tables.

Is there any way I can get the results as a sum of all data in the columns collectively?

Plese helt me. 🙂

Thomas

Re: Frequencies and percentages in multiple columns with same variable

Astounding — Thu, 02 Feb 2017 11:22:36 GMT

Not without jumping through some sort of hoop. The easiest hoop to jump through is probably this one:

data temp;

set have;

if graft_comp1 > ' ' then do;

complication = graft_comp1;

output;

end;

if graft_comp2 > ' ' then do;

complication = graft_comp2;

output;

end;

if graft_comp3 > ' ' then do;

complication = graft_comp3;

output;

end;

run;

proc freq data=temp;

tables complication / nocum;

run;

If you have a large number of variables, not just 3, you don't have to spell out the logic for all of them. Instead, you could create an array in the DATA step, and process each variable in the array.

Re: Frequencies and percentages in multiple columns with same variable

ThomasRDaugaard — Thu, 02 Feb 2017 12:24:05 GMT

Thank you very much for your reply.

I will try if I can get it to work.

Should I just copy past your codes or is there any changes I need to make? I am very new with SAS so I might need some very specific directions.

Thomas

Re: Frequencies and percentages in multiple columns with same variable

Astounding — Thu, 02 Feb 2017 13:50:43 GMT

There is just one line that needs to change:

set have;

You have to plug in the name of your data set here.

Re: Frequencies and percentages in multiple columns with same variable

TomKari — Thu, 02 Feb 2017 16:08:47 GMT

Another option is to use the Data > Transpose task in EG. Make sure your data is sorted by "id", and then put "id" in the "Group Analysis By" variable and the three "comp" variables in "Transpose Variables". Then you'll just need a quick query to eliminate the blank cells.

Tom