topic Re: Another problem in SAS Procedures

Another problem

R_A_G_ — Wed, 02 Mar 2011 18:50:58 GMT

I was wondering how I can reverse the value of my dichotomous items that are 0 to 1 and those that are 1 to 0.

I have 4 items I am doing this within a Macro and it is not working

DATA WR;
set Matrix;
DO i=1 TO &numi;

if skills(i)=0 THEN skills(i)=1;
ELSE if SKILLS(i)=1 then skills(i)=0;
end;
run;

Re: Another problem

Doc_Duke — Wed, 02 Mar 2011 19:06:03 GMT

An easy way to do this for dichotomous variables is to use code like

skills(i) = 1 - skills(i);

Re: Another problem

R_A_G_ — Wed, 02 Mar 2011 19:11:19 GMT

Thank you Doc,

But what if the skill=0

my data looks like this

skill1 kills2 skills3 skills4
0 1 1 0
1 0 1 1

and so on,

I need to change all 1's to 0 and all 0's to 1

Thank you

Re: Another problem

Doc_Duke — Wed, 02 Mar 2011 19:12:48 GMT

Try it.

1 - 0 = 1
1 - 1 = 0

Re: Another problem

R_A_G_ — Wed, 02 Mar 2011 19:14:25 GMT

I feel dumb 😞
sorry
and thanks Doc

Re: Another problem

R_A_G_ — Wed, 02 Mar 2011 19:55:58 GMT

help!!

I am getting the following error,

DATA WR;
set Matrix;
do i=1 to 4;

skills(i)=1- skills(i);
END;
run;

I am getting the following error why?

16821 skills(i)=1- skills(i);
------
68
ERROR: Undeclared array referenced: skills.
ERROR: Variable skills has not been declared as an array.
ERROR 68-185: The function SKILLS is unknown, or cannot be accessed.

16822 END;

Re: Another problem

RickM — Wed, 02 Mar 2011 20:07:51 GMT

You need to declare an array before using it.

DATA WR;
set Matrix;
array skills(4);
do i=1 to 4;
skills(i)=1- skills(i);
END;
run;

Re: Another problem

R_A_G_ — Wed, 02 Mar 2011 20:11:41 GMT

THANK YOU
It worked!!