Formating proc freq output table

[Priyamvada07]

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!

[andreas_lds · Accepted solution]

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;

[Priyamvada07]

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!

[andreas_lds]

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

[Priyamvada07]

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?

[andreas_lds]

---

@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;

[Watts]

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. 

[Priyamvada07]

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?