topic Consolidating responses to create a new variable in SAS Procedures

Consolidating responses to create a new variable

Mirisage — Thu, 29 Apr 2010 16:04:32 GMT

Hi Colleagues,

Would appreciate if any one of you could help me.

I have a data set like this.

Data hs;
Input ID food_run;
CARDS;
1 1
2 2
3 3
4 3
5 2
6 1
7 7
8 8
9 9
;
RUN;

In food-run variable,
1=often true
2=sometimes true
3=never true
4=don’t know
5=refusal
6=not stated

I need to create a new variable called WORRIED like this.

If the response for variable food_run = 1 or 2 then WORRIED=1
If the response for variable food_run = 3 then WORRIED=2
If the response for variable food_run = 4 or 5 or 6 then WORRIED=missing or .

I attempted like this but this does not work properly.
Data hs1;
Set hs;
If food_run = 1 or 2 then WORRIED=1;
If food_run = 2 then WORRIED=2;
Else WORRIED=.;
Run;

Could you please assist to write the correct program.

Thanks

Mirisage

Re: Consolidating responses to create a new variable

Flip — Thu, 29 Apr 2010 16:09:15 GMT

If food_run = 1 or 2 should be if food_run in(1,2); or
If food_run = 1 or food_run = 2;

Re: Consolidating responses to create a new variable

Mirisage — Thu, 29 Apr 2010 16:37:38 GMT

Hi Flip,

Thank you very much.

I tried your both suggestions but they didn't work. However, I removed the statement 'else .' and then both of your suggestions worked well.

Hope it is not an accident and it should be the way, isn't it?

Data hs1;
Set hs;
If food_run =1 or food_run= 2 then WORRIED=1;
If food_run = 3 then WORRIED=2;

Run;

Data hs1;
Set hs;
If food_run in(1,2)then WORRIED=1;
If food_run = 3 then WORRIED=2;

Run;

thank you

Mirisage

Re: Consolidating responses to create a new variable

Flip — Thu, 29 Apr 2010 17:11:52 GMT

use an else if for the second one.

else If food_run = 2 then WORRIED=2;

Re: Consolidating responses to create a new variable

Mirisage — Thu, 29 Apr 2010 17:30:02 GMT

Hi Flip, this is great!

Worked very well.

Thanks again!

Mirisage Neil