SAS Log
1 The SAS System 17:15 Thursday, July 6, 2017
NOTE: Copyright (c) 2002-2010 by SAS Institute Inc., Cary, NC, USA.
NOTE: SAS (r) Proprietary Software 9.3 (TS1M2)
Licensed to LOUISIANA STATE UNIV / ITS-ADMIN, Site 70074566.
NOTE: This session is executing on the X64_S08R2 platform.
NOTE: Enhanced analytical products:
SAS/STAT 12.1
NOTE: SAS Initialization used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
NOTE: The autoexec file, D:\SAS\EnterpriseSAS\Lev1\SASApp\StoredProcessServer\autoexec.sas, was executed at server initialization.
>>> SAS Macro Variables:
EFFDTE=20161130
SYSDBMSG=
SYSDBRC=0
_APSLIST=_url,_htua,EFFDTE,_client,_htcook,_result,_ODSDEST,_grafloc,_program,_reqmeth,_rmtaddr,_rmthost,_srvname,_srvport,_version,_metauser,_password,_username,_metafolder,_metaperson,_userloc
ale,_SECUREUSERNAME
_CLIENT=StoredProcessService 9.3; JVM 1.6.0_30; Windows Server 2008 R2 (amd64) 6.1
_GRAFLOC=/sasweb/graph
_HTCOOK=_ga=GA1.2.833841193.1398869373; __unam=7ac2274-151253bf750-b2127a8-1186; JSESSIONID=F409B508A4682C93D6AA30D9FE42DC38; sso-logout-time="Fri Jul 07 2017 00:43:24 GMT-0500 (Central Daylight
Time)"; LtpaToken=AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc+/8JzfxUYXTO9YDQKGSzODv
_HTUA=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.86 Safari/537.36
_METAFOLDER=/FSS/
_METAPERSON=FSSGuest
_METAUSER=FSSGuest@saspw
_ODSDEST=PDF
_PASSWORD=XXXXXX
_PROGRAM=/FSS/FUNDCOL2
_REPLAY="&_URL?_sessionid=0395FEF2-8018-4AAC-B374-C1F289C746BF&_program=replay&_entry=&_TMPCAT.."
_REQMETH=POST
_RESULT=STREAM
_RMTADDR=130.39.75.8
_RMTHOST=130.39.75.8
_SECUREUSERNAME=FSSGuest
_SRVNAME=sasdreporting.lsu.edu
_SRVPORT=8443
_TMPCAT=APSWORK.TCAT0013
_URL=/SASStoredProcess/do
_USERLOCALE=en_US
_USERNAME=FSSGuest@saspw
_VERSION=Version 9.3 (Build 478)
NOTE: %INCLUDE (level 1) file D:\SAS Stored Processes\FSS\FUNDCOL2.sas is file D:\SAS Stored Processes\FSS\FUNDCOL2.sas.
2 +* Begin EG generated code (do not edit this line);
3 +*
4 +* Stored process registered by
5 +* Enterprise Guide Stored Process Manager V5.1
6 +*
7 +* ====================================================================
8 +* Stored process name: FUNDCOL2
9 +* ====================================================================
10 +*
11 +* Stored process prompt dictionary:
12 +* ____________________________________
13 +* _ODSDEST
14 +* Type: Text
15 +* Label: _ODSDEST
16 +* Attr: Visible
17 +* ____________________________________
18 +* EFFDTE
19 +* Type: Text
20 +* Label: EFFDTE
21 +* Attr: Visible
22 +* ____________________________________
23 +*;
24 +
25 +
26 +*ProcessBody;
27 +
28 +%global _ODSDEST
29 + EFFDTE;
30 +
31 +OPTIONS VALIDVARNAME=ANY;
32 +
33 +%macro ExtendValidMemName;
34 +
35 +%if %sysevalf(&sysver>=9.3) %then options validmemname=extend;
36 +
37 +%mend ExtendValidMemName;
38 +
The SAS System
39 +%ExtendValidMemName;
40 +
41 +* End EG generated code (do not edit this line);
42 +
43 +OPTIONS MISSING = ' '
44 + LINESIZE=145 symbolgen;
45 +
46 +%GetLSUUser
SYMBOLGEN: Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN: Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN: Macro variable _HTCOOK resolves to _ga=GA1.2.833841193.1398869373; __unam=7ac2274-151253bf750-b2127a8-1186;
JSESSIONID=F409B508A4682C93D6AA30D9FE42DC38; sso-logout-time="Fri Jul 07 2017 00:43:24 GMT-0500 (Central Daylight Time)";
LtpaToken=AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc+/8JzfxUYXTO9YDQKGSzODv
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable VALUE resolves to AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc%2B/8JzfxUYXTO9YDQKGSzODv
SYMBOLGEN: Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN: Macro variable _METAUSER resolves to FSSGuest@saspw
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
46:118 46:240
NOTE: The infile LSU is:
Filename=http://cgi.lsu.edu:8080/eis/servlet/getuser?LtpaToken=AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc%2B/8JzfxUYXTO9YDQKGSzODv,
Local Host Name=SASDCOMPUTE,
Local Host IP addr=fe80::602f:416e:d266:b362%11,
Service Hostname Name=cgi.uis.lsu.edu,
Service IP addr=130.39.20.36,Service Name=N/A,
Service Portno=8080,Lrecl=2000,Recfm=Stream
NOTE: 1 record was read from the infile LSU.
The minimum record length was 33.
The maximum record length was 33.
NOTE: DATA statement used (Total process time):
The SAS System
real time 0.01 seconds
cpu time 0.00 seconds
**END*USEREND*USER**
SYMBOLGEN: Macro variable _LSUPERSON resolves to Keri M Tweed
SYMBOLGEN: Macro variable _LSUUSER resolves to ktweed
**** This stored process was requested by Keri M Tweed with LSUUSERID: ktweed
**END*USEREND*USER**
SYMBOLGEN: Macro variable _INFILE resolves to 0
SYMBOLGEN: Macro variable _INUSER resolves to 1
47 + *** ENTER EFFECTIVE DATE ***;
48 +*%LET EFFDTE = 20170626;
49 +
50 +DATA DATE;
51 + EFFDTE = "&EFFDTE";
SYMBOLGEN: Macro variable EFFDTE resolves to 20161130
52 + EFFDTEX = INPUT(PUT(EFFDTE,8.),$8.);
53 + FORMAT EFFYR $4.;
54 + EFFYR = SUBSTR(EFFDTEX,1,4);
55 + EFFMN = SUBSTR(EFFDTEX,5,2);
56 + IF EFFMN < 7 THEN FISCAL = EFFYR;
57 + ELSE FISCAL = EFFYR + 1;
58 + FYEARX = COMPRESS("'"||TRIM(FISCAL)||"'");
59 + FYRX = "'"||SUBSTR(FYEARX,4,2)||"'";
60 + PDATE = COMPRESS(EFFYR) || COMPRESS(EFFMN);
61 +/*PFILE = "'ACGR14.PROD.PDF(V" || COMPRESS(PDATE) || ")'";
62 + CALL SYMPUT('PFILE',PFILE);
63 +HFILE = "'ACGR14.PROD.HTML(V" || COMPRESS(PDATE) || ")'";
64 + CALL SYMPUT ('HFILE', HFILE);*/
65 + CALL SYMPUT('FYR',FYRX);
66 + CALL SYMPUT('FYEAR',FYEARX);
67 + CALL SYMPUT('EFFMN',EFFMN);
68 + CALL SYMPUT('EFFYR',EFFYR);
The SAS System
69 + CALL SYMPUT('FISCAL',FISCAL);
70 + TME = TIME();
71 + CALL SYMPUT('TME',TME);
72 +
73 +IF EFFMN = 01 THEN MON = 'JANUARY ';
74 +IF EFFMN = 02 THEN MON = 'FEBRUARY ';
75 +IF EFFMN = 03 THEN MON = 'MARCH ';
76 +IF EFFMN = 04 THEN MON = 'APRIL ';
77 +IF EFFMN = 05 THEN MON = 'MAY ';
78 +IF EFFMN = 06 THEN MON = 'JUNE ';
79 +IF EFFMN = 07 THEN MON = 'JULY ';
80 +IF EFFMN = 08 THEN MON = 'AUGUST ';
81 +IF EFFMN = 09 THEN MON = 'SEPTEMBER';
82 +IF EFFMN = 10 THEN MON = 'OCTOBER ';
83 +IF EFFMN = 11 THEN MON = 'NOVEMBER ';
84 +IF EFFMN = 12 THEN MON = 'DECEMBER ';
85 + CALL SYMPUT('MON',MON);
86 +
87 +BEGFY=FISCAL-1;
88 +BEGFX = INPUT(PUT(BEGFY,4.),$4.);
89 +FISX = INPUT(PUT(FISCAL,4.),$4.);
90 +FORMAT BEGYR ENDYR $2.;
91 +BEGYR = SUBSTR(BEGFX,3,2);
92 +ENDYR = SUBSTR(FISX,3,2);
93 +CALL SYMPUT('BEGYR',BEGYR);
94 +CALL SYMPUT('ENDYR',ENDYR);
95 +
96 + IF EFFMN = 01 THEN HEADER = ' JANUARY';
97 +ELSE IF EFFMN = 02 THEN HEADER = ' FEBRUARY';
98 +ELSE IF EFFMN = 03 THEN HEADER = ' MARCH';
99 +ELSE IF EFFMN = 04 THEN HEADER = ' APRIL';
100 +ELSE IF EFFMN = 05 THEN HEADER = ' MAY';
101 +ELSE IF EFFMN = 06 THEN HEADER = ' JUNE';
102 +ELSE IF EFFMN = 07 THEN HEADER = ' JULY';
103 +ELSE IF EFFMN = 08 THEN HEADER = ' AUGUST';
104 +ELSE IF EFFMN = 09 THEN HEADER = 'SEPTEMBER';
105 +ELSE IF EFFMN = 10 THEN HEADER = ' OCTOBER';
106 +ELSE IF EFFMN = 11 THEN HEADER = ' NOVEMBER';
The SAS System
107 +ELSE IF EFFMN = 12 THEN HEADER = ' DECEMBER';
108 +CALL SYMPUT('HEADER',HEADER);
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
56:6 57:18 73:4 74:4 75:4 76:4 77:4 78:4 79:4 80:4 81:4 82:4 83:4 84:4 87:7 96:9 97:9
98:9 99:9 100:9 101:9 102:9 103:9 104:9 105:9 106:9 107:9
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
57:24 71:20
NOTE: The data set WORK.DATE has 1 observations and 16 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
109 +proc sort; by effmn;
110 +
111 +/*LIBNAME COA DB2 AUTHID=COA SSID=DB2;
112 +LIBNAME SPM DB2 AUTHID=SPM SSID=DB2;
113 +LIBNAME DIR DB2 AUTHID=DIR SSID=DB2;*/
114 +
115 +/ LEGACY COA INFORMATION ****
116 +PROC SQL;
117 + CREATE TABLE COAFILE AS
118 + SELECT P_I_LSU_ID AS PIID
119 + ,ACCT_CODE AS ACCT
120 + ,AGENCY_CD AS AGENCY
121 + ,GRANT_EXPIRE_DATE AS EXPIRE
122 + ,PROPOSAL_NBR AS PROPNBR
123 + ,GRANT_NAME AS STITLE
124 + ,TOTAL_AWARD_AMT AS TOTAWARD
125 + ,CO_P_I_LSU_ID AS COPIID
126 + ,INTERNAL_COMP_FLAG AS INTFLAG
127 + ,TASK_NBR AS TASK
128 +FROM COA.SPONSORED_PROGRAMS
129 +WHERE SUBSTR(ACCT_CODE,1,1) = '1'
130 +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6') AND PROPOSAL_NBR <> 0
131 +AND AGENCY_CD NOT IN ('A1','C','Z','XF') AND BILL_CYCLE_CD <> 'G'
132 +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
The SAS System
133 +'190067') AND FISCAL_YEAR = &FYEAR;
134 +PROC SORT; BY ACCT;*/
135 +
NOTE: There were 1 observations read from the data set WORK.DATE.
NOTE: The data set WORK.DATE has 1 observations and 16 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
136 +PROC SQL;
137 +CREATE TABLE FUND1 AS
138 +SELECT ORG_ID AS GRANT_ID,
139 +FUND
140 +FROM WDM.fin_fdm_DRIVERTAG
141 +WHERE FUND IN ('FD250','FD251','FD252');
NOTE: Table WORK.FUND1 created, with 5580 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
142 +PROC SORT; BY GRANT_ID;
143 +
NOTE: There were 5580 observations read from the data set WORK.FUND1.
NOTE: The data set WORK.FUND1 has 5580 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
144 +PROC SQL;
145 +CREATE TABLE GRANT1 AS
146 +SELECT GRANT_ID,
147 +AWARD_NUMBER as award_budg,
The SAS System
148 +TO_DATE AS GRANT_EXP_DATE,
149 +sponsor_id,
150 +cont_line_status,
151 +workday_id,
152 +CONT_STATUS,
153 +is_primary
154 +FROM WDM.FIN_AWD_LINE
155 +where company = '10' and cont_status NE ' ';
NOTE: Table WORK.GRANT1 created, with 3013 rows and 8 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
156 +PROC SORT; BY GRANT_ID;
157 +
NOTE: There were 3013 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.GRANT1 has 3013 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
158 +DATA MRG1; MERGE FUND1(IN=A) GRANT1(IN=B); BY GRANT_ID; IF A AND B;
NOTE: There were 5580 observations read from the data set WORK.FUND1.
NOTE: There were 3013 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.MRG1 has 2710 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
159 +PROC SORT; BY sponsor_id;
160 +
The SAS System
NOTE: There were 2710 observations read from the data set WORK.MRG1.
NOTE: The data set WORK.MRG1 has 2710 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
161 +proc sql;
162 +create table SPON as
163 +select sponsor_id,
164 +SPONSOR_NAME,
165 +sponsor_type
166 +from wdm.fin_awd_sponsor;
NOTE: Table WORK.SPON created, with 1536 rows and 3 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
167 +proc sort; by sponsor_id;
168 +
NOTE: There were 1536 observations read from the data set WORK.SPON.
NOTE: The data set WORK.SPON has 1536 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
169 +data mrgspon; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
NOTE: There were 2710 observations read from the data set WORK.MRG1.
NOTE: There were 1536 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSPON has 2710 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The SAS System
170 +PROC SORT; BY award_budg grant_id cont_line_status descending is_primary ;
171 +
NOTE: There were 2710 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.MRGSPON has 2710 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
172 +data setspon; set mrgspon; BY award_budg grant_id cont_line_status descending is_primary ;
173 +if first.grant_id then output;
NOTE: There were 2710 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.SETSPON has 2706 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
174 +proc sort; by workday_id;
175 +
NOTE: There were 2706 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.SETSPON has 2706 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
176 +proc sql;
177 +create table task as
178 +select workday_id,
179 +org_id as tasknbr
180 +from WDM.FIN_AWD_LINE_ORG
181 +where substr(org_id,1,2) = 'TA';
The SAS System
NOTE: Table WORK.TASK created, with 5436 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
182 +proc sort; by workday_id;
183 +
NOTE: There were 5436 observations read from the data set WORK.TASK.
NOTE: The data set WORK.TASK has 5436 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
184 +data mrggrnt; merge task(in=a) setspon(in=b); by workday_id;
185 +if b;
NOTE: There were 5436 observations read from the data set WORK.TASK.
NOTE: There were 2706 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.MRGGRNT has 2706 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
186 +proc sort; by award_budg;
187 +
NOTE: There were 2706 observations read from the data set WORK.MRGGRNT.
NOTE: The data set WORK.MRGGRNT has 2706 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The SAS System
188 +PROC SQL;
189 +CREATE TABLE AWARD1 AS
190 +SELECT AWARD_NUMBER as award_budg,
191 +PROPOSAL_ID as propnbr,
192 +AWARD_NAME,
193 +signed_date,
194 +TOTAL_AMOUNT AS AWD_TOTAL,
195 +award_date
196 +FROM WDM.FIN_AWD
197 +WHERE PROPOSAL_ID NE 0 and
198 +award_type not in ('SPN_AWD_Type_Disaster_Relief','SPN_AWD_Type_Pell_SEOG_CWS','SPN_AWD_Type_Federal_Appropriations');
NOTE: Table WORK.AWARD1 created, with 1707 rows and 6 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
199 +PROC SORT; BY award_budg;
200 +
NOTE: There were 1707 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.AWARD1 has 1707 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
201 +DATA MRG2; MERGE mrggrnt(IN=A) AWARD1(IN=B); BY award_budg; IF A AND B;
202 +format TASK 2.;
203 +task = substr(taskNBR,3,2);
204 +if task = 0 then task = 1;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
203:8
NOTE: There were 2706 observations read from the data set WORK.MRGGRNT.
NOTE: There were 1707 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.MRG2 has 2415 observations and 18 variables.
The SAS System
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
205 +PROC SORT; BY award_budg;
206 +
207 +/*PROC SQL;
208 +CREATE TABLE LEADPI AS
209 +SELECT EMPLOYEE_ID AS WD_PIID,
210 +ORG_ID AS GRANT_ID,
211 +ROLE_NAME AS ROLE1
212 +FROM WDM.WORKER_ROLE
213 +WHERE role_name = 'Principal_Investigator';
214 +PROC SORT; BY WD_PIID;
215 +
216 +PROC SQL;
217 +CREATE TABLE LSUPIID AS
218 +SELECT EMPLOYEE_ID AS WD_PIID,
219 +LSU_ID AS LSU_PIID
220 +FROM WDM.KEYS;
221 +PROC SORT; BY WD_PIID;
222 +
223 +DATA MRGPI;
224 +MERGE LEADPI(IN=A) LSUPIID(IN=B); BY WD_PIID; IF A;
225 +PROC SORT; BY GRANT_ID;
226 +
227 +DATA MRG3; MERGE MRG2(IN=A) MRGPI(IN=B); BY GRANT_ID; IF A;
228 +PROC SORT; BY award_budg;*/
229 +
230 +/*PROC SQL;
231 +CREATE TABLE COPI AS
232 +SELECT EMPLOYEE_ID AS WD_COPIID,
233 +ORG_ID AS GRANT_ID,
234 +ROLE_NAME AS ROLE2
235 +FROM WDM.WORKER_ROLE
236 +WHERE role_name = 'Co-Principal_Investigator';
237 +PROC SORT; BY WD_COPIID;
The SAS System
238 +
239 +PROC SQL;
240 +CREATE TABLE LSUCOPIID AS
241 +SELECT EMPLOYEE_ID AS WD_COPIID,
242 +LSU_ID AS LSU_COPIID
243 +FROM WDM.KEYS;
244 +PROC SORT; BY WD_COPIID;
245 +
246 +DATA MRGCOPI;
247 +MERGE COPI(IN=A) LSUCOPIID(IN=B); BY WD_COPIID; IF A;
248 +PROC SORT; BY GRANT_ID;
249 +
250 +DATA MRG4; MERGE MRG3(IN=A) MRGCOPI(IN=B); BY GRANT_ID; IF A;
251 +PROC SORT; BY award_budg;*/
252 +
NOTE: There were 2415 observations read from the data set WORK.MRG2.
NOTE: The data set WORK.MRG2 has 2415 observations and 18 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
253 +proc sql;
254 +CREATE TABLE SPEC AS
255 +SELECT AWARD_NUMBER as award_budg,
256 +REF_ID
257 +FROM WDM.FIN_AWD_SPEC_COND
258 +WHERE REF_ID = 'Special_Condition_Type_Internal_Competition';
NOTE: Table WORK.SPEC created, with 36 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
259 +PROC SORT; BY award_budg;
260 +
The SAS System
NOTE: There were 36 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.SPEC has 36 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
261 +DATA MRG5; MERGE MRG2(IN=A) SPEC(IN=B); BY award_budg; IF A;
NOTE: There were 2415 observations read from the data set WORK.MRG2.
NOTE: There were 36 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.MRG5 has 2415 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
262 +PROC SORT; BY award_budg grant_id;
263 +
NOTE: There were 2415 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.MRG5 has 2415 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
264 +data setmrg5; set mrg5; by award_budg grant_id;
265 +if first.grant_id ne last.grant_id then output;
NOTE: There were 2415 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.SETMRG5 has 0 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The SAS System
266 +proc sort; by award_budg grant_id;
267 +
268 +
269 +
270 +/*PROC SQL;
271 + CREATE TABLE SPAFILE AS
272 + SELECT ACCT_CODE AS ACCT
273 + ,BEGIN_DATE AS BEGIN
274 + ,INIT_TIMESTAMP AS IADD
275 + ,LONG_TITLE AS LONG
276 +FROM COA.ACCOUNTS
277 +WHERE CAMPUS_CD = '1' AND ACCT_TYPE = 'S'
278 +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6')
279 +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
280 +'190067') AND FISCAL_YEAR = &FYEAR;
281 +
282 +PROC SORT; BY ACCT;
283 +
284 +DATA COAS;
285 + MERGE COAFILE(IN=A) SPAFILE(IN=B);
286 + BY ACCT;
287 + IF A AND B;
288 +
289 +PROC SORT DATA = COAS; BY ACCT;
290 +
291 +DATA COA1(KEEP=STITLE LONG ACCT AGENCY EXPIRE BEGIN ADDTE TOTAWARD
292 + PIID COPIID PROPNBR INTFLAG TASK);
293 + SET COAS;
294 + FORMAT STITLE $60.;
295 + FORMAT ADATE YYMMDDN8.;
296 + ADATE = DATEPART(IADD);
297 + FORMAT BEGIN YYMMDDN8.;
298 + FORMAT EXPIRE YYMMDDN8.;
299 + AYR = YEAR(ADATE);
300 + AMTH= MONTH(ADATE);
301 + MONA = INPUT(PUT(AMTH,Z2.),$2.);
302 + YEARA = INPUT(PUT(AYR,4.),$4.);
303 + ADDTE = YEARA||MONA;
The SAS System
304 + *IF BEGIN <= &DATE;*/
305 +
NOTE: Input data set is empty.
NOTE: The data set WORK.SETMRG5 has 0 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
306 +PROC SQL;
307 +CREATE TABLE BUDG AS
308 +SELECT grant_id,
309 +grant_name,
310 +ledger_account,
311 +budget_revenue as AMT,
312 +budget_obj,
313 +award_name,
314 +award_report_code as BAADJCD,
315 +budget_amendment_date,
316 +budget_date_from
317 +from workday.award_budget
318 +where ledger_account in ('4200:Federal Grants and Contracts Revenue','4210:State and Local Grants and Contracts Revenue',
319 +'4220:Non-governmental Grants and Contracts Revenue','4230:Grants and Contracts Revenue') and budget_amendment_status not in
319 !+('Canceled','Draft','Denied')
320 +and company_code = 'LSUAM' and
321 +award_report_code in ('New','Continuation') ;
NOTE: Table WORK.BUDG created, with 868 rows and 9 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
322 +proc sort; by grant_id;
323 +
NOTE: There were 868 observations read from the data set WORK.BUDG.
The SAS System
NOTE: The data set WORK.BUDG has 868 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
324 +data set1; set budg; by grant_id;
325 +format BUDGET_DATE1 yymmddn.;
326 +budget_date1 = budget_amendment_date;
327 +award_budg = scan(budget_obj,1,":");
NOTE: There were 868 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.SET1 has 868 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
328 +proc sort; by award_budg grant_id;
329 +
NOTE: There were 868 observations read from the data set WORK.SET1.
NOTE: The data set WORK.SET1 has 868 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
330 +data MARGE; merge mrg5(in=a) set1(in=b); by award_budg grant_id; if a and b;
331 +format budget_date yymmddn.;
332 +if budget_date1 = ' ' then budget_date = signed_date; else budget_date = budget_date1;
333 +if budget_date = ' ' then delete;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
332:19 333:18
WARNING: Multiple lengths were specified for the BY variable award_budg by input data sets. This may cause unexpected results.
NOTE: There were 2415 observations read from the data set WORK.MRG5.
NOTE: There were 868 observations read from the data set WORK.SET1.
The SAS System
NOTE: The data set WORK.MARGE has 867 observations and 28 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
334 +proc sort; by grant_id budget_date;
335 +
NOTE: There were 867 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE has 867 observations and 28 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
336 +data marge1; set marge; by grant_id budget_date;
337 +effdte = INPUT(PUT(budget_date,yymmddn.),8.);
338 +*if effdte <= 20160930 then output;
NOTE: There were 867 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE1 has 867 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
339 +proc sort; by grant_id;
340 +
341 +/*
342 +DATA GLSD;
343 + INFILE GLSD;
344 + INPUT @1 FY $2.
345 + @3 ENTRY PD5.
346 + @10 ACCT $9.
347 + @19 TT $1.
348 + @20 OBJ $4.
349 + @24 SUBOBJ $1.
The SAS System
350 + @29 AMT PD6.2
351 + @168 BAADJCD $1.;
352 + IF TT = 'I' AND SUBSTR(ACCT,1,1) = '1' AND
353 + SUBSTR(ACCT,6,1) IN ('4','5','6') AND FY = &FYR
354 + AND BAADJCD IN ('N','C');
355 + IF AMT = 0 THEN DELETE;
356 + SF = SUBSTR(ACCT,6,1);
357 +
358 +PROC SORT DATA=GLSD; BY FY ENTRY;
359 +
360 +DATA GLSUSRS;
361 + INFILE GLSUSR;
362 + INPUT @ 1 FY $2.
363 + @ 3 ENTRY PD5.
364 + @ 8 ENTRYTYP $2.
365 + @ 57 VCHRTYPE $2.
366 + @ 64 EFFDTE PD5.
367 + @ 69 STATUS $1.;
368 + IF STATUS = 'C';
369 + IF FY = &FYR ;
370 + IF ENTRYTYP = 'GE';
371 +
372 +PROC SORT DATA=GLSUSRS; BY FY ENTRY;
373 +
374 +DATA GLS;
375 + MERGE GLSUSRS(IN=A) GLSD(IN=B);
376 + BY FY ENTRY;
377 + IF A AND B;
378 +
379 +
380 +PROC SORT; BY ACCT;
381 +
382 +DATA GLSCOA;
383 + MERGE COA1(IN=A) GLS(IN=B);
384 + BY ACCT;
385 + IF A AND B;
386 +
387 +PROC SORT DATA = GLSCOA; BY FY ACCT ENTRY;*/
The SAS System
388 +
NOTE: There were 867 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.MARGE1 has 867 observations and 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
389 +DATA BUDG1 (DROP= EMTH ENDYRX BEGYRX END BEG);
390 + SET marge1; by grant_id effdte;
391 + *BY FY ACCT ENTRY;
392 + *edate = effdte;
393 + EDATE = INPUT(PUT(effdte,8.),YYMMDD8.);
394 + EMTH= MONTH(EDATE);
395 +
396 + IF effdte <= &EFFDTE;
SYMBOLGEN: Macro variable EFFDTE resolves to 20161130
397 +
398 + EMNX = INPUT(PUT(EMTH,Z2.),$2.);
399 + ENDYRX = &ENDYR;
SYMBOLGEN: Macro variable ENDYR resolves to 17
400 + BEGYRX = &BEGYR;
SYMBOLGEN: Macro variable BEGYR resolves to 16
401 + END = INPUT(PUT(ENDYRX,Z2.),$2.);
402 + BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
403 + IF EMTH > 6 THEN ACTDTE = BEG||EMNX;
404 + ELSE ACTDTE = END||EMNX;
405 +
406 + IF EMNX = &EFFMN THEN MONAMT = AMT;
SYMBOLGEN: Macro variable EFFMN resolves to 11
407 + ELSE MONAMT = 0;
408 +
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
406:6
NOTE: There were 867 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.BUDG1 has 142 observations and 33 variables.
The SAS System
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
409 +PROC SORT DATA = budg1; BY ACTDTE grant_id;
410 +
NOTE: There were 142 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.BUDG1 has 142 observations and 33 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
411 +DATA GLSCOA15(DROP=AMT MONAMT); SET budg1;
412 + BY ACTDTE grant_id;
413 + IF FIRST.grant_id THEN DO;
414 + IF BAADJCD = 'New' THEN DO;
415 + NACCTAMT = AMT; NTOTMON = MONAMT;
416 + CACCTAMT = 0; CTOTMON = 0;
417 + END;
418 + IF BAADJCD = 'Continuation' THEN DO;
419 + NACCTAMT = 0; NTOTMON = 0;
420 + CACCTAMT = AMT; CTOTMON = MONAMT;
421 + END;
422 + END;
423 + ELSE DO;
424 + IF BAADJCD = 'New' THEN DO;
425 + NACCTAMT + AMT; NTOTMON + MONAMT;
426 + CACCTAMT + 0; CTOTMON + 0;
427 + END;
428 + IF BAADJCD = 'Continuation' THEN DO;
429 + NACCTAMT + 0; NTOTMON + 0;
430 + CACCTAMT + AMT; CTOTMON + MONAMT;
431 + END;
432 + END;
433 + IF LAST.grant_id THEN OUTPUT;
The SAS System
NOTE: There were 142 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 139 observations and 35 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
434 + proc sort; by grant_id;
435 +
NOTE: There were 139 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA15 has 139 observations and 35 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
436 + data glscoa16; set glscoa15; by grant_id;
437 + if (NACCTAMT = 0 and NTOTMON = 0 and CACCTAMT = 0 and CTOTMON = 0) then delete;
NOTE: There were 139 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA16 has 139 observations and 35 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
438 + proc sort; by grant_id;
439 +
440 +
NOTE: There were 139 observations read from the data set WORK.GLSCOA16.
NOTE: The data set WORK.GLSCOA16 has 139 observations and 35 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
The SAS System
441 +PROC SQL;
442 + CREATE TABLE PROJTRAN AS
443 +SELECT PROPOSAL_NBR AS PROPNBR
444 + ,TRX_NBR AS TRXNBR
445 + ,TRX_TYPE AS TRXTYPE
446 + ,TRX_STATUS AS TRXSTAT
447 + ,TO_SPA_DATE AS RELDATE
448 +FROM SPM.PROJ_TRANSACTION
449 + WHERE TRX_STATUS IN ('AC','TE','CO');
NOTE: Table WORK.PROJTRAN created, with 17727 rows and 5 columns.
450 +
NOTE: PROCEDURE SQL used (Total process time):
real time 0.07 seconds
cpu time 0.01 seconds
451 +PROC SORT; BY PROPNBR TRXNBR RELDATE;
452 +
NOTE: There were 17727 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.PROJTRAN has 17727 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
453 +DATA SPS2;
454 + SET PROJTRAN; BY PROPNBR TRXNBR;
455 + LENGTH MO YY $2.;
456 + LENGTH YR $4.;
457 + MO=MONTH(RELDATE);
458 + YR=YEAR(RELDATE);
459 + YY=SUBSTR(YR,3,2);
460 + LENGTH EFFMY $4.;
461 + EFFMY=YY||MO;
462 + IF SUBSTR(EFFMY,3,1)=' ' THEN SUBSTR(EFFMY,3,1)='0';
The SAS System
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
457:8 458:8
NOTE: Missing values were generated as a result of performing an operation on missing values.
Each place is given by: (Number of times) at (Line):(Column).
212 at 457:8 212 at 458:8
NOTE: There were 17727 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.SPS2 has 17727 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
463 + PROC SORT; BY PROPNBR EFFMY RELDATE;
464 +
NOTE: There were 17727 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17727 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
465 + PROC SORT; BY PROPNBR TRXNBR;
466 +
NOTE: There were 17727 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17727 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
467 +PROC SQL;
468 + CREATE TABLE PISHR AS
469 + SELECT PROPOSAL_NBR AS PROPNBR,
470 + TRX_NBR AS TRXNBR,
471 + TASK_NBR AS TASK,
The SAS System
472 + LSU_ID AS LSUID,
473 + INVESTIGATOR_TYPE AS INVTYPE,
474 + DEPT_CD AS DEPT,
475 + PROJECT_SHARE AS SHARE
476 + FROM SPM.PROJ_INVESTIGATOR
477 + WHERE PROJECT_SHARE > 0;
NOTE: Table WORK.PISHR created, with 72959 rows and 7 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.18 seconds
cpu time 0.09 seconds
478 + PROC SORT; BY PROPNBR TRXNBR TASK;
479 +
NOTE: There were 72959 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.PISHR has 72959 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
480 +DATA SPS4;
481 + MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
482 +
NOTE: There were 17727 observations read from the data set WORK.SPS2.
NOTE: There were 72959 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.SPS4 has 31069 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
483 +PROC SORT; BY PROPNBR EFFMY RELDATE;
484 +
The SAS System
NOTE: There were 31069 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31069 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
485 + PROC SORT; BY PROPNBR TRXNBR;
486 +
NOTE: There were 31069 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31069 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
487 +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
488 + SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
489 + SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
490 + SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
491 + SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
492 + SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
493 + SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
494 + SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
495 + SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
496 + SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
497 + SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
498 + SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
499 + SET SPS4;
500 + ENDYRX = &ENDYR;
SYMBOLGEN: Macro variable ENDYR resolves to 17
501 + BEGYRX = &BEGYR;
SYMBOLGEN: Macro variable BEGYR resolves to 16
502 + END = INPUT(PUT(ENDYRX,Z2.),$2.);
503 + BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
504 + IF (YY=&BEGYR AND MO <= 07) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
The SAS System
SYMBOLGEN: Macro variable BEGYR resolves to 16
505 + ACTDTE = BEG||'07';
506 + OUTPUT SPSFM1;
507 + END;
508 + IF (YY=&BEGYR AND MO <= 08) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable BEGYR resolves to 16
509 + ACTDTE = BEG||'08';
510 + OUTPUT SPSFM2;
511 + END;
512 + IF (YY=&BEGYR AND MO <= 09) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable BEGYR resolves to 16
513 + ACTDTE = BEG||'09';
514 + OUTPUT SPSFM3;
515 + END;
516 + IF (YY=&BEGYR AND MO <= 10) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable BEGYR resolves to 16
517 + ACTDTE = BEG||'10';
518 + OUTPUT SPSFM4;
519 + END;
520 + IF (YY=&BEGYR AND MO <= 11) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable BEGYR resolves to 16
521 + ACTDTE = BEG||'11';
522 + OUTPUT SPSFM5;
523 + END;
524 + IF (YY=&BEGYR AND MO <= 12) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable BEGYR resolves to 16
525 + ACTDTE = BEG||'12';
526 + OUTPUT SPSFM6;
527 + END;
528 + IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 1) THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable ENDYR resolves to 17
529 + ACTDTE = END||'01';
The SAS System
530 + OUTPUT SPSFM7;
531 + END;
532 + IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 2) THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable ENDYR resolves to 17
533 + ACTDTE = END||'02';
534 + OUTPUT SPSFM8;
535 + END;
536 + IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 3) THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable ENDYR resolves to 17
537 + ACTDTE = END||'03';
538 + OUTPUT SPSFM9;
539 + END;
540 + IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=4) THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable ENDYR resolves to 17
541 + ACTDTE = END||'04';
542 + OUTPUT SPSFM10;
543 + END;
544 + IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=5) THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable ENDYR resolves to 17
545 + ACTDTE = END||'05';
546 + OUTPUT SPSFM11;
547 + END;
548 + IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=6) THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable ENDYR resolves to 17
549 + ACTDTE = END||'06';
550 + OUTPUT SPSFM12;
551 + END;
552 +
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
504:10 504:24 504:37 508:10 508:24 508:37 512:10 512:24 512:37 516:10 516:24 516:37 520:10 520:24 520:37
524:10 524:24 524:37 528:9 528:26 528:40 532:9 532:26 532:40 536:9 536:26 536:40 540:9 540:26 540:40
544:9 544:26 544:40 548:9 548:26 548:40
The SAS System
NOTE: There were 31069 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPSFM1 has 29137 observations and 12 variables.
NOTE: The data set WORK.SPSFM2 has 29293 observations and 12 variables.
NOTE: The data set WORK.SPSFM3 has 29549 observations and 12 variables.
NOTE: The data set WORK.SPSFM4 has 29700 observations and 12 variables.
NOTE: The data set WORK.SPSFM5 has 29806 observations and 12 variables.
NOTE: The data set WORK.SPSFM6 has 29889 observations and 12 variables.
NOTE: The data set WORK.SPSFM7 has 29995 observations and 12 variables.
NOTE: The data set WORK.SPSFM8 has 30231 observations and 12 variables.
NOTE: The data set WORK.SPSFM9 has 30385 observations and 12 variables.
NOTE: The data set WORK.SPSFM10 has 30493 observations and 12 variables.
NOTE: The data set WORK.SPSFM11 has 30655 observations and 12 variables.
NOTE: The data set WORK.SPSFM12 has 31038 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.10 seconds
cpu time 0.10 seconds
553 +DATA SPS6;
554 + SET SPSFM1
555 + SPSFM2
556 + SPSFM3
557 + SPSFM4
558 + SPSFM5
559 + SPSFM6
560 + SPSFM7
561 + SPSFM8
562 + SPSFM9
563 + SPSFM10
564 + SPSFM11
565 + SPSFM12;
NOTE: There were 29137 observations read from the data set WORK.SPSFM1.
NOTE: There were 29293 observations read from the data set WORK.SPSFM2.
NOTE: There were 29549 observations read from the data set WORK.SPSFM3.
NOTE: There were 29700 observations read from the data set WORK.SPSFM4.
NOTE: There were 29806 observations read from the data set WORK.SPSFM5.
NOTE: There were 29889 observations read from the data set WORK.SPSFM6.
The SAS System
NOTE: There were 29995 observations read from the data set WORK.SPSFM7.
NOTE: There were 30231 observations read from the data set WORK.SPSFM8.
NOTE: There were 30385 observations read from the data set WORK.SPSFM9.
NOTE: There were 30493 observations read from the data set WORK.SPSFM10.
NOTE: There were 30655 observations read from the data set WORK.SPSFM11.
NOTE: There were 31038 observations read from the data set WORK.SPSFM12.
NOTE: The data set WORK.SPS6 has 360171 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds
566 + PROC SORT; BY PROPNBR ACTDTE TRXNBR EFFMY;
567 +
568 +
NOTE: There were 360171 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS6 has 360171 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.10 seconds
cpu time 0.25 seconds
569 +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
570 + SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
571 + IF LAST.ACTDTE THEN OUTPUT SPS7X;
572 +
NOTE: There were 360171 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7X has 88505 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
573 +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
574 +
The SAS System
NOTE: There were 88505 observations read from the data set WORK.SPS7X.
NOTE: The data set WORK.SPS7X has 88505 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
575 +DATA SPS7;
576 + MERGE SPS7X(IN=A) SPS6(IN=B);
577 + BY PROPNBR ACTDTE TRXNBR;
578 + IF A AND B;
579 +
NOTE: There were 88505 observations read from the data set WORK.SPS7X.
NOTE: There were 360171 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7 has 129366 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.12 seconds
580 +PROC SORT DATA = SPS7; BY LSUID;
581 +
NOTE: There were 129366 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS7 has 129366 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
582 +PROC SQL;
583 + CREATE TABLE DIRFILE AS
584 + SELECT INDIV_NAME AS PI
585 + ,LSU_ID AS LSUID
586 + FROM DIR.NAME;
NOTE: Table WORK.DIRFILE created, with 1159731 rows and 2 columns.
The SAS System
587 +
NOTE: PROCEDURE SQL used (Total process time):
real time 2.04 seconds
cpu time 0.93 seconds
588 +PROC SORT; BY LSUID;
589 +
NOTE: There were 1159731 observations read from the data set WORK.DIRFILE.
NOTE: The data set WORK.DIRFILE has 1159731 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.25 seconds
cpu time 0.53 seconds
590 +DATA SPS8(KEEP=PI LSUID DEPT PROPNBR ACTDTE SHARE TASK INVTYPE);
591 + MERGE DIRFILE(IN=A) SPS7(IN=B);
592 + BY LSUID;
593 + IF B;
594 +
595 +/*PROC SQL;
596 +CREATE TABLE CODES AS
597 +SELECT CODE_TYPE AS CDTYPE
598 + ,CODE_VALUE AS CODE
599 + ,CODE_DESC AS CODENAME
600 +FROM COA.CODES
601 +WHERE CODE_TYPE = 'DA';
602 +
603 +PROC SORT DATA = CODES;
604 + BY CODE;
605 +
606 +DATA NAMES(KEEP=DPT DPTNAME) COLNAME(KEEP=COLLEGE COLNAME);
607 + SET CODES;
608 +FORMAT COLLEGE DPT $5.;
609 +FORMAT COLNAME DPTNAME $35.;
610 + IF SUBSTR(CODE,4,2) = ' ' THEN DO;
611 + COLLEGE = CODE;
The SAS System
612 + COLNAME = CODENAME;
613 + OUTPUT COLNAME;
614 + END;
615 + ELSE DO;
616 + DPT = CODE;
617 + DPTNAME = CODENAME;
618 + OUTPUT NAMES;
619 + END;
620 +
621 +PROC SORT DATA = NAMES;
622 + BY DPT;
623 +
624 +PROC SORT DATA = SPS8;
625 + BY DPT;
626 +
627 +DATA SPS9;
628 + MERGE NAMES(IN=A) SPS8(IN=B);
629 + BY DPT;
630 + IF B;
631 + FORMAT DPTNAME $35.;
632 + FORMAT COL $3.;
633 + COL = SUBSTR(DPT,1,3);
634 + COL1 = COL||' ';
635 + FORMAT COLLEGE $5.;
636 + COLLEGE = COMPRESS(COL1);
637 +
638 +PROC SORT DATA = SPS9;
639 + BY COLLEGE;
640 +
641 +PROC SORT DATA = COLNAME;
642 + BY COLLEGE;
643 +
644 +DATA SPS10A;
645 + MERGE COLNAME(IN=A) SPS9(IN=B);
646 + BY COLLEGE;
647 + IF B;
648 +
649 +*DATA TEST; *SET SPS10A; *IF SUBSTR(COLLEGE,1,1) IN('3','9');
The SAS System
650 +
651 +DATA SPS10; SET SPS10A;
652 + IF SUBSTR(COLLEGE,1,1) = '3' THEN DO;
653 + COLLEGE = '300';
654 + COLNAME = 'PBRC';
655 + END;
656 + IF SUBSTR(COLLEGE,1,1) = '9' THEN DO;
657 + COLLEGE = '900';
658 + COLNAME = 'AG CENTER';
659 + END;*/
660 +
NOTE: There were 1159731 observations read from the data set WORK.DIRFILE.
NOTE: There were 129366 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS8 has 129366 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0.26 seconds
cpu time 0.26 seconds
661 + proc sql;
662 + create table ccdept as
663 + select code_value1 as dept,
664 + code_value2 as CC
665 + from spm.codes
666 +where code_type = 'CCDEPT';
NOTE: Table WORK.CCDEPT created, with 2587 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
667 +proc sort; by dept;
668 +
NOTE: There were 2587 observations read from the data set WORK.CCDEPT.
NOTE: The data set WORK.CCDEPT has 2587 observations and 2 variables.
The SAS System
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
669 +PROC SORT DATA = SPS8;
670 + BY dept;
671 +
NOTE: There were 129366 observations read from the data set WORK.SPS8.
NOTE: The data set WORK.SPS8 has 129366 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
672 +data mrgcc; merge sps8(in=a) ccdept(in=b); by dept; if a;
WARNING: Multiple lengths were specified for the BY variable DEPT by input data sets. This may cause unexpected results.
NOTE: There were 129366 observations read from the data set WORK.SPS8.
NOTE: There were 2587 observations read from the data set WORK.CCDEPT.
NOTE: The data set WORK.MRGCC has 129366 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
673 +proc sort; by cc;
674 +
NOTE: There were 129366 observations read from the data set WORK.MRGCC.
NOTE: The data set WORK.MRGCC has 129366 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
675 +proc sql;
The SAS System
676 +create table org as
677 +select org_id as CC,
678 +org_name as Cost_Center,
679 +superior_org as CC_Hier
680 +from wdm.organization
681 +where org_type = 'Cost_Center';
NOTE: Table WORK.ORG created, with 1056 rows and 3 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.01 seconds
682 +proc sort; BY CC;
683 +
NOTE: There were 1056 observations read from the data set WORK.ORG.
NOTE: The data set WORK.ORG has 1056 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
684 +data mrgcc2; merge mrgcc(in=a) org(in=b); by cc; if a;
WARNING: Multiple lengths were specified for the BY variable CC by input data sets. This may cause unexpected results.
NOTE: There were 129366 observations read from the data set WORK.MRGCC.
NOTE: There were 1056 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 129366 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.15 seconds
cpu time 0.15 seconds
685 +proc sort; BY CC_Hier;
686 +
NOTE: There were 129366 observations read from the data set WORK.MRGCC2.
The SAS System
NOTE: The data set WORK.MRGCC2 has 129366 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.32 seconds
cpu time 0.32 seconds
687 +proc sql;
688 +create table org as
689 +select org_id as CC_Hier,
690 +org_name as Cost_Center_Hierarchy
691 +from wdm.organization
692 +where org_type = 'Cost_Center_Hierarchy';
NOTE: Table WORK.ORG created, with 148 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.03 seconds
693 +proc sort; BY CC_Hier;
694 +
NOTE: There were 148 observations read from the data set WORK.ORG.
NOTE: The data set WORK.ORG has 148 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
695 +data mrgcc2; merge mrgcc2(in=a) org(in=b); by CC_Hier; if a;
696 +Cost_Center_Hierarchy = scan(Cost_Center_Hierarchy,-1,'|');
NOTE: There were 129366 observations read from the data set WORK.MRGCC2.
NOTE: There were 148 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 129366 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.37 seconds
cpu time 0.37 seconds
The SAS System
697 +proc sort; BY PROPNBR ACTDTE TASK;
698 +
699 +
700 +/*PROC SORT DATA = SPS10;
701 + BY PROPNBR ACTDTE TASK;*/
702 +
NOTE: There were 129366 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 129366 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.43 seconds
cpu time 0.43 seconds
703 +PROC SORT DATA = GLSCOA16;
704 + BY PROPNBR ACTDTE TASK;
705 +
NOTE: There were 139 observations read from the data set WORK.GLSCOA16.
NOTE: The data set WORK.GLSCOA16 has 139 observations and 35 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
706 +PROC SQL;
707 + CREATE TABLE GLSSPS1 AS
708 + SELECT A.*,
709 + B.PI,
710 + B.LSUID,
711 + B.INVTYPE,
712 + B.SHARE,
713 + B.Cost_Center_Hierarchy,
714 + B.CC,
715 + B.Cost_Center
716 +FROM GLSCOA16 A,
The SAS System
717 + mrgcc2 B
718 +WHERE A.PROPNBR = B.PROPNBR AND
719 + A.ACTDTE = B.ACTDTE AND
720 + A.TASK = B.TASK;
NOTE: Table WORK.GLSSPS1 created, with 208 rows and 42 columns.
721 +
722 +
NOTE: PROCEDURE SQL used (Total process time):
real time 0.10 seconds
cpu time 0.10 seconds
723 +DATA GLSSPS10(KEEP=PROPNBR ACTDTE); SET GLSSPS1; BY PROPNBR ACTDTE;
724 + IF FIRST.ACTDTE THEN OUTPUT;
NOTE: There were 208 observations read from the data set WORK.GLSSPS1.
NOTE: The data set WORK.GLSSPS10 has 118 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
725 + proc sort; by propnbr actdte;
726 +
NOTE: There were 118 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 118 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
727 + proc sort data=glscoa16; by propnbr actdte;
NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
The SAS System
cpu time 0.00 seconds
728 +DATA GLSCOA10;
729 + MERGE GLSCOA16(IN=A) GLSSPS10(IN=B);
730 + BY PROPNBR ACTDTE;
731 + IF A AND NOT B;
732 +
NOTE: There were 139 observations read from the data set WORK.GLSCOA16.
NOTE: There were 118 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSCOA10 has 0 observations and 35 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
733 +DATA GLSSPS;
734 + SET GLSSPS1 GLSCOA10;
735 +
736 +IF SHARE = '.' THEN DO; CLSUIDTOT = CACCTAMT; NLSUIDTOT = NACCTAMT;
737 + CLSUIDMON = CTOTMON ; NLSUIDMON = NTOTMON ;
738 +END;
739 + ELSE DO; CLSUIDTOT = CACCTAMT * SHARE / 100;
740 + NLSUIDTOT = NACCTAMT * SHARE / 100;
741 + CLSUIDMON = CTOTMON * SHARE / 100;
742 + NLSUIDMON = NTOTMON * SHARE / 100;
743 +END;
744 +
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
736:12
NOTE: There were 208 observations read from the data set WORK.GLSSPS1.
NOTE: There were 0 observations read from the data set WORK.GLSCOA10.
NOTE: The data set WORK.GLSSPS has 208 observations and 46 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
The SAS System
745 +PROC SORT DATA = GLSSPS; BY Cost_Center_Hierarchy;
746 +
NOTE: There were 208 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 208 observations and 46 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
747 +DATA GLSSPS10; SET GLSSPS; BY Cost_Center_Hierarchy;
748 + IF FIRST.Cost_Center_Hierarchy THEN DO;
749 + NCOLYTD = NLSUIDTOT;
750 + NCOLMON = NLSUIDMON;
751 + CCOLYTD = CLSUIDTOT;
752 + CCOLMON = CLSUIDMON;
753 + END;
754 + ELSE DO;
755 + NCOLYTD + NLSUIDTOT;
756 + NCOLMON + NLSUIDMON;
757 + CCOLYTD + CLSUIDTOT;
758 + CCOLMON + CLSUIDMON;
759 + END;
760 + IF LAST.Cost_Center_Hierarchy THEN DO;
761 + NCOLYTD = ROUND(NCOLYTD,1.);
762 + NCOLMON = ROUND(NCOLMON,1.);
763 + CCOLYTD = ROUND(CCOLYTD,1.);
764 + CCOLMON = ROUND(CCOLMON,1.);
765 + OUTPUT;
766 + END;
NOTE: There were 208 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS10 has 20 observations and 50 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
The SAS System
767 + proc sort; by Cost_Center_Hierarchy;
768 +
NOTE: There were 20 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 20 observations and 50 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
769 +DATA BAD; SET GLSSPS10;
770 + IF Cost_Center_Hierarchy = ' ' THEN OUTPUT;
NOTE: There were 20 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.BAD has 0 observations and 50 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
771 +proc sort; by grant_id;
772 +/*PROC PRINT;
773 +TITLE1 'COULD NOT MERGE WITH SPM';
774 +TITLE2 ' ';
775 +VAR GRANT_ID FUND AWARD_NUMBER TASK_NUMBER GRANT_EXP_DATE SPONSOR_ID SPONSOR_NAME propnbr LSU_PIID;*/
776 +
777 +
778 +
779 +%global _ODSDEST;
780 +%global _ODSSTYLE;
781 +
782 +%MACRO PRINT;
783 +OPTIONS ORIENTATION=LANDSCAPE;
784 +
785 +%IF (%UPCASE("&_ODSDEST") eq "PHTML")+ (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
786 +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
The SAS System
787 +data _null_ ;
788 + rc = stpsrv_header('Content-type','text/html');
789 +run ;
790 +ods listing close;
791 +ods html body=_webout style=default;
792 +%END;
793 +
794 +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
795 +data _null_ ;
796 + rc = stpsrv_header('Content-type','application/pdf') ;
797 + rc = stpsrv_header('Content-disposition',"attachment; filename=&TME..pdf");
798 +run ;
799 +ods listing close;
800 +ods pdf file=_webout style=FSS;
801 +%END;
802 +
803 +PROC TABULATE DATA = GLSSPS10 FORMAT=COMMA16.;
804 +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
805 +TITLE2 " BY Cost Center Hierarchy ";
806 +TITLE3 " PROCESSED IN &MON &EFFYR ";
807 + CLASS Cost_Center_Hierarchy;
808 + VAR NCOLMON CCOLMON NCOLYTD CCOLYTD;
809 + TABLE Cost_Center_Hierarchy=' ' ALL='TOTAL',
810 + (NCOLMON="&HEADER &EFFYR NEW"
811 + CCOLMON="&HEADER &EFFYR CONT"
812 + NCOLYTD ="FY &FISCAL YTD NEW"
813 + CCOLYTD="FY &FISCAL YTD CONT")
814 + * SUM=' ' /
815 + BOX='COST CENTER HIERARCHY';
816 +RUN;
817 +/*PROC TABULATE DATA = GLSSPS10 FORMAT=COMMA16.;
818 +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
819 +TITLE2 " BY COLLEGE ";
820 +TITLE3 " PROCESSED IN &MON &EFFYR ";
821 + CLASS COLNAME;
822 + VAR NCOLMON CCOLMON NCOLYTD CCOLYTD;
823 + TABLE COLNAME=' ' ALL='TOTAL',
824 + (NCOLMON="&HEADER &EFFYR NEW"
The SAS System
825 + CCOLMON="&HEADER &EFFYR CONT"
826 + NCOLYTD ="FY &FISCAL YTD NEW"
827 + CCOLYTD="FY &FISCAL YTD CONT")
828 + * SUM=' ' /
829 + BOX='COLLEGES';
830 +RUN;*/
831 +
832 +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
833 +ods html close;
834 +%END;
835 +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
836 +ods pdf close;
837 +%END;
838 +
839 +%END;
840 +%MEND PRINT;
841 +%PRINT;
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
NOTE: Input data set is empty.
NOTE: The data set WORK.BAD has 0 observations and 50 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable TME resolves to 62154.373
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
WARNING: Style FSS not found; Printer style will be used instead.
NOTE: Writing ODS PDF output to DISK destination "_WEBOUT", printer "PDF".
The SAS System
SYMBOLGEN: Macro variable MON resolves to NOVEMBER
SYMBOLGEN: Macro variable EFFYR resolves to 2016
SYMBOLGEN: Macro variable HEADER resolves to NOVEMBER
SYMBOLGEN: Macro variable EFFYR resolves to 2016
SYMBOLGEN: Macro variable HEADER resolves to NOVEMBER
SYMBOLGEN: Macro variable EFFYR resolves to 2016
SYMBOLGEN: Macro variable FISCAL resolves to 2017
SYMBOLGEN: Macro variable FISCAL resolves to 2017
NOTE: There were 20 observations read from the data set WORK.GLSSPS10.
NOTE: PROCEDURE TABULATE used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
NOTE: ODS PDF printed 1 page to 223E56C8-535D-42A4-BB13-DDA34CBDD3EE.
842 +
843 +* Begin EG generated code (do not edit this line);
844 +;*';*";*/;quit;
845 +
846 +* End EG generated code (do not edit this line);
847 +
NOTE: %INCLUDE (level 1) ending.