topic Re: New Variable combining several codes in SAS Procedures

New Variable combining several codes

Mirisage — Fri, 04 Jun 2010 11:24:23 GMT

Hi Colleagues,

Would appreciate if anyone of you could help on this.

I have 7000 observations like this.

data Family;
input ID Family_type;
cards;
1 1
2 1
3 1
4 2
5 3
6 4
7 6
8 5
9 6
10 4
;
run;

I need to create a new variable called ‘Type’ using the existing variable ‘Family_type’.

Condition is:
If Family_type = 2 or 3 or 4, Type = 4
All other codes of ‘Family_type’ variable should remain the same for newly created ‘Type’ variable too.

I tried the following but did not work.

data Family_1;
set Family;
if Family_type = 2 or Family_type = 3 or Family_type = 4 then Type = 4 ;
if Family_type = 1 then Type = 1;
if Family_type = 5 then Type = 5;
else Type = 6;
run;

I would appreciate if you could help me.
Thank you

Mirisage

Re: New Variable combining several codes

andreas_lds — Fri, 04 Jun 2010 11:44:19 GMT

The problem is your last if/else code:
[pre]
if Family_type = 5 then Type = 5;
else Type = 6;
[/pre]
The else-part sets Type = 6 if Family_type != 5. Try following untested code skips checking the value of Family_type if Type equals Family_type.
[pre]
data Family_1;
set Family;
if Family_type = 2 or Family_type = 3 or Family_type = 4 then Type = 4;
else Type = Family_type;
run;[/pre]
The if-statement can be made easier to understand by using the in-operator:
[pre]...
if Family_type in (2, 3) then Type = 4;
else Type = Family_type;
...[/pre]

Re: New Variable combining several codes

sbb — Fri, 04 Jun 2010 11:44:43 GMT

Check for missing "ELSE" operator in some of your IF / THEN statements.

A useful debugging technique when desk-checking your program is to insert the statement below which will generate additional diagnostic information (about variable values) along the course of your DATA step (increment "nn" below when you have multiple of these lines in your program for identification):

PUTLOG '>DIAG-nn>' / _ALL_;

Scott Barry
SBBWorks, Inc.

Re: New Variable combining several codes

sas_ — Mon, 07 Jun 2010 08:52:49 GMT

Try this.

data Family_1;
set Family;
if Family_type=2 or Family_type=3 or Family_type=4 then Type=4 ;
if Family_type= 1 then Type=1;
if Family_type= 5 then Type=5;
if type=. then type=Family_type;
run;

Re: New Variable combining several codes

Mirisage — Mon, 07 Jun 2010 14:58:14 GMT

Hi andreas_lds, sas_ and sbb,

Thank all of you. All the codes suggested by you all worked quite well.

Regards

Mirisage

Re: New Variable combining several codes

dhana — Tue, 08 Jun 2010 08:20:33 GMT

DATA FAMILY_1;
SET FAMILY;
IF Family_type IN (2,3,4) THEN TYPE=4;
ELSE TYPE=Family_type;
RUN;