Hi Kurt, Posting the below log: 1 The SAS System 11:14 Friday, May 11, 2018
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='Program';
4 %LET _CLIENTPROJECTPATH='';
5 %LET _CLIENTPROJECTNAME='';
6 %LET _SASPROGRAMFILE=;
7
8 ODS _ALL_ CLOSE;
9 OPTIONS DEV=ACTIVEX;
10 GOPTIONS XPIXELS=0 YPIXELS=0;
11 FILENAME EGSR TEMP;
12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR STYLE=HtmlBlue
12 ! STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/5.1/Styles/HtmlBlue.css") NOGTITLE NOGFOOTNOTE
12 ! GPATH=&sasworklocation ENCODING=UTF8 options(rolap="on");
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
13
14 GOPTIONS ACCESSIBLE;
15 LIBNAME SAPLib SASIOSR3 ashost=XXXXXX sysnr=15 BatchMode=1 trace=0 language=EN Client=900
16 AUTHDOMAIN="SAPAuthPROD" ;
NOTE: Libref YYYYY was successfully assigned as follows:
Engine: R3
Physical Name: XXXXXX
17
18 proc sql;
19 create table test as
20 select
21 a.A1
22 a.A2,
23 a.A3,
24 a.A4,
25 a.A5Y,
26
27
28 from XXXX."TABLE"n as a
29 where a.A1>= '01apr2017'd and a.A1<'01feb2018'd
30 and a."A2"n IN ('000000000X1','000000000X2','00000000X3')
201 and a."A3"n = 'H'
202 and a."A4"n IN ('101','102','641','642');
ERROR: Error generating subroutine at line: 154. List elements that take up more than one line are not allowed - Word: OPEN
. Offset: 1 .
NOTE: PROC SQL set option NOEXEC and will continue to check the syntax of statements.
203 quit;
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.20 seconds
cpu time 0.03 seconds
204
205
206 GOPTIONS NOACCESSIBLE;
207 %LET _CLIENTTASKLABEL=;
208 %LET _CLIENTPROJECTPATH=;
209 %LET _CLIENTPROJECTNAME=;
210 %LET _SASPROGRAMFILE=;
211
212 ;*';*";*/;quit;run;
213 ODS _ALL_ CLOSE;
214
215
5 The SAS System 11:14 Friday, May 11, 2018
216 QUIT; RUN;
217
... View more