topic Re: Suppressing Small Sample in SURVEY in SAS Programming

Suppressing Small Sample in SURVEY

johnsonemilyk — Wed, 14 Mar 2018 19:41:12 GMT

I'm wondering if there's a way to automatically filter output that doesn't meet user-determined suppression rules. I would like to find a way to automatically censor data with fewer than six unweighted responses and/or a relative standard error of 30 percent or more.

For example, in the procedure below -- let's say there are only three men below the poverty line in my unweighted sample. I would like to then exclude that value from the table.

PROC SURVEYFREQ DATA=mydata;
TABLE gender*income / ROW CL CHISQ;
WEIGHT pop_weight; STRATA region;
TITLE "Analysis of Gender and Income";
RUN;

Thanks!

Re: Suppressing Small Sample in SURVEY

Reeza — Wed, 14 Mar 2018 19:57:17 GMT

You can build a custom formats that shows those values as *****?

It depends on what you mean by 'filter', would that mean exclude entirely or mask?

@johnsonemilyk wrote:

I'm wondering if there's a way to automatically filter output that doesn't meet user-determined suppression rules. I would like to find a way to automatically censor data with fewer than six unweighted responses and/or a relative standard error of 30 percent or more.

For example, in the procedure below -- let's say there are only three men below the poverty line in my unweighted sample. I would like to then exclude that value from the table.

PROC SURVEYFREQ DATA=mydata;
TABLE gender*income / ROW CL CHISQ;
WEIGHT pop_weight; STRATA region;
TITLE "Analysis of Gender and Income";
RUN;

Thanks!

Re: Suppressing Small Sample in SURVEY

ballardw — Wed, 14 Mar 2018 20:41:52 GMT

Send the desired output to a dataset using the ODS OUTPUT statement.

PROC SURVEYFREQ DATA=mydata;
TABLE gender*income / ROW CL CHISQ;

ods output chisq =gender_income_chi;

ods output crosstabs= gender_income_cross;
WEIGHT pop_weight; STRATA region;
TITLE "Analysis of Gender and Income";
RUN;

Would send the results of the CHISQ test to a dataset named gender_income_chi and the counts and such from the crosstab to a set gender_income_cross.

Then use any of the reporting procedures and options to display, subset or manipulated the data in the dataset as desired.

Re: Suppressing Small Sample in SURVEY

johnsonemilyk — Thu, 29 Mar 2018 20:31:12 GMT

Thanks Reeza! A custom format may work. Either excluding entirely or masking should function, though. I'll see about doing a custom format.