ERROR 22-322: Syntax error, expecting one of the following: CUROBS, EN...

Rixile106 · Posted 02-13-2024 09:09 AM

Hi Expects, please assist with the above mention error

Spoiler

log

1 The SAS System Tuesday, February 13, 2024 03:45:00 PM

1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program 1';
4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=SVG;
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 %macro HTML5AccessibleGraphSupported;
15 %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16 %mend;
17 FILENAME EGHTML TEMP;
18 ODS HTML5(ID=EGHTML) FILE=EGHTML
19 OPTIONS(BITMAP_MODE='INLINE')
20 %HTML5AccessibleGraphSupported
21 ENCODING='utf-8'
22 STYLE=HTMLBlue
23 NOGTITLE
24 NOGFOOTNOTE
25 GPATH=&sasworklocation
26 ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27
28 data WRK.FINAL_OD_LIMIT_1 (ENCODING= ANY);
29 set FIN.TO_MVP1_CLIENT (rename=(BP_ID=BP_ID_MVP1))
30 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP1 = BP_ID
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.

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

31 LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP1)) ON BP_ID = BP_ID_FP1
32 LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
33 where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356)
34 AND TAKE_UP_DATE_WA BETWEEN 20230510 AND &YDAY.
35 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
36 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
37 AND DA_Decision = 'Approved';
38 if _IORC_ then do;
39 _DECLARE_ _IORC_;
_________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

40 return;
41 end;
42 TAKE_UP_DATE_DT =
42 ! cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
43 run;

NOTE: The SAS System stopped processing this step because of errors.
2 The SAS System Tuesday, February 13, 2024 03:45:00 PM

44
45 proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
46 run;

0.039432| _DISARM| 2023452379.473999| _DISARM| 2023452379.513431| _DISARM| 0.030000| _DISARM| | _ENDDISARM

47
48 data WRK.FINAL_OD_LIMIT_1;
49 set FIN.TO_MVP2_CLIENT (rename=(BP_ID=BP_ID_MVP2))
50 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP2 = BP_ID
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.

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

51 LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP2)) ON BP_ID = BP_ID_FP2
52 LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
53 where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356)
54 AND TAKE_UP_DATE_WA BETWEEN 20230828 AND &YDAY.
55 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
56 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
57 AND DA_Decision = 'Approved';
58 if _IORC_ then do;
59 _DECLARE_ _IORC_;
_________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.

60 return;
61 end;
62 TAKE_UP_DATE_DT =
62 ! cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
63 run;

4 The SAS System Tuesday, February 13, 2024 03:45:00 PM

64
65 proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
66 run;

67
68 data WRK.FINAL_OD_LIMIT_1;
69 set FIN.TO_MVP3_CLIENT (rename=(BP_ID=BP_ID_MVP3))
70 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP3 = BP_ID
_
22
76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.

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

71 LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP3)) ON BP_ID = BP_ID_FP3
72 LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
73 where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356)
74 AND TAKE_UP_DATE_WA BETWEEN 20231002 AND &YDAY.
75 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
76 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
77 AND DA_Decision = 'Approved';
78 if _IORC_ then do;
79 _DECLARE_ _IORC_;
_________
180
ERROR 180-322: Statement is not valid or it is used out of proper order.
5 The SAS System Tuesday, February 13, 2024 03:45:00 PM

80 return;
81 end;
82 TAKE_UP_DATE_DT =
82 ! cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
83 run;

84
85 proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
86 run;

87
88
89 %LET _CLIENTTASKLABEL=;
90 %LET _CLIENTPROCESSFLOWNAME=;
91 %LET _CLIENTPROJECTPATH=;
92 %LET _CLIENTPROJECTPATHHOST=;
93 %LET _CLIENTPROJECTNAME=;
94 %LET _SASPROGRAMFILE=;
95 %LET _SASPROGRAMFILEHOST=;
96
97 ;*';*";*/;quit;run;
98 ODS _ALL_ CLOSE;
99
100
101 QUIT; RUN;
102


data WRK.FINAL_OD_LIMIT_1 (ENCODING= ANY);
    set FIN.TO_MVP1_CLIENT (rename=(BP_ID=BP_ID_MVP1)) 
        LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP1 = BP_ID
        LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP1)) ON BP_ID = BP_ID_FP1
        LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
        where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356) 
        AND TAKE_UP_DATE_WA BETWEEN 20230510 AND &YDAY.
        AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
        AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
        AND DA_Decision = 'Approved';
    if _IORC_ then do;
        _DECLARE_ _IORC_; 
        return; 
    end;
    TAKE_UP_DATE_DT = cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
