BookmarkSubscribeRSS Feed
mesfandiari
Calcite | Level 5

I am in need of a SAS/MACRO that freqs every column within a sas dataset.

3 REPLIES 3
Astounding
PROC Star

I don't think macros have anything to do with it.  You can simply use:

 

proc freq data=have;

tables _all_;

run;

ballardw
Super User

@Astounding wrote:

I don't think macros have anything to do with it.  You can simply use:

 

proc freq data=have;

tables _all_;

run;


And actually the tables statement is optional in this case.

 

Reeza
Super User

Some other options that may be helpful:

 

In SAS EG try the Tasks>Describe>Characterize Data

 

In SAS Studio try Tasks>Data>Data Exploration> select your categorical/continuous variables. 


Both will also have the code in the log that you can explore if desired.

 


@mesfandiari wrote:

I am in need of a SAS/MACRO that freqs every column within a sas dataset.




hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 3 replies
  • 1339 views
  • 2 likes
  • 4 in conversation