topic Manipulating proc freq output in SAS Procedures

Manipulating proc freq output

HyunJee — Mon, 26 Sep 2011 13:23:32 GMT

I created some proc freq table of diagnosis codes by patient. In the output, the tables have the patient="patient name" listed at the top of every table. Is there any way to create a table with the patient name as a column in the frequency table?

so instead of being formatted as such:

patient

diagnosis frequency percent

would be like this instead:

patient diagnosis frequency percent

Manipulating proc freq output

art297 — Mon, 26 Sep 2011 13:46:12 GMT

You didn't provide the code you were using, sample data, and/or the result you want to obtain. It sounds like you are currently using patient as a by variable and simply want to include it in your tables statement. e.g.,

proc freq data=sashelp.class;

tables name*age;

run;

instead of:

proc freq data=sashelp.class;

tables age;

by name;

run;

Re: Manipulating proc freq output

HyunJee — Mon, 26 Sep 2011 13:46:39 GMT

So I figured out on possible option. I wanted to post the answer I had come to. Create a dataset of the frequencies. This will give what I was wanting above. Works great too.

proc freq data=dataset noprint;

tables diagnosis*patient/norow nocol nopercent out = freq_pt_dx;run;

Manipulating proc freq output

HyunJee — Mon, 26 Sep 2011 13:48:46 GMT

Sorry about that Art. I did use this code:

proc freq data=sashelp.class;

tables age;

by name;

But I had so many names that I could manipulate the outputed data like I had wanted.

I found that if I created a dataset of the frequencies of age*name, the dataset created was much more manageable in excel.

Thank you for your help and input always helpful!

Manipulating proc freq output

Tom — Mon, 26 Sep 2011 13:49:43 GMT

As Art says add PATIENT to your TABLES statement. If you want it as a list then use the LIST option. Otherwise you will get a grid with #rows equal to the number of patients and #cols equal to the number of categories.

TABLES patient*diagnosis / list ;