Hi all, seeking your support to look at below error in red, i have spent hours but cannot figure out
1 The SAS System 15:25 Monday, August 9, 2021
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Dailly_report_Error_Apply_From_Mar2020_testing 1.sas';
4 %LET _CLIENTPROCESSFLOWNAME='Standalone Not In Project';
5 %LET _CLIENTPROJECTPATH='';
6 %LET _CLIENTPROJECTPATHHOST='';
7 %LET _CLIENTPROJECTNAME='';
8 %LET _SASPROGRAMFILE='/proj/sas/sasdata/basesas/nonrisk/VOCD/Trung/Source
8 ! code/Dailly_report_Error_Apply_From_Mar2020_testing 1.sas';
9 %LET _SASPROGRAMFILEHOST='pecda15l.unix.anz';
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 /*-------------------------------------------MACRO HERE-------------------------------------------*/
29 %macro io(fn, datafile, data, type);
30 %if &fn=import %then %do;
31 proc import datafile="&datafile"
32 out=&data
33 dbms=&type replace;
34 run;
35 %end;
36 %else %if &fn=export %then %do;
37 proc export data=&data
38 outfile="&datafile"
39 dbms=&type
40 replace;
41 run;
42 %end;
43 %mend;
44 /*----------------------------------------END OF MACRO HERE----------------------------------------*/
45 %LET Date_Last_Working = 3007;
46
47 %let depo_last = DEPO3007;
48 %let ah_last = CBO3007;
49
50 %let depo_last2 = DEPO2907;
51 %let ah_last2 = CBO2907;
52
53 %let N = 10;
54
55 %let path = /proj/sas/sasdata/basesas/nonrisk/VOCD/Trung;
56
2 The SAS System 15:25 Monday, August 9, 2021
57 %io(import,&path/RAW DATA/Holiday, Holiday, xlsx);
NOTE: One or more variables were converted because the data type is not supported by the V9 engine. For more details, run with
options MSGLEVEL=I.
NOTE: The import data set has 18 observations and 4 variables.
NOTE: WORK.HOLIDAY data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
58
59 data mon_fri;
60 do date = intnx('year',today(),-1,'B') to intnx('year',today(),0,'E');
61 if weekday(date) in (2:6) then output;
62 end;
63 format date date9.;
64 run;
NOTE: The data set WORK.MON_FRI has 523 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
65
66 data Holiday (keep = Date);
67 set Holiday;
68 run;
NOTE: There were 18 observations read from the data set WORK.HOLIDAY.
NOTE: The data set WORK.HOLIDAY has 18 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
69
70 data myworksday(RENAME=(date=Begin));
71 merge mon_fri (in=weekday)
72 Holiday (in=holiday);
73 by date;
74 if weekday and not holiday then output;
75 run;
NOTE: There were 523 observations read from the data set WORK.MON_FRI.
NOTE: There were 18 observations read from the data set WORK.HOLIDAY.
NOTE: The data set WORK.MYWORKSDAY has 510 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
76
77 PROC SQL;
78 CREATE TABLE Date_Last_Working AS
79 SELECT Max(Begin) AS Date_Last_Working
80 FROM myworksday
3 The SAS System 15:25 Monday, August 9, 2021
81 WHERE Begin < today() - &N;
NOTE: Table WORK.DATE_LAST_WORKING created, with 1 rows and 1 columns.
82 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.02 seconds
cpu time 0.00 seconds
83
84 DATA PATH;
85 SET Date_Last_Working;
86 iMONTH= PUT(today() - &N, monname3.);
87 iYEAR= YEAR(today() - &N);
88 iPATH = CAT(iMONTH,"", iYEAR);
89 RUN;
NOTE: There were 1 observations read from the data set WORK.DATE_LAST_WORKING.
NOTE: The data set WORK.PATH has 1 observations and 4 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.02 seconds
90
91 PROC SQL NOPRINT;
92 SELECT iPATH INTO:iPATH
93 FROM PATH;
94 %PUT &iPATH;
Jul 2021
95 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
96
97
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
98 PROC SQL;
99 CREATE TABLE Date_Last_Working2 AS
100 SELECT Max(Begin) AS Date_Last_Working2
101 FROM myworksday
102 WHERE Begin < (SELECT Max(Date_Last_Working) FROM Date_Last_Working);
NOTE: Table WORK.DATE_LAST_WORKING2 created, with 1 rows and 1 columns.
103 QUIT;
NOTE: PROCEDURE SQL used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
104
105 DATA Date_Last_Working(KEEP=Date_LW1);
106 SET Date_Last_Working;
107 if DAY(Date_Last_Working) < 10 then day_1=cat("0",DAY(Date_Last_Working));
108 else day_1= cat("",DAY(Date_Last_Working));
109 if MONTH(Date_Last_Working) < 10 then month_1=cat("0",MONTH(Date_Last_Working));
4 The SAS System 15:25 Monday, August 9, 2021
110 else month_1= cat("",MONTH(Date_Last_Working));
111 Date_LW1=CATT(DAY_1, MONTH_1);
112 RUN;
NOTE: There were 1 observations read from the data set WORK.DATE_LAST_WORKING.
NOTE: The data set WORK.DATE_LAST_WORKING has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.02 seconds
113
114
115
116 DATA Date_Last_Working;
117 SET Date_Last_Working;
118 DEPO1=COMPRESS(CATT("DEPO",Date_LW1));
119 AH1=COMPRESS(CATT("CBO",Date_LW1));
120 RUN;
NOTE: There were 1 observations read from the data set WORK.DATE_LAST_WORKING.
NOTE: The data set WORK.DATE_LAST_WORKING has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
121
122
123 DATA Date_Last_Working2(KEEP=Date_LW2);
124 SET Date_Last_Working2;
125 if DAY(Date_Last_Working2) < 10 then day_2=cat("0",DAY(Date_Last_Working2));
126 else day_2= cat("",DAY(Date_Last_Working2));
127 if MONTH(Date_Last_Working2) < 10 then month_2=cat("0",MONTH(Date_Last_Working2));
128 else month_2= cat("",MONTH(Date_Last_Working2));
129 Date_LW2=CATT(DAY_2, MONTH_2);
130 RUN;
NOTE: There were 1 observations read from the data set WORK.DATE_LAST_WORKING2.
NOTE: The data set WORK.DATE_LAST_WORKING2 has 1 observations and 1 variables.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.00 seconds
131
132 DATA Date_Last_Working2;
133 SET Date_Last_Working2;
134 DEPO2=COMPRESS(CATT("DEPO",Date_LW2));
135 AH2=COMPRESS(CATT("CBO",Date_LW2));
136 RUN;
NOTE: There were 1 observations read from the data set WORK.DATE_LAST_WORKING2.
NOTE: The data set WORK.DATE_LAST_WORKING2 has 1 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.05 seconds
cpu time 0.01 seconds
5 The SAS System 15:25 Monday, August 9, 2021
137
138 PROC SQL NOPRINT;
139 SELECT DEPO1 INTO:depo_last
140 FROM Date_Last_Working;
141 %PUT &depo_last;
DEPO2907
142 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
143
144
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
145 PROC SQL NOPRINT;
146 SELECT AH1 INTO: ah_last
147 FROM Date_Last_Working;
148 %PUT &ah_last;
CBO2907
149 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
150
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
151 PROC SQL NOPRINT;
152 SELECT DEPO2 INTO:depo_last2
153 FROM Date_Last_Working2;
154 %PUT &depo_last2;
DEPO2807
155 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
156
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
157 PROC SQL NOPRINT;
158 SELECT AH2 INTO: ah_last2
159 FROM Date_Last_Working2;
160 %PUT &ah_last2;
CBO2807
161 RUN;
NOTE: PROC SQL statements are executed immediately; The RUN statement has no effect.
162
163 /* ---------------- PROCESS ----------------*/
164
165 %io(import,&path/RAW DATA/DEPO3007.DBF, &depo_last, DBF);
NOTE: PROCEDURE SQL used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
6 The SAS System 15:25 Monday, August 9, 2021
NOTE: Imported 22 columns and 3349 rows of data from the dBase table file.
NOTE: WORK.DEPO2907 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.03 seconds
cpu time 0.02 seconds
166 %io(import,&path/RAW DATA/DEPO2907.DBF, &depo_last2, DBF);
NOTE: Imported 22 columns and 3350 rows of data from the dBase table file.
NOTE: WORK.DEPO2807 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.03 seconds
cpu time 0.02 seconds
167 %io(import,&path/RAW DATA/CBO3007.DBF, &ah_last, DBF);
NOTE: Imported 62 columns and 41571 rows of data from the dBase table file.
NOTE: WORK.CBO2907 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.21 seconds
cpu time 0.17 seconds
168 %io(import,&path/RAW DATA/CBO2907.DBF, &ah_last2, DBF);
NOTE: Imported 62 columns and 41599 rows of data from the dBase table file.
NOTE: WORK.CBO2807 data set was successfully created.
NOTE: PROCEDURE IMPORT used (Total process time):
real time 0.22 seconds
cpu time 0.18 seconds
169
170 data &depo_last;
171 set &depo_last;
172 AccountNo = compress(tranwrd(AccountNo, "-",""));
173 run;
NOTE: There were 3349 observations read from the data set WORK.DEPO2907.
NOTE: The data set WORK.DEPO2907 has 3349 observations and 22 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
174
175 data &depo_last2;
176 set &depo_last2;
177 AccountNo = compress(tranwrd(AccountNo, "-",""));
178 run;
NOTE: There were 3350 observations read from the data set WORK.DEPO2807.
NOTE: The data set WORK.DEPO2807 has 3350 observations and 22 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
7 The SAS System 15:25 Monday, August 9, 2021
cpu time 0.00 seconds
179
180 data &ah_last (drop=old);
181 set &ah_last (rename=(ACCT_NO=oldACCT CUST_NO=oldCUST SEGMENT_ID=oldSEGMENT_ID ACCT_TYPE=oldACCT_TYPE));
182 ACCT_NO=input(oldACCT,16.0);
183 CUST_NO=input(oldCUST,16.0);
184 SEGMENT_ID=input(oldSEGMENT_ID,16.0);
185 ACCT_TYPE=input(oldACCT_TYPE,16.0);
186 run;
WARNING: The variable old in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 41571 observations read from the data set WORK.CBO2907.
NOTE: The data set WORK.CBO2907 has 41571 observations and 66 variables.
NOTE: DATA statement used (Total process time):
real time 0.14 seconds
cpu time 0.07 seconds
187
188 data &ah_last2 (drop=old);
189 set &ah_last2 (rename=(ACCT_NO=oldACCT CUST_NO=oldCUST SEGMENT_ID=oldSegmentID ACCT_TYPE=oldACCT_TYPE));
190 ACCT_NO=input(oldACCT,16.0);
191 CUST_NO=input(oldCUST,16.0);
192 SEGMENT_ID=input(oldSegmentID,16.0);
193 ACCT_TYPE=input(oldACCT_TYPE,16.0);
194 run;
WARNING: The variable old in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 41599 observations read from the data set WORK.CBO2807.
NOTE: The data set WORK.CBO2807 has 41599 observations and 66 variables.
NOTE: DATA statement used (Total process time):
real time 0.11 seconds
cpu time 0.07 seconds
195
196 data &depo_last (drop=old);
197 set &depo_last (rename=(AccountNo=oldACCT SegmentCo=oldSegmentCo Balance=oldBalance));
198 AccountNo=input(oldACCT,16.0);
199 Balance=input(oldBalance,16.0);
200 SegmentCo=input(oldSegmentCo,16.0);
201 run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
199:19
WARNING: The variable old in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 3349 observations read from the data set WORK.DEPO2907.
NOTE: The data set WORK.DEPO2907 has 3349 observations and 25 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
202
203
204 data &depo_last2 (drop=old);
8 The SAS System 15:25 Monday, August 9, 2021
205 set &depo_last2 (rename=(AccountNo=oldACCT SegmentCo=oldSegmentCo Balance=oldBalance));
206 AccountNo=input(oldACCT,16.0);
207 Balance=input(oldBalance,16.0);
208 SegmentCo=input(oldSegmentCo,16.0);
209 run;
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
207:19
WARNING: The variable old in the DROP, KEEP, or RENAME list has never been referenced.
NOTE: There were 3350 observations read from the data set WORK.DEPO2807.
NOTE: The data set WORK.DEPO2807 has 3350 observations and 25 variables.
NOTE: DATA statement used (Total process time):
real time 0.02 seconds
cpu time 0.01 seconds
210
211 proc sql;
212 create table lastworking2 as
213 select * from &depo_last, &ah_last.cust_no as CIF, &ah_last.name1, &ah_last.name2,&ah_last.add1, &ah_last.add2,
__
22
76
213 ! &ah_last.add3, &ah_last.add4, &ah_last.telex_no, &ah_last.acct_type, &ah_last.int_rate, &ah_last.DEAL_COM_D,
213 ! &ah_last.DEAL_MAT_D from &depo_last2
ERROR 22-322: Syntax error, expecting one of the following: ;, ',', ANSIMISS, CROSS, EXCEPT, FULL, GROUP, HAVING, INNER, INTERSECT,
JOIN, LEFT, NATURAL, NOMISS, ORDER, OUTER, RIGHT, UNION, WHERE.
ERROR 76-322: Syntax error, statement will be ignored.
Thanks
Click image to register for webinar