run;

proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
run;

data WRK.FINAL_OD_LIMIT_1;
    set FIN.TO_MVP2_CLIENT (rename=(BP_ID=BP_ID_MVP2)) 
        LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP2 = BP_ID
        LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP2)) ON BP_ID = BP_ID_FP2
        LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
        where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356) 
        AND TAKE_UP_DATE_WA BETWEEN 20230828 AND &YDAY.
        AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
        AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
        AND DA_Decision = 'Approved';
    if _IORC_ then do;
        _DECLARE_ _IORC_; 
        return; 
    end;
    TAKE_UP_DATE_DT = cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
run;

proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
run;

data WRK.FINAL_OD_LIMIT_1;
    set FIN.TO_MVP3_CLIENT (rename=(BP_ID=BP_ID_MVP3)) 
        LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP3 = BP_ID
        LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP3)) ON BP_ID = BP_ID_FP3
        LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
        where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356) 
        AND TAKE_UP_DATE_WA BETWEEN 20231002 AND &YDAY.
        AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
        AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
        AND DA_Decision = 'Approved';
    if _IORC_ then do;
        _DECLARE_ _IORC_; 
        return; 
    end;
    TAKE_UP_DATE_DT = cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
run;

proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
run;

PaigeMiller · Posted 02-13-2024 09:19 AM

Please show us the ENTIRE log for the DATA step or PROC which has the error. Copy and paste the log as text into the window that appears when you click on the </> icon.

--
Paige Miller

Rixile106 · Posted 02-13-2024 09:20 AM

1                                                          The SAS System                     Tuesday, February 13, 2024 03:45:00 PM

1          ;*';*";*/;quit;run;
2          OPTIONS PAGENO=MIN;
3          %LET _CLIENTTASKLABEL='Program 1';
4          %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project';
5          %LET _CLIENTPROJECTPATH='';
6          %LET _CLIENTPROJECTPATHHOST='';
7          %LET _CLIENTPROJECTNAME='';
8          %LET _SASPROGRAMFILE='';
9          %LET _SASPROGRAMFILEHOST='';
10         
11         ODS _ALL_ CLOSE;
12         OPTIONS DEV=SVG;
13         GOPTIONS XPIXELS=0 YPIXELS=0;
14         %macro HTML5AccessibleGraphSupported;
15             %if %_SAS_VERCOMP_FV(9,4,4, 0,0,0) >= 0 %then ACCESSIBLE_GRAPH;
16         %mend;
17         FILENAME EGHTML TEMP;
18         ODS HTML5(ID=EGHTML) FILE=EGHTML
19             OPTIONS(BITMAP_MODE='INLINE')
20             %HTML5AccessibleGraphSupported
21             ENCODING='utf-8'
22             STYLE=HTMLBlue
23             NOGTITLE
24             NOGFOOTNOTE
25             GPATH=&sasworklocation
26         ;
NOTE: Writing HTML5(EGHTML) Body file: EGHTML
27         
28         data WRK.FINAL_OD_LIMIT_1 (ENCODING= ANY);
29             set FIN.TO_MVP1_CLIENT (rename=(BP_ID=BP_ID_MVP1))
30                 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP1 = BP_ID
                                                                                           _
                                                                                           22
                                                                                           76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.  

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

31                 LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP1)) ON BP_ID = BP_ID_FP1
32                 LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
33                 where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356)
34                 AND TAKE_UP_DATE_WA BETWEEN 20230510 AND &YDAY.
35                 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
36                 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
37                 AND DA_Decision = 'Approved';
38             if _IORC_ then do;
39                 _DECLARE_ _IORC_;
                   _________
                   180
ERROR 180-322: Statement is not valid or it is used out of proper order.

40                 return;
41             end;
42             TAKE_UP_DATE_DT =
42       ! cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
43         run;

NOTE: The SAS System stopped processing this step because of errors.
2                                                          The SAS System                     Tuesday, February 13, 2024 03:45:00 PM

WARNING: The data set WRK.FINAL_OD_LIMIT_1 may be incomplete.  When this step was stopped there were 0 observations and 2 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,472+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 0| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 2904| _DISARM| 0.000000| _DISARM| 
      0.003390| _DISARM| 2023452379.468721| _DISARM| 2023452379.472111| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
