topic UPDATE PROBLEM in SAS Procedures

UPDATE PROBLEM

tmm — Mon, 19 Mar 2012 18:35:04 GMT

I am really not doing this right. I have this code

proc sql;

update table

set ((desc = n/a if cd is null) and (cd = 0 if desc = n/a) and

(desc = minor if cd = 1) and (desc = moderate if cd =2) and

(desc = major if cd = 3) and (desc = extreme if cd = 4));

run;

I think my code is just not right

Re: UPDATE PROBLEM

Haikuo — Mon, 19 Mar 2012 18:46:38 GMT

Try this:

proc sql;

update table yourtablename

set desc=

case

when cd is null

then 'n/a'

when cd=1

then 'minor'

when cd=2

then 'moderate'

when cd=3

then 'major'

when cd=4

then 'extreme'

else 'others'

end;

update table want

set cd=0 where desc='n/a';

quit;

UPDATE PROBLEM

tmm — Mon, 19 Mar 2012 19:00:18 GMT

I get errors saying: expressions using equals (=) has components that are different data types

Re: UPDATE PROBLEM

Haikuo — Mon, 19 Mar 2012 19:04:15 GMT

You need to let us know the variable type of your variables: cd and desc. is 'cd' numeric?

You find the info by running:

1. proc sql;

describe table yourtablename;

quit;

2. proc contents data=your tablename;

run;

After knowing the types of your variables, you will be able to make changes.

Regards,

Haikuo

UPDATE PROBLEM

tmm — Mon, 19 Mar 2012 19:24:51 GMT

They are both text fields

UPDATE PROBLEM

tmm — Mon, 19 Mar 2012 19:26:12 GMT

I got it to work by putting ' ' around the 0-4 and it worked

UPDATE PROBLEM

Haikuo — Mon, 19 Mar 2012 19:28:05 GMT

Well, then:

proc sql;

update table yourtablename

set desc=

case

when cd is null

then 'n/a'

when strip(cd)='1'

then 'minor'

when strip(cd)='2'

then 'moderate'

when strip(cd)='3'

then 'major'

when strip(cd)='4'

then 'extreme'

else 'others'

end;

update table want

set cd='0' where desc='n/a';

quit;

UPDATE PROBLEM

Haikuo — Mon, 19 Mar 2012 19:28:29 GMT

There you go!