topic Re: Question about mean replacement using proc standard in SAS Programming

Question about mean replacement using proc standard

burtsm — Tue, 09 Apr 2013 23:28:10 GMT

Hi all,

Is there a way to only replace certain missing values with the mean of a sample using proc standard? The data I am working with have 3 different types of missing values:

Missing Value Code	Description
.s	Not applicable, including legitimate skips
.m	Item nonresponse (i.e. refused, don’t know, not ascertained)
.	System missing, including unit nonresponse

I only want to replace missing values that indicate item nonresponse (.m) with the mean of the sample, but I am not sure how to go about it.

Thanks in advance,

Stephanie

Re: Question about mean replacement using proc standard

RichardinOz — Tue, 09 Apr 2013 23:36:58 GMT

Quick and dirty:

Create a flag that has values S M and N to match the missing values

Pass through Proc Standard

Use the S and N flag to restore the correct missing values

Richard

Re: Question about mean replacement using proc standard

burtsm — Tue, 09 Apr 2013 23:44:14 GMT

Thank you for your response, Richard! My mind was drawing a blank on how to do this.