Hi Expects, please assist with the above mention error 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;
... View more