topic Re: convert numeric variable to missing in SAS Programming

convert numeric variable to missing

Amy0223 — Thu, 28 Nov 2019 17:02:26 GMT

Hi! I'm a little confused about the question below and not sure how to code it. Any input is greatly appreciated. Thank you!

A sas dataset has the following values for its 35 numeric variables:

99 Do not know

98 Refused to answer

97 Skipped question

Write the data step statement to convert these values to the standard sas missing value (.)

Re: convert numeric variable to missing

Reeza — Thu, 28 Nov 2019 17:19:34 GMT

@Amy0223 wrote:

Hi! I'm a little confused about the question below and not sure how to code it. Any input is greatly appreciated. Thank you!

A sas dataset has the following values for its 35 numeric variables:

99 Do not know

98 Refused to answer

97 Skipped question

Write the data step statement to convert these values to the standard sas missing value (.)

Here's an example you can run based on the CLASS data set. I prefer to use CALL MISSING to set values to missing because it works the same for numeric and character variables.

Depending on what you've been studying so far, if this is homework, you may need to use the approach taught in class rather than what I've posted.

data example;
set sashelp.class;

if age in (12, 13, 14) then call missing(age);



*if age=12 or age=13 or age=14 then age = . ;

run;

Re: convert numeric variable to missing

Amy0223 — Thu, 28 Nov 2019 17:23:31 GMT

Thank you very much for your kind help! I greatly appreciate it!

Re: convert numeric variable to missing

Amy0223 — Fri, 29 Nov 2019 02:59:22 GMT

Does this answer look right? I'm not sure what I need to do with 35 numeric variables.

Data zz;
input x response $18.;
cards;
99 Do not know
98 Refused to answer
97 Skipped question
;
run;
proc print;
run;

data zz1;
set zz;
if x in (99, 98, 97) then call missing(x);
run;
proc print;
run;

Re: convert numeric variable to missing

Tom — Fri, 29 Nov 2019 04:23:57 GMT

A good way to do the same thing for more than one variable is to use an array. Did you learn how to use an array?

Re: convert numeric variable to missing

Amy0223 — Fri, 29 Nov 2019 04:27:04 GMT

Yes, I'll try this again using array. Thank you so much!