BookmarkSubscribeRSS Feed
Rixile106
Fluorite | Level 6
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

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


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;
3 REPLIES 3
PaigeMiller
Diamond | Level 26

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.

PaigeMiller_0-1663012019648.png

--
Paige Miller
Rixile106
Fluorite | Level 6
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
Diamond | Level 26

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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 248 views
  • 1 like
  • 2 in conversation