topic Re: Formating proc freq output table in SAS Programming

Formating proc freq output table

Priyamvada07 — Fri, 26 Mar 2021 06:35:27 GMT

Hi!

I have the following data

DATA HAVE;
input year dz area;
cards;
2000 1 08
2000 1 06
2000 1 06
;
run;

proc freq data=have;
table area*dz / norow nocol;
run;

I get the following output

I would like to format it to put frequency in one column and percent in another column (and I don't want the total column) rather than the default SAS output. Is there a way to do it?

Thank you!

Re: Formating proc freq output table

andreas_lds — Fri, 26 Mar 2021 06:51:37 GMT

I don't know how to get the expected output with proc freq. Proc tabulate could be used:

proc tabulate data=have;
   class area;
   var dz;

   table area, dz*(n colpctn);
run;

Re: Formating proc freq output table

Priyamvada07 — Fri, 26 Mar 2021 07:33:06 GMT

Thank you, proc tabulate does the work but only for numeric variables. Can I use proc tabulate to get similar output if one of the variables is a character variable?

DATA HAVE;
input year dz $8. area;
cards;
2000 stroke 08
2000 stroke 06
2000 stroke 06
;
run;

when I use the code provided, it gives me: ERROR: Variable dz in list does not match type prescribed for this list.

Thank you!

Re: Formating proc freq output table

andreas_lds — Fri, 26 Mar 2021 10:01:50 GMT

Just move dz from the var statement into the class statement and remove the empty var statement.

Re: Formating proc freq output table

Watts — Fri, 26 Mar 2021 15:21:12 GMT

You can use the LIST option in PROC FREQ.

proc freq data=have;
tables area * dz / list nocum;
run;

The NOCUM option suppresses the cumulative frequencies and percents.

Re: Formating proc freq output table

Priyamvada07 — Tue, 30 Mar 2021 20:08:57 GMT

Hi! I just realized when using proc tabulate I am missing the last row that is the 'total' as seen in my output image in the original question. Is there a way to retain the 'total' column?

Re: Formating proc freq output table

Priyamvada07 — Tue, 30 Mar 2021 20:10:47 GMT

Hi! I just realized when using this code I am missing the last row that is the 'total' as seen in my output image in the original question. Is there a way to retain the 'total' column?

Re: Formating proc freq output table

andreas_lds — Wed, 31 Mar 2021 06:28:42 GMT

@Priyamvada07 wrote:
Hi! I just realized when using proc tabulate I am missing the last row that is the 'total' as seen in my output image in the original question. Is there a way to retain the 'total' column?

Yes, of course using the "all" keyword in the tables-statement. Can't test it now, but the following code should work.

proc tabulate data=have;
   class area;
   var dz;

   table area all, dz*(n colpctn);
run;