topic Re: Adding Variables to data set in SAS Programming

Adding Variables to data set

cpmcn19 — Tue, 19 Nov 2019 01:51:05 GMT

Attempting to create new variable top breed based on dog data set. Trying to set top breed to 1 if the breed contains the words in the if statement , and 0 if not. Currently code is:

data_aac_new_variable;

set = dog_data;

if breed = "Bulldog", "Lab", "Terrier", "Shepherd", "Beagle" then Topbreed = 1;

else = 0;

run;

Re: Adding Variables to data set

novinosrin — Tue, 19 Nov 2019 02:15:03 GMT

if breed in ("Bulldog", "Lab", "Terrier", "Shepherd", "Beagle") then

use the IN operator

data _aac_new_variable; 

set dog_data;

if breed in ( "Bulldog", "Lab", "Terrier", "Shepherd", "Beagle") then Topbreed = 1;

else = 0;

run;

Re: Adding Variables to data set

r_behata — Tue, 19 Nov 2019 02:14:02 GMT

Few Issues With the code corrected:

data_aac_new_variable;

set  dog_data;

if breed  in ("Bulldog", "Lab", "Terrier", "Shepherd", "Beagle" ) then Topbreed = 1;

else Topbreed = 0;

run;

data_aac_new_variable;

set = dog_data;
if breed = "Bulldog", "Lab", "Terrier", "Shepherd", "Beagle" then Topbreed = 1;
else = 0;

run;

Re: Adding Variables to data set

cpmcn19 — Tue, 19 Nov 2019 02:29:13 GMT

Thanks for the reply. Is there anyway to add a contains to the if breed in statement? Some data says Lab whereas other data says Labrador

Re: Adding Variables to data set

r_behata — Tue, 19 Nov 2019 02:38:05 GMT

Try :

data _aac_new_variable;

set  dog_data;

if breed  in ("Bulldog",  "Terrier", "Shepherd", "Beagle" ) or breed =:'Lab' then Topbreed = 1;

else Topbreed = 0;

run;

Re: Adding Variables to data set

SASKiwi — Tue, 19 Nov 2019 02:48:33 GMT

You can reduce this to one statement if you use a Boolean expression:

Topbreed = (if breed in ("Bulldog", "Terrier", "Shepherd", "Beagle" ) or breed =:'Lab');