topic Re: IF CONDITION IN SAS in SAS Procedures

IF CONDITION IN SAS

robertrao — Wed, 20 Nov 2013 20:16:15 GMT

I am getting the following error message when I use the code below

Could someone point me in the right direction????

data want;

set have;

if code in('180'-'310.99') then code_Descrip="AIDS";

else if code in('333.0'-'333.9', '334.0'-'334.9') then code_Descrip="FEVER";

else code_Descrip="OTHER";

run;

ERROR 22-322: Syntax error, expecting one of the following: a quoted string,
a numeric constant, a datetime constant, a missing value, iterator, (, ), ','.

ERROR 200-322: The symbol is not recognized and will be ignored.

ERROR 76-322: Syntax error, statement will be ignored.

Thanks

Re: IF CONDITION IN SAS

PaigeMiller — Wed, 20 Nov 2013 20:23:31 GMT

you want to separate the possible values in the IN condition with a comma, not a hyphen as you did

Re: IF CONDITION IN SAS

Reeza — Wed, 20 Nov 2013 20:26:32 GMT

Are you looking for ranges of codes rather than the two codes alone?

Re: IF CONDITION IN SAS

snoopy369 — Wed, 20 Nov 2013 20:30:16 GMT

if 180 le input(code,BEST12.) le 310.99 may be the better way to do this. IN with colon doesn't work with decimals (it expands the integers only).

Re: IF CONDITION IN SAS

robertrao — Wed, 20 Nov 2013 20:32:18 GMT

Yes.I am looking for the ranges.

How can i use proc format??Is it possible?

Thnks

Re: IF CONDITION IN SAS

PaigeMiller — Wed, 20 Nov 2013 20:37:18 GMT

Range:

if code>=180 and code<=310.99 then code_Descrip="AIDS";

Re: IF CONDITION IN SAS

esjackso — Wed, 20 Nov 2013 20:38:02 GMT

Yeah it looks like they want a range of ICD9 codes?

if you are looking for the full set of codes you could test the substr of the first three characters and test that result.

Ive also used format and put statements for more complex health care codes.

Re: IF CONDITION IN SAS

Reeza — Wed, 20 Nov 2013 20:46:53 GMT

You need to use formats to define the categories and then apply them generally.

proc format;

value $ icdfmt

'180'-'310.99~' = 'AIDS'

'333.0'-'333.9~', '334.0'-'334.9~'='Fever'

other = 'Other';

run;

Are you using Standard ICD9/10 or some other classification system? If so the University of Manitoba has SAS code that provides different classifications.

Re: IF CONDITION IN SAS

Reeza — Wed, 20 Nov 2013 20:55:28 GMT

http://mchp-appserv.cpe.umanitoba.ca/Upload/SAS/_ElixhauserICD10.sas.txt

Re: IF CONDITION IN SAS

robertrao — Wed, 20 Nov 2013 21:00:04 GMT

Hi,

Thanks for the reply,

This is not a standard classification. I was giving it in general.

I have a question in your code..

WHAT IS THE CURLY HYPHEN????WHATS ITS USE???

'180'-'310.99~'

Thanks

Re: IF CONDITION IN SAS

Reeza — Wed, 20 Nov 2013 21:16:28 GMT

So 180 and 310.99 are not ICD codes? If not, then please disregard my posts.

Re: IF CONDITION IN SAS

robertrao — Wed, 20 Nov 2013 21:27:36 GMT

HERE you Go..

These are ICD9 codes

data want;

set have;

if code in('410.0'-414.09) then code_Descrip="HEART DISEASE";

