Help using Base SAS procedures

Output multiple proc freqs to text file

Accepted Solution Solved
Reply
Super Contributor
Posts: 398
Accepted Solution

Output multiple proc freqs to text file

Hello,

I'm trying to create a report based off of the freq of multiple variables.  This is how I'm currently doing it.

filename rptTemp "c:\temp\temp.txt" ;

proc printto print=rptTemp new ;

run ;

title 'Frequency var1 from tempData' ;

proc freq data = tempData ;

    table var1 /nocol norow nopercent missing;

run ;

title 'Frequency var2 from tempData' ;

proc freq data = tempData ;

    table var2 /nocol norow nopercent missing;

run ;

title 'Frequency var3 from tempData' ;

proc freq data = tempData ;

    table var3 /nocol norow nopercent missing;

run ;

title;

proc printto;

run ;

1. Is there a better way to do this?

2. How can I add a blank row after each proc freq?

3. There are about 10 variables I need to do this for to see exactly what is contained in the dat

Thank you


Accepted Solutions
Solution
‎03-31-2015 12:28 PM
Super User
Posts: 17,819

Re: Output multiple proc freqs to text file

Can you include all your variables in a single proc freq?

  1. proc freq data = tempData ; 
  2.     table _all_ /nocol norow nopercent missing; 
  3. run ; 

View solution in original post


All Replies
Solution
‎03-31-2015 12:28 PM
Super User
Posts: 17,819

Re: Output multiple proc freqs to text file

Can you include all your variables in a single proc freq?

  1. proc freq data = tempData ; 
  2.     table _all_ /nocol norow nopercent missing; 
  3. run ; 
Super Contributor
Posts: 398

Re: Output multiple proc freqs to text file

I always miss the obvious.  Sorry for wasting your time.  I was looking at it a bit differently.

Thank you again.

☑ This topic is SOLVED.

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

Discussion stats
  • 2 replies
  • 195 views
  • 0 likes
  • 2 in conversation