Hi,
What is really happening is that the value EG was setting to SYSLAST when I explicitly link a data set to a program in a process flow.
EG in setting the SYSLAST macro to the linked data set. Because of this I am getting the following error.
ERROR: Invalid option value IDATASET.'TABLE'n for SAS option _LAST_.
If I don't link the dataset to the program in a process flow, the program runs without any errors. Here is the log.
1 The SAS System 10:50 Friday, December 14, 2018
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
ERROR: Invalid option value IDATASET.'TABLE'n for SAS option _LAST_.
3 %LET SYSLAST=IDATASET.'TABLE'n ;
4 %LET _CLIENTTASKLABEL='PA_1';
5 %LET _CLIENTPROCESSFLOWNAME='PENALTIES ALL';
6 %LET _CLIENTPROJECTPATH='C:\Users\XXXXXXX\Desktop\ANALYSIS.egp';
7 %LET _CLIENTPROJECTNAME=ANALYSIS.egp';
8 %LET _SASPROGRAMFILE=;
9
10 ODS _ALL_ CLOSE;
11 OPTIONS DEV=ACTIVEX;
12 GOPTIONS XPIXELS=0 YPIXELS=0;
13 FILENAME EGSR TEMP;
14 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
15 STYLE=HtmlBlue
16 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css")
17 NOGTITLE
18 NOGFOOTNOTE
19 GPATH=&sasworklocation
20 ENCODING=UTF8
21 options(rolap="on")
22 ;
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
23
24 GOPTIONS ACCESSIBLE;
25 /* Insert custom code before submitted code here */
26
27
28 DATA IH_WORK.WANT;
29 SET
30 IDATASET.TABLE (DROP= VARINFO XREFMFT XREFTXPD XREFTIN)
31 IDATASET.TABLE2 (DROP= VARINFO);
32 IF TRANCD = '999' AND VARFIELD NOT = '000';
33 RUN;
NOTE: There were 667876 observations read from the data set IDATASET.TABLE.
NOTE: There were 354978 observations read from the data set IDATASET.TABLE2.
NOTE: The data set IH_WORK.WANT has 1018545 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 3.26 seconds
cpu time 1.81 seconds
34
35
36
37 /* Insert custom code after submitted code here */
38
39 GOPTIONS NOACCESSIBLE;
40 %LET _CLIENTTASKLABEL=;
41 %LET _CLIENTPROCESSFLOWNAME=;
42 %LET _CLIENTPROJECTPATH=;
43 %LET _CLIENTPROJECTNAME=;
44 %LET _SASPROGRAMFILE=;
45
46 ;*';*";*/;quit;run;
47 ODS _ALL_ CLOSE;
2 The SAS System 10:50 Friday, December 14, 2018
48
49
50 QUIT; RUN;
51
