proc freq getting only first row

[Ravikumarpa4]

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

[Astounding]

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 · Accepted solution]

proc freq data=sashelp.class(where=(age=11));
tables age;run;

[PGStats]

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;