topic Re: Creating new Variable value based on current observation in SAS Data Science

Creating new Variable value based on current observation

mlogan — Wed, 29 Jul 2015 00:18:54 GMT

Hi All,

I have the following data set.

I want to create a new variable call New_ID and give them a corresponding Character value if ID=1-3 then New_ID='USA'; if ID=4 then New_ID='Germany'. Can someone tell me if I can do it without format function.

ID New_ID

1 USA

2 USA

3 USA

4 Germany

Thanks,able

Re: Creating new Variable value based on current observation

Miracle — Wed, 29 Jul 2015 00:36:50 GMT

Hi there.

Perhaps you could try this?

data in;

input ID @@;

datalines;

1 2 3 4

;

run;

data want;

set in;

attrib New_ID length=$10.;

if ID in(1:3) then New_ID='USA';

else New_ID='Germany';

run;

proc print noobs; run;

Re: Creating new Variable value based on current observation

mlogan — Wed, 29 Jul 2015 18:03:02 GMT

Thanks Wong, It worked perfect. Can you please tell me what should I do if there are 3 category?

I want the New_ID as: value 1 to 6 = Germany, 7 to 11 = USA, 12 to 15 = Germany and missing value (.) = N/A

I wrote the following code and it's not working. Can you please help. Thanks,

data want;

set in;

attrib New_ID length=$10.;

if ID in(7:11) then New_ID='USA';

if ID in(.) then New_ID='N/A';

else New_ID='Germany';

run;

proc print noobs; run;

Re: Creating new Variable value based on current observation

ballardw — Wed, 29 Jul 2015 18:22:15 GMT

You are getting all "Germany" values except for .

because of

if ID in(.) then New_ID='N/A';

else New_ID='Germany';

ANY value of ID at this point other than . will yield "Germany".

You want need:

if ID in(7:11) then New_ID='USA';

else if ID in(.) then New_ID='N/A';

else New_ID='Germany';