WARNING: Data set WRK.FINAL_OD_LIMIT_1 was not replaced because this step was stopped.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,472+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 24289280| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 2904| _DISARM| 0.010000| _DISARM| 
      0.012767| _DISARM| 2023452379.459585| _DISARM| 2023452379.472352| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.01 seconds
      memory              550.56k
      OS Memory           19868.00k
      Timestamp           02/13/2024 04:06:19 PM
      Step Count                        36  Switch Count  0
      Page Faults                       0
      Page Reclaims                     32
      Page Swaps                        0
      Voluntary Context Switches        14
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      

44         
45         proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
46         run;

NOTE: Appending WRK.FINAL_OD_LIMIT_1 to WRK.FINAL_OD_LIMIT_1.
NOTE: Appending the file WRK.FINAL_OD_LIMIT_1 to itself.
NOTE: There were 1984 observations read from the data set WRK.FINAL_OD_LIMIT_1.
NOTE: 1984 observations added.
NOTE: The data set WRK.FINAL_OD_LIMIT_1 has 3968 observations and 294 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,512+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 3968| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2912| _DISARM| 0.030000| _DISARM| 
      0.033126| _DISARM| 2023452379.479541| _DISARM| 2023452379.512667| _DISARM| 0.030000| _DISARM| | _ENDDISARM 
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,513+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 3968| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2912| _DISARM| 0.030000| _DISARM| 
      0.033417| _DISARM| 2023452379.479801| _DISARM| 2023452379.513218| _DISARM| 0.030000| _DISARM| | _ENDDISARM 
NOTE: PROCEDURE APPEND used (Total process time):
      real time           0.03 seconds
      user cpu time       0.03 seconds
      system cpu time     0.00 seconds
      memory              1227.50k
      OS Memory           19868.00k
      Timestamp           02/13/2024 04:06:19 PM
      Step Count                        37  Switch Count  3
      Page Faults                       0
      Page Reclaims                     28
      Page Swaps                        0
      Voluntary Context Switches        15
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           8
      
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,513+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 24289280| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2912| _DISARM| 0.030000| _DISARM| 
3                                                          The SAS System                     Tuesday, February 13, 2024 03:45:00 PM

      0.039432| _DISARM| 2023452379.473999| _DISARM| 2023452379.513431| _DISARM| 0.030000| _DISARM| | _ENDDISARM 

47         
48         data WRK.FINAL_OD_LIMIT_1;
49             set FIN.TO_MVP2_CLIENT (rename=(BP_ID=BP_ID_MVP2))
50                 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP2 = BP_ID
                                                                                           _
                                                                                           22
                                                                                           76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.  

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

51                 LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP2)) ON BP_ID = BP_ID_FP2
52                 LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
53                 where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356)
54                 AND TAKE_UP_DATE_WA BETWEEN 20230828 AND &YDAY.
55                 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
56                 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
57                 AND DA_Decision = 'Approved';
58             if _IORC_ then do;
59                 _DECLARE_ _IORC_;
                   _________
                   180
ERROR 180-322: Statement is not valid or it is used out of proper order.

60                 return;
61             end;
62             TAKE_UP_DATE_DT =
62       ! cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
63         run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WRK.FINAL_OD_LIMIT_1 may be incomplete.  When this step was stopped there were 0 observations and 2 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,526+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 0| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 2912| _DISARM| 0.000000| _DISARM| 
      0.007561| _DISARM| 2023452379.519131| _DISARM| 2023452379.526692| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
WARNING: Data set WRK.FINAL_OD_LIMIT_1 was not replaced because this step was stopped.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,526+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 24289280| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 2912| _DISARM| 0.000000| _DISARM| 
      0.011838| _DISARM| 2023452379.515087| _DISARM| 2023452379.526925| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              564.06k
      OS Memory           19868.00k
      Timestamp           02/13/2024 04:06:19 PM
      Step Count                        38  Switch Count  0
      Page Faults                       0
      Page Reclaims                     29
      Page Swaps                        0
      Voluntary Context Switches        15
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      

4                                                          The SAS System                     Tuesday, February 13, 2024 03:45:00 PM

64         
65         proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
66         run;

