BookmarkSubscribeRSS Feed
Sas_R
Calcite | Level 5

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;

3 REPLIES 3
PaigeMiller
Diamond | Level 26

ods output onewayfreqs=freqs;

proc freq data=sashelp.class;

table height weight;

run;

--
Paige Miller
ballardw
Super User

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.

Reeza
Super User

has a small typo,

XML in the tagset name rather than xlm...

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

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 873 views
  • 6 likes
  • 4 in conversation