1 The SAS System 15:40 Thursday, October 24, 2019
1 ;*';*";*/;quit;run;
2 OPTIONS PAGENO=MIN;
3 %LET _CLIENTTASKLABEL='importRawData';
4 %LET _CLIENTPROCESSFLOWNAME='Process Flow';
5 %LET _CLIENTPROJECTPATH='C:\Users\3684003\OneDrive - MyEEEE\ModularPMCode.egp';
6 %LET _CLIENTPROJECTPATHHOST='WHQ-3684003';
7 %LET _CLIENTPROJECTNAME='ModularPMCode.egp';
8 %LET _SASPROGRAMFILE='';
9 %LET _SASPROGRAMFILEHOST='';
10
11 ODS _ALL_ CLOSE;
12 OPTIONS DEV=PNG;
_________________________________
49
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between a quoted string and the succeeding identifier is recommended.
13 GOPTIONS XPIXELS=0 YPIXELS=0;
14 FILENAME EGSR TEMP;
15 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR
16 STYLE=HTMLBlue
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css")
17 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome/SASEnterpriseGuide/7.1/Styles/HTMLBlue.css"
___________________________________________________________________________________________
49
17 ! )
NOTE 49-169: The meaning of an identifier after a quoted string might change in a future SAS release. Inserting white space
between a quoted string and the succeeding identifier is recommended.
18 NOGTITLE
19 NOGFOOTNOTE
20 GPATH=&sasworklocation
21 ENCODING=UTF8
22 options(rolap="on")
23 ;
24
25 GOPTIONS ACCESSIBLE;
26
27
28 %macro importRawData(
29 forecast_input_table = ,
30 equipment_code_table = ,
31 uld_standards_table = ,
32 aircraft_standards_table = ,
33 outlib=
34 );
35
36
37 /* Import Equipment Code. */
38
39 proc sql;
40 create table &outlib..equip_code as
41 select equip_cd, brief_equip_desc
NOTE: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation
marks.
42 from &equipment_code_table.;
2 The SAS System 15:40 Thursday, October 24, 2019
43
44
45
46 /* Import ULD Standards. */
47 proc sql;
48 create table &outlib..uld_stndrds as
49 select *
50 from &uld_standards_table.;
51
52 /* Import Aircraft Offload Standards. */
53 proc sql;
54 create table &outlib..ac_stndrds as
55 select *
56 from &aircraft_standards_table.;
57
58
59
60 /*Import Forecast Data*/
61
62 proc sql;
63 create table &outlib..in_forecast as
64 select *,
65 1 as counter,
66 t2.brief_equip_desc as equip_type
67 from &forecast_input_table. t1
68
69 left outer join
70 (select equip_cd, brief_equip_desc from &outlib..equip_code) as t2
71 on t1.equip_cd = t2.equip_cd
72
73 order by sched_local;
74
75
76
77 %mend importRawData;
78
79
80
81
82
83
84
85
86
87
88
89 GOPTIONS NOACCESSIBLE;
90 %LET _CLIENTTASKLABEL=;
91 %LET _CLIENTPROCESSFLOWNAME=;
92 %LET _CLIENTPROJECTPATH=;
93 %LET _CLIENTPROJECTPATHHOST=;
94 %LET _CLIENTPROJECTNAME=;
95 %LET _SASPROGRAMFILE=;
96 %LET _SASPROGRAMFILEHOST=;
97
98 ;*';*";*/;quit;run;
99 ODS _ALL_ CLOSE;
100
3 The SAS System 15:40 Thursday, October 24, 2019
101
102 QUIT; RUN;
103
This error keeps popping up. The code works sometimes, and sometimes it doesn't work! Very irritating.
