topic Recode all instances of -5 to missing in SAS Programming

Recode all instances of -5 to missing

rfarmenta — Mon, 17 Mar 2014 19:41:31 GMT

I have an interesting case where all values of -5 in my dataset should be set to missing. I don't want to have to do this for every variable separately, is there way to recode all instances of -5 in the dataset as missing or .S? Any help would be greatly appreciated. This came about from the way a QDS interview was programmed for skipped questions. Thank you in advance!

Re: Recode all instances of -5 to missing

ballardw — Mon, 17 Mar 2014 19:52:46 GMT

At this point you may want something like:

data want;

set have;

array n _numeric-;

do _i_=1 to dim(n);

if n[_i_] = -5 then n[_i_] = .;

end;

run;

Re: Recode all instances of -5 to missing

rfarmenta — Mon, 17 Mar 2014 20:35:57 GMT

Do I have to assign the array for all of my variables? I am a little confused by your code, whar does the n_numeric refer to? I was able to get the code to run but it did not do anything to the -5. Thank you for your reply!

Re: Recode all instances of -5 to missing

Quentin — Mon, 17 Mar 2014 21:05:56 GMT

looks like just a typo in ballardw's suggestion.

It should be:

array n _numeric_ ;

n is the name of the array.

_numeric_ is a special name meaning "all numeric variables".

I think your initial thought to use .S intead of . also has merit.

Re: Recode all instances of -5 to missing

rfarmenta — Mon, 17 Mar 2014 21:07:24 GMT

I just noticed the typo and got it to run, I used .S and everything seemed to work correctly. Thank you all for your suggestions.