topic Re: Proc freq output in SAS Procedures

Proc freq output

Sas_R — Tue, 24 Sep 2013 19:40:59 GMT

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;

Re: Proc freq output

PaigeMiller — Tue, 24 Sep 2013 19:53:44 GMT

ods output onewayfreqs=freqs;

proc freq data=sashelp.class;

table height weight;

run;

Re: Proc freq output

ballardw — Tue, 24 Sep 2013 21:32:59 GMT

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.

Re: Proc freq output

Reeza — Tue, 24 Sep 2013 22:10:43 GMT

has a small typo,

XML in the tagset name rather than xlm...

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