topic Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant, in SAS Programming

ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Fadams12 — Wed, 28 Aug 2024 14:27:07 GMT

Hello, I'm trying to run this code, and I am getting an error message, what do I need to do to in line 38 to get this to get it to work?

Data temp (drop=z);

set work.complete22;

array DXS[18] $ dx1-dx18;

CO_FLAG = 0;

do z= 1 to 18;

if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802’ ‘T5803’ ‘T5812’ ‘T5813’)

or substr(DXS {z},1,6)IN:(‘T582X2’ ‘T582X3’ ‘T588X3’ ‘T5892' 'T582X1' 'T582X4' 'T588X1' 'T588X4')

or DXS{z} in: (‘T5882X2’)

then CO_FLAG = 1;

leave;

END;

run;

or substr(DXS {z},1,6)IN:(‘T582X2’ ‘T582X3’ ‘T588X3’ ‘T5892' 'T582X1' 'T582X4'

36 ! 'T588X1' 'T588X4')

38 or DXS{z} in: (‘T5882X2’)

ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

a datetime constant, a missing value, iterator, (.

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

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

ballardw — Wed, 28 Aug 2024 14:32:35 GMT

Please provide the entire procedure or data step log. Sometimes the place that SAS shows the error is because of something missing on a line much earlier. Also, please copy the text from the LOG, on the forum open a text window using the </> icon that appears above the message window and paste the text there. The forum software reformats text pasted into the main message window and may introduce or remove characters, usually not visible, that were not in your log.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Fadams12 — Wed, 28 Aug 2024 14:50:33 GMT

Data temp (drop=z);

5 set work.complete22;

6 /* recoding age */

7 if AGE_KEY >=0 and AGE_KEY <= 4 then agegroup=1;

8 if AGE_KEY >=5 and AGE_KEY <= 9 then agegroup=2;

9 if AGE_KEY >=10 and AGE_KEY <= 14 then agegroup=3;

10 if AGE_KEY >=15 and AGE_KEY <= 19 then agegroup=4;

11 if AGE_KEY >=20 and AGE_KEY <= 24 then agegroup=5;

12 if AGE_KEY >=25 and AGE_KEY <=29 then agegroup=6;

13 if AGE_KEY >=30 and AGE_KEY <= 34 then agegroup=7;

14 if AGE_KEY >=35 and AGE_KEY <= 39 then agegroup=8;

15 if AGE_KEY >=40 and AGE_KEY <= 44 then agegroup=9;

16 if AGE_KEY >=45 and AGE_KEY <= 49 then agegroup=10;

17 if AGE_KEY >=50 and AGE_KEY <= 54 then agegroup=11;

18 if AGE_KEY >=55 and AGE_KEY <= 59 then agegroup=12;

19 if AGE_KEY >=60 and AGE_KEY <= 64 then agegroup=13;

20 if AGE_KEY >=65 and AGE_KEY <= 69 then agegroup=14;

21 if AGE_KEY >=70 and AGE_KEY <= 74 then agegroup=15;

22 if AGE_KEY >=75 and AGE_KEY <= 79 then agegroup=16;

23 if AGE_KEY >=80 and AGE_KEY <= 84 then agegroup=17;

24 if AGE_KEY >=85 then agegroup=18;

25 else if AGE_KEY =. then agegroup =19;

27 /* *primary dx only;*/

29 array DXS[18] $ dx1-dx18;

30 CO_FLAG = 0;

32 do z= 1 to 18;

34 if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802’ ‘T5803’

34 ! ‘T5812’ ‘T5813’)

36 or substr(DXS {z},1,6)IN:(‘T582X2’ ‘T582X3’ ‘T588X3’ ‘T5892' 'T582X1' 'T582X4'

36 ! 'T588X1' 'T588X4')

38 or DXS{z} in: (‘T5882X2’)

ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

a datetime constant, a missing value, iterator, (.

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

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Kurt_Bremser — Wed, 28 Aug 2024 14:58:51 GMT

Please post the complete (from the DATA to the RUN statement) log of the step by copy/pasting the text into a window opened with this button:

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Tom — Wed, 28 Aug 2024 15:00:30 GMT

I think the code looks ok up to the point you stopped. After that should be either an semicolon to define a subsetting if statement (probably not something you would do in the middle of a DO loop) or the THEN keyword to continue defining the IF statement.

Otherwise you might have introduced some invisible character, or perhaps one of those quotes is not actually a quote but is instead a typesetting "stupid" quote.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

fadamso12 — Wed, 28 Aug 2024 15:07:57 GMT

1    data complete22;
2    set "C:\Users\hjt09632\Desktop\complete22.sas7bdat";
3    run;

NOTE: There were 750108 observations read from the data set
      C:\Users\hjt09632\Desktop\complete22.sas7bdat.
NOTE: The data set WORK.COMPLETE22 has 750108 observations and 77 variables.
NOTE: DATA statement used (Total process time):
      real time           1.82 seconds
      cpu time            0.45 seconds


4    Data temp (drop=z);
5    set work.complete22;
6    /* recoding age */
7    if AGE_KEY >=0 and AGE_KEY <= 4 then agegroup=1;
8    if  AGE_KEY >=5  and AGE_KEY <= 9 then agegroup=2;
9    if  AGE_KEY >=10 and AGE_KEY <= 14 then agegroup=3;
10   if  AGE_KEY >=15  and AGE_KEY <= 19 then agegroup=4;
11   if  AGE_KEY >=20  and AGE_KEY <= 24 then agegroup=5;
12   if  AGE_KEY >=25  and AGE_KEY <=29 then agegroup=6;
13   if  AGE_KEY >=30  and AGE_KEY <= 34 then agegroup=7;
14   if  AGE_KEY >=35  and AGE_KEY <= 39 then agegroup=8;
15   if  AGE_KEY >=40  and AGE_KEY <= 44 then agegroup=9;
16   if  AGE_KEY >=45  and AGE_KEY <= 49 then agegroup=10;
17   if  AGE_KEY >=50  and AGE_KEY <= 54 then agegroup=11;
18   if  AGE_KEY >=55  and AGE_KEY <= 59 then agegroup=12;
19   if  AGE_KEY >=60  and AGE_KEY <= 64 then agegroup=13;
20   if  AGE_KEY >=65  and AGE_KEY <= 69 then agegroup=14;
21   if  AGE_KEY >=70  and AGE_KEY <= 74 then agegroup=15;
22   if  AGE_KEY >=75  and AGE_KEY <= 79 then agegroup=16;
23   if  AGE_KEY >=80  and AGE_KEY <= 84 then agegroup=17;
24   if  AGE_KEY >=85 then agegroup=18;
25   else if AGE_KEY =. then agegroup =19;
26
27   /*    *primary dx only;*/
28
29   array DXS[18] $ dx1-dx18;
30   CO_FLAG = 0;
31
32   do z= 1 to 18;
33
34   if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802’ ‘T5803’
34 ! ‘T5812’ ‘T5813’)
35
36               or substr(DXS {z},1,6)IN:(‘T582X2’ ‘T582X3’ ‘T588X3’ ‘T5892' 'T582X1' 'T582X4'
36 ! 'T588X1' 'T588X4')
37
38                                    or DXS{z} in: (‘T5882X2’)
                                                     -
                                                     22
                                                     76
ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,
              a datetime constant, a missing value, iterator, (.

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

39
40               then CO_FLAG = 1;
41
42               leave;
43
44               END;
45
46               run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEMP may be incomplete.  When this step was stopped there were 0
         observations and 79 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.04 seconds

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Tom — Wed, 28 Aug 2024 15:12:54 GMT

So now you can SEE that the underscore is underneath that non-ASCII character you have on that line.

Just edit your code so that you are using actual quotes and not typesetting (word processing) special characters.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

ballardw — Wed, 28 Aug 2024 15:29:10 GMT

I think the actual problem starts here:

 if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802’ ‘T5803’

The first quote from 'T5802 doesn't find a match until

36               or substr(DXS {z},1,6)IN:(‘T582X2’ ‘T582X3’ ‘T588X3’ ‘T5892' 'T582X1' 'T582X4'

If the mismatched quote hadn't appeared as the second for T5802 the next value, T5803 would have shown the same error.

So many of the comparisons are going to fail because of the mismatching of the programming quotes and the "curly" quotes.

These curly quotes typically come from copying text from a different text source.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

FreelanceReinh — Wed, 28 Aug 2024 15:41:17 GMT

Hello @Fadams12 (and @fadamso12) and welcome to the SAS Support Communities!

In addition to the "curly quotes" issue there seems to be a logic error in your code, which the SAS log does not complain about:

@fadamso12 wrote:

40               then CO_FLAG = 1;
41
42               leave;
43
44               END;

The LEAVE statement is executed unconditionally. Hence, the IF condition is checked for z=1 only. Most likely, your intention was to write

 then do;
   CO_FLAG = 1;
   leave;
 end;

before the closing END statement of the DO loop, so that the checks are applied to z=2, 3, ... as well, until the first value satisfying the IF condition (if any).

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Kurt_Bremser — Wed, 28 Aug 2024 16:06:42 GMT

Those curly quotes which cause your trouble might come from some editing in a word processor; do not use such for coding.

If you're not happy with the SAS-supplied editors, use something like Notepad++ or a coding environment, but never Word or similar.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

fadamso12 — Wed, 28 Aug 2024 16:52:38 GMT

Hello everyone,

Thank you all for the support. This is my first using the array and doing loops, so bear with me. I want this code to the checks applied to z=2, 3, so should I remove the LEAVE? Also, after correcting the issue with quotes, now it's a loop, not closed. I have tried to end and run twice, but both do not work.

258  Data temp (drop=z);
259  set work.complete22;
260  array DXS[18] $ dx1-dx18;
261  CO_FLAG = 0;
262
263  do z= 1 to 18;
264
265  if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802' 'T5803'
265! 'T5812' 'T5813')
266
267              or substr(DXS {z},1,6)IN:('T582X2' 'T582X3' 'T588X3' 'T5892' 'T582X1' 'T582X4'
267! 'T588X1' 'T588X4')
268
269                                   or  DXS{z} in:('T5882X2')
270
271              then do;
272              CO_FLAG = 1;
273              leave;
274              end;
275              run;

275              run;
                    -
                    117
ERROR 117-185: There was 1 unclosed DO block.

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WORK.TEMP may be incomplete.  When this step was stopped there were 0
         observations and 78 variables.
WARNING: Data set WORK.TEMP was not replaced because this step was stopped.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds


276              end;
                 ---
                 180

ERROR 180-322: Statement is not valid or it is used out of proper order.

277              run;

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

fadamso12 — Thu, 29 Aug 2024 13:35:45 GMT

Can someone please help me fix this code loop? It

Data temp (drop=z); 
set work.complete22;
array DXS[18] $ dx1-dx18;
CO_FLAG = 0;

do z= 1 to 18;

if substr(DXS {z},1,5) IN:('T5801' 'T5804' 'T5811' 'T5814' 'T5891' 'T5894' 'T5802' 'T5803' 'T5812' 'T5813')

            or substr(DXS {z},1,6)IN:('T582X2' 'T582X3' 'T588X3' 'T5892' 'T582X1' 'T582X4' 'T588X1' 'T588X4')

                                 or  DXS{z} in:('T5882X2')

        
		then do CO_FLAG = 1;
         leave;
			end;
			end;
           	run;

is not working. It only flags Zero's

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

PaigeMiller — Thu, 29 Aug 2024 13:52:09 GMT

Can you please show us a small portion of the data that should not produce a zero? From now on, can you please show us the log as we requested earlier?

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

FreelanceReinh — Thu, 29 Aug 2024 13:44:23 GMT

@fadamso12 wrote:

		then do CO_FLAG = 1;
         leave;
			end;

You omitted the semicolon after the DO statement, which changes the meaning of the code.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Sarath_A_SAS — Wed, 04 Sep 2024 13:09:11 GMT

Can you try this and see if it works for you.

Corrections made:

Replaced curly braces {} with square brackets [] for referencing array elements.
Fixed the single quotes around the string constants (changed them from “curly” quotes to straight quotes).
Ensured the IN operator was used properly by separating the values with commas and enclosing them in parentheses.

This should resolve the syntax errors you were encountering.

Data temp (drop=z);
    set work.complete22;
    array DXS[18] $ dx1-dx18;
    CO_FLAG = 0;

    do z= 1 to 18;
        if substr(DXS[z],1,5) IN ('T5801', 'T5804', 'T5811', 'T5814', 'T5891', 'T5894', 'T5802', 'T5803', 'T5812', 'T5813') 
            or substr(DXS[z],1,6) IN ('T582X2', 'T582X3', 'T588X3', 'T5892', 'T582X1', 'T582X4', 'T588X1', 'T588X4') 
            or DXS[z] in ('T5882X2') then CO_FLAG = 1;
        leave;
    end;
run;

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

fadamso12 — Thu, 12 Sep 2024 16:57:37 GMT

Hello, everyone. Can someone help me fix this code? I am trying to summarize data by the following variables: age group, county, year admitted admissionmonth, race, and sex. Below is a snippet of the data.

proc sql number;
create table rr as 
select distinct AdmissionMonth, AgeGroup, County, Ethnicity, Race, HealthOutcomeID, MonthlyHosp, 
Sex, ADYEAR,
count (case when ASTHMA_FLAG=1 
from count_Asthma
group by AdmissionMonth, AgeGroup, County, Ethnicity, Race, HealthOutcomeID, MonthlyHosp, 
		Sex, ADYEAR; 
quit;

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

PaigeMiller — Thu, 12 Sep 2024 17:12:27 GMT

You are missing a right parenthesis. And even if you fix that, your CASE WHEN is incomplete.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

fadamso12 — Thu, 12 Sep 2024 17:23:16 GMT

@PaigeMiller, if you don't mind, can you tell me the syntax? I have never created a table using SQL before, so I am trying it for the first time.

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

PaigeMiller — Thu, 12 Sep 2024 17:32:10 GMT

From code that doesn't work, I would need to know what this SQL is supposed to do in order to get it to work, especially the part where you get the error, what are you trying to do?

Re: ERROR 22-322: Syntax error, expecting one of the following: a quoted string, a numeric constant,

Tom — Thu, 12 Sep 2024 18:08:51 GMT

First thing is you should be systematic in your code layout so it will be easier for you to spot places where your code fails to follow the pattern.

proc sql ;
create table rr as 
select distinct
    AdmissionMonth
  , AgeGroup
  , County
  , Ethnicity
  , Race
  , HealthOutcomeID
  , MonthlyHosp
  , Sex
  , ADYEAR
  , count (case when ASTHMA_FLAG=1
from count_Asthma
group by AdmissionMonth
       , AgeGroup
       , County
       , Ethnicity
       , Race
       , HealthOutcomeID
       , MonthlyHosp
       , Sex
       , ADYEAR
; 
quit;

So the place where normal patterns breakdown is in your call to the COUNT() aggregate function.

count (case when ASTHMA_FLAG=1

You have the opening ( that indicates the start of the function arguments, but you never added any closing ).

You also have the start of a CASE clause, but you never finish it with an END keyword.

Do you want to count the number of times that variable has a value of 1? You could finish the CASE like this so that COUNT has a value that is either populated (always 1 in the case) or missing.

count (case when ASTHMA_FLAG=1 then asthma_flag else . end)

But you might want to ADD instead of COUNT to get the number instead.

sum(case when ASTHMA_FLAG=1 then 1 else 0 end)

Which in SAS can be simplified to:

sum(ASTHMA_FLAG=1)

since SAS will evaluate such a boolean expression as either 1 (TRUE) or 0 (FALSE).