How do I only show frequency in the PROC FREQ?

[christinagting0]

Really simple...

I am running a bunch of proc freqs, but I need to make a million graphs and when I export the proc freqs to an excel it's not allowing me to unmerge the cells making it very tedious to create graphs quickly in excel.

How do I remove the percent, row percent and col percent from my output? I only want to see frequency.

thanks!

[jklaverstijn · Accepted solution]

If this is using proc freq, add the options NOPERCENT NOCUM to your TABLES statement.

Hope this helps,

- Jan.

[christinagting0]

awesome thank you. I was using that but forgot the "/" in my code!

Here is my final line in my code:

tables site*tsi_acc_rs_cat / norow nofreq nocol;

[Jagadishkatam]

Please use nocol, norow and nopercent options to suppress them in the output.

proc freq data=have;

table x*y / nocol corow nopercent;

run;