PROC PRINT -- observations limited by percentage of total

Wolverine — Tue, 02 Oct 2018 15:25:29 GMT

I'm running frequencies of variables that have thousands of different values. But I'm only interested in the most frequently-occurring. How can I limit the output to codes that make up, say, 1% or more of the total? That is, in the frequency output table, the "Percent" column should be 1.00 or greater. I'm currently using the following syntax to limit to a specified number of observations, but sometimes that approach leaves out values that I want to look at or include values that occur too infrequently to be bothered with.

PROC FREQ noprint ORDER=FREQ;
	TABLES DX_code /out=medicaid.countout_grp3;
PROC PRINT DATA = medicaid.countout_grp3(obs=100);

RUN;

Re: PROC PRINT -- observations limited by percentage of total

FreelanceReinh — Tue, 02 Oct 2018 15:54:25 GMT

You can use variable PERCENT in the output dataset:

proc print data=medicaid.countout_grp3;
where percent>=1;
run;

Re: PROC PRINT -- observations limited by percentage of total

Wolverine — Tue, 02 Oct 2018 17:22:23 GMT

Simple and effective! Thanks!

topic Re: PROC PRINT -- observations limited by percentage of total in SAS Procedures

PROC PRINT -- observations limited by percentage of total

Re: PROC PRINT -- observations limited by percentage of total

Re: PROC PRINT -- observations limited by percentage of total