NOTE: Appending WRK.FINAL_OD_LIMIT_1 to WRK.FINAL_OD_LIMIT_1.
NOTE: Appending the file WRK.FINAL_OD_LIMIT_1 to itself.
NOTE: There were 3968 observations read from the data set WRK.FINAL_OD_LIMIT_1.
NOTE: 3968 observations added.
NOTE: The data set WRK.FINAL_OD_LIMIT_1 has 7936 observations and 294 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,585+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 7936| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2920| _DISARM| 0.060000| _DISARM| 
      0.055957| _DISARM| 2023452379.529465| _DISARM| 2023452379.585422| _DISARM| 0.050000| _DISARM| | _ENDDISARM 
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,586+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 7936| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2920| _DISARM| 0.060000| _DISARM| 
      0.056317| _DISARM| 2023452379.529706| _DISARM| 2023452379.586023| _DISARM| 0.050000| _DISARM| | _ENDDISARM 
NOTE: PROCEDURE APPEND used (Total process time):
      real time           0.05 seconds
      user cpu time       0.05 seconds
      system cpu time     0.01 seconds
      memory              1234.93k
      OS Memory           19868.00k
      Timestamp           02/13/2024 04:06:19 PM
      Step Count                        39  Switch Count  3
      Page Faults                       0
      Page Reclaims                     20
      Page Swaps                        0
      Voluntary Context Switches        20
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           8
      
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,586+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 24289280| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2920| _DISARM| 0.060000| _DISARM| 
      0.057631| _DISARM| 2023452379.528616| _DISARM| 2023452379.586247| _DISARM| 0.050000| _DISARM| | _ENDDISARM 

67         
68         data WRK.FINAL_OD_LIMIT_1;
69             set FIN.TO_MVP3_CLIENT (rename=(BP_ID=BP_ID_MVP3))
70                 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP3 = BP_ID
                                                                                           _
                                                                                           22
                                                                                           76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.  

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

71                 LEFT JOIN LMT.Final_pdg2 (rename=(FE_GEN_CUST_NO=BP_ID_FP3)) ON BP_ID = BP_ID_FP3
72                 LEFT JOIN EIW_BI.BI_PRODUCT B ON B.product_id = B.product
73                 where Product IN (0141,4478,0144,0060,0161,1337,9285,4305,1825,0006,4356)
74                 AND TAKE_UP_DATE_WA BETWEEN 20231002 AND &YDAY.
75                 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= .
76                 AND BA_CHQ_LIMIT_DIFF_CD_PD ^= 0
77                 AND DA_Decision = 'Approved';
78             if _IORC_ then do;
79                 _DECLARE_ _IORC_;
                   _________
                   180
ERROR 180-322: Statement is not valid or it is used out of proper order.
5                                                          The SAS System                     Tuesday, February 13, 2024 03:45:00 PM


80                 return;
81             end;
82             TAKE_UP_DATE_DT =
82       ! cat(substr(catt(TAKE_UP_DATE_WA),1,4),'-',substr(catt(TAKE_UP_DATE_WA),5,2),'-',substr(catt(TAKE_UP_DATE_WA),7,2));
83         run;

NOTE: The SAS System stopped processing this step because of errors.
WARNING: The data set WRK.FINAL_OD_LIMIT_1 may be incomplete.  When this step was stopped there were 0 observations and 2 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,598+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 0| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 2920| _DISARM| 0.000000| _DISARM| 
      0.006067| _DISARM| 2023452379.592681| _DISARM| 2023452379.598748| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
WARNING: Data set WRK.FINAL_OD_LIMIT_1 was not replaced because this step was stopped.
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,598+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 24289280| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 0| _DISARM| 2920| _DISARM| 0.000000| _DISARM| 
      0.010963| _DISARM| 2023452379.588009| _DISARM| 2023452379.598972| _DISARM| 0.000000| _DISARM| | _ENDDISARM 
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      user cpu time       0.00 seconds
      system cpu time     0.00 seconds
      memory              564.15k
      OS Memory           19868.00k
      Timestamp           02/13/2024 04:06:19 PM
      Step Count                        40  Switch Count  0
      Page Faults                       0
      Page Reclaims                     29
      Page Swaps                        0
      Voluntary Context Switches        14
      Involuntary Context Switches      0
      Block Input Operations            0
      Block Output Operations           0
      

84         
85         proc append base=WRK.FINAL_OD_LIMIT_1 data=WRK.FINAL_OD_LIMIT_1;
86         run;

