SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

How do I only show frequency in the PROC FREQ?

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 88
Accepted Solution

How do I only show frequency in the PROC FREQ?

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!


Accepted Solutions
Solution
‎08-29-2016 11:49 AM
Super Contributor
Posts: 408

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

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

 

Hope this helps,

- Jan.

View solution in original post


All Replies
Solution
‎08-29-2016 11:49 AM
Super Contributor
Posts: 408

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

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

 

Hope this helps,

- Jan.

Frequent Contributor
Posts: 88

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

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;
Trusted Advisor
Posts: 1,131

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

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

 

proc freq data=have;

table x*y / nocol corow nopercent;

run;

 

Thanks,
Jag
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 2008 views
  • 3 likes
  • 3 in conversation