topic Re: How do I only show frequency in the PROC FREQ? in SAS Data Management

How do I only show frequency in the PROC FREQ?

christinagting0 — Mon, 29 Aug 2016 15:38:13 GMT

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!

Re: How do I only show frequency in the PROC FREQ?

jklaverstijn — Mon, 29 Aug 2016 15:48:03 GMT

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

Hope this helps,

- Jan.

Re: How do I only show frequency in the PROC FREQ?

christinagting0 — Mon, 29 Aug 2016 15:49:10 GMT

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;

Re: How do I only show frequency in the PROC FREQ?

Jagadishkatam — Mon, 29 Aug 2016 15:51:06 GMT

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

proc freq data=have;

table x*y / nocol corow nopercent;

run;