topic Re: SAS in SAS Programming

SAS

Ranjeeta — Thu, 10 Jan 2019 22:08:52 GMT

I am getting an error Can someone advise how to correct this step

data DAD_N_1;
set DAD_N_1a;
/* ARRAY - ISCHEMIC STROKE DIAGNOSIS CODE */
ARRAY DX_CODE [25] DIAG_CODE_01 - DIAG_CODE_25;
STROKE_CNT=0;

DO I=1 TO 25;
IF ARRAY DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO;
STROKE_CNT+1;
IF SUBSTR(DX_CODE[I],1,4) NOT IN ('I636')THEN DO;
STROKE_CNT+1;
/* COUNT NUMBER OF Ischemic stroke procedures */
run;

ERROR:

data DAD_N_1;
383 set DAD_N_1a;
384 /* ARRAY - ISCHEMIC STROKE DIAGNOSIS CODE */
385 ARRAY DX_CODE [25] DIAG_CODE_01 - DIAG_CODE_25;
386
387 STROKE_CNT=0;
388
389 DO I=1 TO 25;
390 IF ARRAY DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO;
-------
22
ERROR 22-322: Syntax error, expecting one of the following: !, !!, &, (, *, **, +, -, /, ;, <, <=,
<>, =, >, ><, >=, AND, EQ, GE, GT, LE, LT, MAX, MIN, NE, NG, NL, OR, [, ^=, {, |, ||,
~=.

391 STROKE_CNT+1;
392 IF SUBSTR(DX_CODE[I],1,4) NOT IN ('I636')THEN DO;
393 STROKE_CNT+1;
394 /* COUNT NUMBER OF Ischemic stroke procedures */
395 run;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
390:14 1:1

Re: SAS

ballardw — Thu, 10 Jan 2019 22:13:18 GMT

You only use the keyword array when defining one. Instead of

IF ARRAY DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO;

use

IF  DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO;

Re: SAS

Ranjeeta — Thu, 10 Jan 2019 22:29:07 GMT

thankyou for pointing that out then how do I combine he two conditions in the array

Re: SAS

novinosrin — Thu, 10 Jan 2019 22:38:23 GMT

Are you looking to do this??


if DX_CODE[I] IN ('I63', 'I64', 'H34') or SUBSTR(DX_CODE[I],1,4) NOT IN ('I636')THEN STROKE_CNT+1;

Re: SAS

Reeza — Thu, 10 Jan 2019 23:06:22 GMT

You're also missing an END for your DO statement. Or you can not have a DO statement at all.

Re: SAS

Astounding — Fri, 11 Jan 2019 01:17:20 GMT

How could this possibly be the right logic?

IF SUBSTR(DX_CODE[I],1,4) NOT IN ('I636')THEN DO;
STROKE_CNT+1;

Even missing values for the diagnosis code would increase the stroke count.

Can diagnosis codes really be 3 characters long? If not, how could this ever produce a match:

IF ARRAY DX_CODE[I] IN ('I63', 'I64', 'H34') THEN DO;

You might have to explain what you are trying to count. Especially whether you are trying to double-count "I63" and "I636".

Re: SAS

Ranjeeta — Fri, 11 Jan 2019 17:06:12 GMT

I am trying to count the procedures that have codes ('I61' 'I63' 'I64') ('H341') and not NOT IN ('G454' 'I636')

data DAD_N_1;
130 set DAD_N_1a;
131 /* ARRAY - ISCHEMIC STROKE DIAGNOSIS CODE */
132 ARRAY DX_CODE [25] DIAG_CODE_01 - DIAG_CODE_25;
133 STROKE_CNT=0;
134
135 DO I=1 TO 25;
136
137 IF((SUBSTR(DX_CODE[I],1,3) IN ('I61' 'I63' 'I64') OR SUBSTR(DX_CODE[I],1,4) = ('H341'))and
138 SUBSTR(DX_CODE[I],1,4) NOT IN ('G454' 'I636')
139 THEN STROKE_CNT+1;
----
22
76
ERROR 22-322: Syntax error, expecting one of the following: !, &, ), <, <=, =, >, >=, AND, EQ, GE,
GT, IN, LE, LT, NE, NG, NL, NOT, NOTIN, OR, ^, ^=, |, ~, ~=.

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

140
141 end;
142
143 /* COUNT NUMBER OF Ischemic stroke procedures */
144 run;

Re: SAS

Astounding — Fri, 11 Jan 2019 18:49:56 GMT

OK, last chance to explain. If you count the procedure codes that are in ('I61' 'I63' 'I64' 'H341'), why do you need to pay any attention to 'G454' and 'I636'?

Re: SAS

Ranjeeta — Fri, 11 Jan 2019 19:07:28 GMT

They are codes that we need to exclude due to business requirements but thankyou there was extra parentheses in the code below its resolved now