topic Re: proc freq getting only first row in SAS Programming

proc freq getting only first row

Ravikumarpa4 — Tue, 21 Mar 2017 15:47:16 GMT

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

Re: proc freq getting only first row

Astounding — Tue, 21 Mar 2017 16:24:40 GMT

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;

Re: proc freq getting only first row

lakshmi_74 — Tue, 21 Mar 2017 16:35:12 GMT

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

Re: proc freq getting only first row

PGStats — Tue, 21 Mar 2017 18:52:58 GMT

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;