topic how to assign 2 different values of a new variable according to the values of an existing variable in SAS Programming

how to assign 2 different values of a new variable according to the values of an existing variable

jeniffer_jacob — Mon, 21 May 2018 16:22:04 GMT

I tried to assign 2 different values (1, 0) of a new variable according to the value of an existing variable.

data test2;

set test;

if target in ("rain", "snow") then target_kgb = "1";

else if target = "sunny" then target_kgb = "0";

run;

But I can only assign 1 to target_kgb if target in rain or snow. 0 was not assigned to target_kgb even though there were many "sunny" for target.

Any help is highly appreciated.

Thank a lot.

Re: how to assign 2 different values of a new variable according to the values of an existing variab

jklaverstijn — Mon, 21 May 2018 16:40:02 GMT

Check the length of your variable "target". Without anything else it will be defined as $4 because "rain" is the first possible value the datastep finds. it is safer to add a statement

length target $5;

before the if-then-else statements. This will prevent "sunny" to be truncated to "sunn" which never matches "sunny". Possibly this is already happening in the creation of dataset test. We would need to see more of your program and logs to know for sure. Do a proc contents on dataset test.

Hope this helps,

-- Jan

Re: how to assign 2 different values of a new variable according to the values of an existing variab

Astounding — Mon, 21 May 2018 16:33:59 GMT

Your code is perfect. Most likely, the data are a little bit different. For example, none of these would produce a match with "sunny":

Sunny

s u n n y

suny

SUNNY

sunny

Character strings must match exactly.

Re: how to assign 2 different values of a new variable according to the values of an existing variab

Amir — Mon, 21 May 2018 16:40:54 GMT

Hi,

Your data step code worked OK for me when I tried the following data:

data test;
   input target $8.;
   datalines;
rain
snow
sunny
;

data test2;
   set test;
   if target in ("rain", "snow") then target_kgb = "1";
   else if target = "sunny" then target_kgb = "0";
run;

Perhaps you have a leading space(s) before "sunny" in the variable target, in which case you could try using:

else if left(target) = "sunny" then target_kgb = "0";

If that works then I recommend you use left(target) wherever you have target.

Regards,

Amir.

Re: how to assign 2 different values of a new variable according to the values of an existing variab

jeniffer_jacob — Mon, 21 May 2018 17:38:12 GMT

"sunny" is actually "Sunny".

Thanks to all!