BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
Ravikumarpa4
Obsidian | Level 7

below example how to get only first row in output

proc freq data=sashelp.class;
tables age;run;

need only highlited in output window instead of getting all

Untitled.png

1 ACCEPTED SOLUTION

Accepted Solutions
lakshmi_74
Quartz | Level 8
proc freq data=sashelp.class(where=(age=11));
tables age;run;

View solution in original post

3 REPLIES 3
Astounding
PROC Star

PROC FREQ prints the whole table (or alternatively, none of the table).  But you can work around that if you find a slightly different report format satisfactory:

 

proc freq data=have;

tables age / noprint out=counts;

run;

 

proc print data=counts (obs=1);

run;

lakshmi_74
Quartz | Level 8
proc freq data=sashelp.class(where=(age=11));
tables age;run;
PGStats
Opal | Level 21

Another way:

 

proc freq data=sashelp.class noprint;
tables age / out=counts;
run;

proc sql;
create table firstCount as
select * from counts
having age=min(age);
select * from firstCount;
quit;
PG

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 2817 views
  • 1 like
  • 4 in conversation