else if code in('250.0'-'250.6', '250.52'-'250.93) then code_Descrip="DIABETES";

else code_Descrip="OTHER";

run;

If this format works for ICD9 then could you explain to me about the ~

proc format;

value $ icdfmt

'410.0'-414.09~' = 'HEART DISEASE'

'250.0'-'250.6~', '250.52'-'250.93~'='DIABETES'

other = 'Other';

run;

Re: IF CONDITION IN SAS

Reeza — Wed, 20 Nov 2013 22:37:15 GMT

A general programming principle I was taught and follow is if you're recoding something check the boundaries, by checking just above, the boundary and just below and a few random values between. This will catch most recoding mistakes.

See the example below and look at the what happens for Diabetes and 250.59 and 250 rather than 250.0

proc format;

value $ icdfmt

'410.0'-'414.9~' = 'HEART DISEASE'

'250.0'-'250.6'='DIABETES'

other = 'Other';

invalue $ icdfmt

'410.0'-'414.9~' = 'HEART DISEASE'

'250.0'-'250.6'='DIABETES'

other = 'Other';

run;

data random;

input code $;

cards;

410.23

410.05

410

410.0

411.1

411.23

413.99

414

414.9

414.99

415.0

415

416

250.0

250

250.99

250.6

250.69

250.99

245.3

;

run;

data check;

set random;

icd_code=code;

format icd_code $icdfmt.;

icd_code2=input(code, $icdfmt.);

run;

Re: IF CONDITION IN SAS

Tom — Wed, 20 Nov 2013 23:13:49 GMT

You need to understand how SAS (or really any computer program) orders text strings. It is called lexicographical ordering and it works like looking up a word in the dictionary.

if ('180' <= code <= '310.99') then code_Descrip="AIDS ";

else if ('333.0' <= code <= '334.9') then code_Descrip="FEVER";

else code_Descrip="OTHER";

Might work for your data, depends on how messy the CODE variable is.

Re: IF CONDITION IN SAS

robertrao — Thu, 21 Nov 2013 00:35:59 GMT

Hi Tom,

would this code select 180.0 and 180.00???

Secondly, why do we use ~ in the below code????????/

proc format;

value $ icdfmt

'180'-'310.99~' = 'AIDS'

'333.0'-'333.9~', '334.0'-'334.9~'='Fever'

other = 'Other';

run;

Re: IF CONDITION IN SAS

Reeza — Thu, 21 Nov 2013 00:42:19 GMT

1. Try it and check it

2. I include the TILDA because its after 9 so its my quick short cut to say include anything that might have .9X. There are probably other characters that would accomplish the same thing.

Re: IF CONDITION IN SAS

robertrao — Thu, 21 Nov 2013 00:57:51 GMT

Hi Reeza,

can we do like this

put the tilda on the first and fix the last value( I dint want 125.97 ,125.98 and so on...)like shown

'120~'-'125.96'='FEVER';

Thanks

Re: IF CONDITION IN SAS

Tom — Thu, 21 Nov 2013 01:19:50 GMT

Look at a table of ASCII code to see the relative ordering of the characters. http://www.ascii-code.com/

Of the characters you are likely to see in an ICD9 code the order would be ' ' (space), '.' (period), then the digits from 0 to 9. If you have any letters in your strings they would come later with the uppercase letters from A to Z come first, then the lowercase letters from a to z. The tilde (~) is the largest of printable basic 7 bit ascii codes.

So if you use '120~' as the lower bound then '120' (or '120 ' as SAS would store it an actual variable since all SAS character variables are fixed length) would be less thatn '120~' since '~' is greater than (comes after in the alphabet) a space (' ').

If you use '120' as the lower bound the values like '120 ', '120.' , '120.0' , '120.8' and '121' would all be included as they are greater than (or equal to) '120'.

Re: IF CONDITION IN SAS

Tal — Thu, 21 Nov 2013 03:17:37 GMT

can he use if code in('333.0' :'333.9', '334.0':'334.9') or is the ":" only for ranges of num values?

Re: IF CONDITION IN SAS

snoopy369 — Thu, 21 Nov 2013 15:57:28 GMT

":" is not only numeric only, but it is *integer* only.