Help using Base SAS procedures

Proc freq output

Reply
Occasional Contributor
Posts: 10

Proc freq output

Hi All,

I'm trying to output frequency of my variables to an output data set or file instead of manually getting the freq from output window and type to excel file.  When I use the out option, sas only gives one variable's result to output data set.

Is there a way to do this in proc freq or I need to use another proc or macro ?  Thank you.

proc freq data=mydata;

tables

P001_1

P001_2

P001_3

P001_4

P001_5

P001_6

/  out=FreqCount ;

run;

Trusted Advisor
Posts: 1,931

Re: Proc freq output

ods output onewayfreqs=freqs;

proc freq data=sashelp.class;

table height weight;

run;

Super User
Posts: 11,343

Re: Proc freq output

Posted in reply to PaigeMiller

or

Ods tagsets.excelxp file="C:\path\filename.xlm";

proc freq data=mydata;

tables

P001_1

P001_2

P001_3

P001_4

P001_5

P001_6

;

run;

ods tagsets.excelxp close;

open the resulting XML file in Excel and save as xls(x) as needed.

Super User
Posts: 19,822

Re: Proc freq output

has a small typo,

XML in the tagset name rather than xlm...

Ods tagsets.excelxp file="C:\path\filename.xml";

Ask a Question
Discussion stats
  • 3 replies
  • 335 views
  • 6 likes
  • 4 in conversation