NOTE: Appending WRK.FINAL_OD_LIMIT_1 to WRK.FINAL_OD_LIMIT_1.
NOTE: Appending the file WRK.FINAL_OD_LIMIT_1 to itself.
NOTE: There were 7936 observations read from the data set WRK.FINAL_OD_LIMIT_1.
NOTE: 7936 observations added.
NOTE: The data set WRK.FINAL_OD_LIMIT_1 has 15872 observations and 294 variables.
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,714+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 15872| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2928| _DISARM| 0.110000| 
      _DISARM| 0.113226| _DISARM| 2023452379.601402| _DISARM| 2023452379.714628| _DISARM| 0.100000| _DISARM| | _ENDDISARM 
NOTE: MVA_DSIO.OPEN_CLOSE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,715+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| 
      _DISARM| | _DISARM| 15872| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2928| _DISARM| 0.110000| 
      _DISARM| 0.113514| _DISARM| 2023452379.601674| _DISARM| 2023452379.715188| _DISARM| 0.100000| _DISARM| | _ENDDISARM 
NOTE: PROCEDURE APPEND used (Total process time):
      real time           0.11 seconds
      user cpu time       0.11 seconds
      system cpu time     0.01 seconds
      memory              1238.84k
      OS Memory           19868.00k
      Timestamp           02/13/2024 04:06:19 PM
      Step Count                        41  Switch Count  3
      Page Faults                       0
      Page Reclaims                     20
6                                                          The SAS System                     Tuesday, February 13, 2024 03:45:00 PM

      Page Swaps                        0
      Voluntary Context Switches        22
      Involuntary Context Switches      1
      Block Input Operations            0
      Block Output Operations           8
      
NOTE: PROCEDURE| _DISARM|         STOP| _DISARM| 2024-02-13T16:06:19,715+02:00| _DISARM| WorkspaceServer| _DISARM| SAS| _DISARM| | 
      _DISARM| 24289280| _DISARM| 20344832| _DISARM| 12| _DISARM| 13| _DISARM| 8| _DISARM| 2928| _DISARM| 0.120000| _DISARM| 
      0.114946| _DISARM| 2023452379.600454| _DISARM| 2023452379.715400| _DISARM| 0.110000| _DISARM| | _ENDDISARM 

87         
88         
89         %LET _CLIENTTASKLABEL=;
90         %LET _CLIENTPROCESSFLOWNAME=;
91         %LET _CLIENTPROJECTPATH=;
92         %LET _CLIENTPROJECTPATHHOST=;
93         %LET _CLIENTPROJECTNAME=;
94         %LET _SASPROGRAMFILE=;
95         %LET _SASPROGRAMFILEHOST=;
96         
97         ;*';*";*/;quit;run;
98         ODS _ALL_ CLOSE;
99         
100        
101        QUIT; RUN;
102

PaigeMiller · Posted 02-13-2024 09:25 AM

Please read carefully, I want the ENTIRE log for the DATA step or PROC that has the error, not the ENTIRE log for the entire program.

Here is the error

28         data WRK.FINAL_OD_LIMIT_1 (ENCODING= ANY);
29             set FIN.TO_MVP1_CLIENT (rename=(BP_ID=BP_ID_MVP1))
30                 LEFT JOIN EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID)) ON BP_ID_MVP1 = BP_ID
                                                                                           _
                                                                                           22
                                                                                           76
ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, POINT.  

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

You cannot use an equal sign in a SET statement — except within parenthesis such as a (RENAME=()) or (WHERE=()). You also cannot use LEFT JOIN and ON in a SET statement.

You cannot mix and match SQL commands and DATA step commands. LEFT JOIN and ON can only be used in PROC SQL, it cannot be used in a DATA step. SET can only be used in a DATA step, it cannot be used with PROC SQL code. Each requires the proper syntax and options.

Possibly (I am guessing) you want something like this

data work.final_od_limit_1(encoding=any);
     merge FIN.TO_MVP1_CLIENT EIW_BI.BI_ACCOUNT (rename=(CUSTOMER_NUM=BP_ID));
     by bp_id;
run;

--
Paige Miller

ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KE

Re: ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET

Re: ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET

Re: ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET

ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET, KE

Re: ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET

Re: ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET

Re: ERROR 22-322: Syntax error, expecting one of the following: CUROBS, END, INDSNAME, KEY, KEYRESET

Click image to register for webinar

Classroom Training Available!