SAS Log
1 The SAS System 10:57 Tuesday, September 12, 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.01 seconds
cpu time 0.01 seconds
NOTE: The autoexec file, D:\SAS\EnterpriseSAS\Lev1\SASApp\StoredProcessServer\autoexec.sas, was executed at server initialization.
>>> SAS Macro Variables:
EFFDTE=20170531
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-1494; JSESSIONID=AD244CC77D1AB111ED9538082AFD4FF7; sso-logout-time="Tue Sep 12 2017 16:52:18 GMT-0500 (Central Daylight
Time)"; LtpaToken=AAECAzU5QjdFNjU3NTlCODU3MTJrdHdlZWRAbHN1LmVkdQc9V4yG69hGpH1NyNhpfy7pGkA4
_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/SPONCOL2
_REPLAY="&_URL?_sessionid=3240E4A9-1462-477A-8BA8-3B24553CE344&_program=replay&_entry=&_TMPCAT.."
_REQMETH=POST
_RESULT=STREAM
_RMTADDR=130.39.74.10
_RMTHOST=130.39.74.10
_SECUREUSERNAME=FSSGuest
_SRVNAME=sasdreporting.lsu.edu
_SRVPORT=8443
_TMPCAT=APSWORK.TCAT000D
_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\SPONCOL2.sas is file D:\SAS Stored Processes\FSS\SPONCOL2.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: SPONCOL2
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 + %GetĢtvUser
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-1494;
JSESSIONID=AD244CC77D1AB111ED9538082AFD4FF7; sso-logout-time="Tue Sep 12 2017 16:52:18 GMT-0500 (Central Daylight Time)";
LtpaToken=AAECAzU5QjdFNjU3NTlCODU3MTJrdHdlZWRAbHN1LmVkdQc9V4yG69hGpH1NyNhpfy7pGkA4
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.01 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable VALUE resolves to AAECAzU5QjdFNjU3NTlCODU3MTJrdHdlZWRAbHN1LmVkdQc9V4yG69hGpH1NyNhpfy7pGkA4
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).
45:118 45:240
NOTE: The infile Ģtv is:
Filename=http://cgi.lsu.edu:8080/eis/servlet/getuser?LtpaToken=AAECAzU5QjdFNjU3NTlCODU3MTJrdHdlZWRAbHN1LmVkdQc9V4yG69hGpH1NyNhpfy7pGkA4,
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 Ģtv.
The minimum record length was 33.
The maximum record length was 33.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
The SAS System
cpu time 0.00 seconds
**END*USEREND*USER**
SYMBOLGEN: Macro variable _ĢtvPERSON resolves to Keri M Tweed
SYMBOLGEN: Macro variable _ĢtvUSER resolves to ktweed
**** This stored process was requested by Keri M Tweed with ĢtvUSERID: ktweed
**END*USEREND*USER**
SYMBOLGEN: Macro variable _INFILE resolves to 0
SYMBOLGEN: Macro variable _INUSER resolves to 1
46 +
47 + *** ENTER EFFECTIVE DATE ***;
48 +*%LET EFFDTE = 20170228;
49 +
50 +DATA DATE;
51 + EFFDTE = "&EFFDTE";
SYMBOLGEN: Macro variable EFFDTE resolves to 20170531
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(X" || COMPRESS(PDATE) || ")'";
62 + CALL SYMPUT('PFILE',PFILE);
63 + HFILE = "'ACGR14.PROD.HTML(X" || 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 +
97 +
98 +/*LIBNAME COA DB2 AUTHID=COA SSID=DB2;
99 +LIBNAME SPM DB2 AUTHID=SPM SSID=DB2;
100 +LIBNAME DIR DB2 AUTHID=DIR SSID=DB2;
101 +
102 +
103 +PROC SQL;
104 + CREATE TABLE COAFILE AS
105 + SELECT P_I_Ģtv_ID AS PIID
106 + ,ACCT_CODE AS ACCT
The SAS System
107 + ,AGENCY_CD AS AGENCY
108 + ,GRANT_EXPIRE_DATE AS EXPIRE
109 + ,PROPOSAL_NBR AS PROPNBR
110 + ,GRANT_NAME AS STITLE
111 + ,TOTAL_AWARD_AMT AS TOTAWARD
112 + ,CO_P_I_Ģtv_ID AS COPIID
113 + ,INTERNAL_COMP_FLAG AS INTFLAG
114 + ,TASK_NBR AS TASK
115 +FROM COA.SPONSORED_PROGRAMS
116 +WHERE SUBSTR(ACCT_CODE,1,1) = '1'
117 +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6') AND PROPOSAL_NBR <> 0
118 +AND AGENCY_CD NOT IN ('A1','C','Z','XF') AND BILL_CYCLE_CD <> 'G'
119 +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
120 +'190067') AND FISCAL_YEAR = &FYEAR;
121 +
122 +PROC SORT; BY ACCT;*/
123 +
124 +
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
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 17 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
125 +PROC SQL;
126 +CREATE TABLE FUND1 AS
127 +SELECT ORG_ID AS GRANT_ID,
128 +FUND as SF
129 +FROM WDM.fin_fdm_DRIVERTAG
130 +WHERE FUND IN ('FD250','FD251','FD252');
NOTE: Table WORK.FUND1 created, with 5953 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
The SAS System
real time 0.03 seconds
cpu time 0.00 seconds
131 +PROC SORT; BY GRANT_ID;
132 +
NOTE: There were 5953 observations read from the data set WORK.FUND1.
NOTE: The data set WORK.FUND1 has 5953 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
133 +PROC SQL;
134 +CREATE TABLE GRANT1 AS
135 +SELECT GRANT_ID,
136 +AWARD_NUMBER as award_budg,
137 +TASK_NUMBER,
138 +TO_DATE AS GRANT_EXP_DATE,
139 +sponsor_id,
140 +cont_line_status,
141 +is_primary,
142 +workday_id
143 +FROM WDM.FIN_AWD_LINE
144 +WHERE COMPANY = '10' and cont_status NE ' ';
NOTE: Table WORK.GRANT1 created, with 3289 rows and 8 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.04 seconds
cpu time 0.01 seconds
145 +PROC SORT; BY GRANT_ID;
146 +
NOTE: There were 3289 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.GRANT1 has 3289 observations and 8 variables.
The SAS System
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
147 +DATA MRG1; MERGE FUND1(IN=A) GRANT1(IN=B); BY GRANT_ID; IF A AND B;
NOTE: There were 5953 observations read from the data set WORK.FUND1.
NOTE: There were 3289 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.MRG1 has 2913 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
148 +PROC SORT; BY sponsor_id;
149 +
NOTE: There were 2913 observations read from the data set WORK.MRG1.
NOTE: The data set WORK.MRG1 has 2913 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
150 +proc sql;
151 +create table SPON as
152 +select sponsor_id,
153 +SPONSOR_NAME,
154 +sponsor_type as AGENCY,
155 +parent_id as parent
156 +from wdm.fin_awd_sponsor;
NOTE: Table WORK.SPON created, with 1582 rows and 4 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
The SAS System
157 +proc sort; by sponsor_id;
158 +
NOTE: There were 1582 observations read from the data set WORK.SPON.
NOTE: The data set WORK.SPON has 1582 observations and 4 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
159 +data mrgspon; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
NOTE: There were 2913 observations read from the data set WORK.MRG1.
NOTE: There were 1582 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSPON has 2913 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
160 +PROC SORT; BY award_budg grant_id cont_line_status descending is_primary ;
161 +
NOTE: There were 2913 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.MRGSPON has 2913 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
162 +data setmrgspon1; set mrgspon; BY award_budg grant_id cont_line_status descending is_primary ;
163 +if first.grant_id then output;
NOTE: There were 2913 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.SETMRGSPON1 has 2909 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
The SAS System
cpu time 0.00 seconds
164 +proc sort; by sponsor_id;
165 +
NOTE: There were 2909 observations read from the data set WORK.SETMRGSPON1.
NOTE: The data set WORK.SETMRGSPON1 has 2909 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
166 +data setSPON; set setmrgspon1; by sponsor_id;
167 +if agency in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency'); *then do; *output statefed;
168 + if parent ne ' ' then sponsor_id = parent; else sponsor_id = sponsor_id;
169 + flag = 'Y';*output;
170 + *end;
NOTE: There were 2909 observations read from the data set WORK.SETMRGSPON1.
NOTE: The data set WORK.SETSPON has 1987 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
171 +proc sort; by sponsor_id;
172 +
NOTE: There were 1987 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.SETSPON has 1987 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
173 +data setSPON2; set setmrgspon1; by sponsor_id;
174 +if agency not in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency');
The SAS System
NOTE: There were 2909 observations read from the data set WORK.SETMRGSPON1.
NOTE: The data set WORK.SETSPON2 has 922 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
175 +proc sort; by sponsor_id;
176 +
177 +
178 +/*proc sql;
179 +create table SPONparent as
180 +select sponsor_id,
181 +SPONSOR_NAME as Parent_name,
182 +sponsor_type as AGENCY,
183 +parent_id
184 +from wdm.fin_awd_sponsor;
185 +proc sort; by sponsor_id;
186 +
187 +data mrgspon; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
188 +*if agency in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency') then do; *output statefed;
189 + if parent_id ne ' ' then do; sponsor_id = parent_id;
190 +*else sponsor_id = sponsor_id; end;
191 +else do;
192 +sponsor_id = sponsor_id;
193 +end;
194 +*else output mrgspon;
195 +proc sort; by AWARD_NUMBER;*/
196 +
NOTE: There were 922 observations read from the data set WORK.SETSPON2.
NOTE: The data set WORK.SETSPON2 has 922 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
The SAS System
197 +data setSTATEFED (drop=sponsor_name agency); set setspon;
198 +if parent ne ' ' then sponsor_id = parent; else sponsor_id = sponsor_id;
NOTE: There were 1987 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.SETSTATEFED has 1987 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
199 +proc sort; by sponsor_id;
200 +
201 +/*data set2; set setstatefed; by sponsor_id;
202 +if last.sponsor_id then output;
203 +proc sort; by sponsor_id;*/
204 +
205 +
206 +/*data setspon (keep=sponsor_id); set spon; by sponsor_id;
207 +if sponsor_type in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency') then do;
208 + if parent_id ne ' ' then sponsor_id = parent_id; else sponsor_id = sposnor_id;
209 +end;
210 +proc sort; by sponsor_id;*/
211 +
212 +/*data mrgspon statefed; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
213 +if agency in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency') then output statefed;
214 +else output mrgspon;
215 +proc sort; by AWARD_NUMBER;
216 +
217 +data setSTATEFED(keep=parent_id sponsor_id); set statefed;
218 +if parent_id ne ' ' then sponsor_id = parent_id; else sponsor_id = sponsor_id;
219 +proc sort; by sponsor_id;
220 +
221 +data set2; set setstatefed; by sponsor_id;
222 +if last.sponsor_id then output;
223 +proc sort; by sponsor_id;*/
224 +
NOTE: There were 1987 observations read from the data set WORK.SETSTATEFED.
The SAS System
NOTE: The data set WORK.SETSTATEFED has 1987 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
225 +data mrgstate; merge setSTATEFED(in=a) spon(in=b); by sponsor_id; if a;
NOTE: There were 1987 observations read from the data set WORK.SETSTATEFED.
NOTE: There were 1582 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSTATE has 1987 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
226 +proc sort; by sponsor_id;
227 +
NOTE: There were 1987 observations read from the data set WORK.MRGSTATE.
NOTE: The data set WORK.MRGSTATE has 1987 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
228 +data setspons; set mrgstate setspon2; by sponsor_id;
NOTE: There were 1987 observations read from the data set WORK.MRGSTATE.
NOTE: There were 922 observations read from the data set WORK.SETSPON2.
NOTE: The data set WORK.SETSPONS has 2909 observations and 13 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
229 +proc sort; by award_budg;
230 +
The SAS System
231 +/*data mrgspon1; merge mrg1(in=a) setspons(in=b); by sponsor_id; if a;
232 +proc sort; by award_number;*/
233 +
NOTE: There were 2909 observations read from the data set WORK.SETSPONS.
NOTE: The data set WORK.SETSPONS has 2909 observations and 13 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
234 +PROC SQL;
235 +CREATE TABLE AWARD1 AS
236 +SELECT AWARD_NUMBER as award_budg,
237 +PROPOSAL_ID as propnbr,
238 +AWARD_NAME,
239 +signed_date,
240 +TOTAL_AMOUNT AS AWD_TOTAL,
241 +award_date
242 +FROM WDM.FIN_AWD
243 +WHERE PROPOSAL_ID NE 0 and
244 +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 1832 rows and 6 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.03 seconds
cpu time 0.00 seconds
245 +PROC SORT; BY award_budg;
246 +
NOTE: There were 1832 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.AWARD1 has 1832 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The SAS System
247 +DATA MRG2; MERGE setspons(IN=A) AWARD1(IN=B); BY award_budg; IF A AND B;
248 +format TASK 2.;
249 +task = substr(task_number,3,2);
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
249:8
NOTE: There were 2909 observations read from the data set WORK.SETSPONS.
NOTE: There were 1832 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.MRG2 has 2601 observations and 19 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
250 +PROC SORT; BY award_budg;
251 +
252 +/*PROC SQL;
253 +CREATE TABLE LEADPI AS
254 +SELECT EMPLOYEE_ID AS WD_PIID,
255 +ORG_ID AS GRANT_ID,
256 +ROLE_NAME AS ROLE1
257 +FROM WDM.WORKER_ROLE
258 +WHERE role_name = 'Principal_Investigator';
259 +PROC SORT; BY WD_PIID;
260 +
261 +PROC SQL;
262 +CREATE TABLE ĢtvPIID AS
263 +SELECT EMPLOYEE_ID AS WD_PIID,
264 +Ģtv_ID AS Ģtv_PIID
265 +FROM WDM.KEYS;
266 +PROC SORT; BY WD_PIID;
267 +
268 +DATA MRGPI;
269 +MERGE LEADPI(IN=A) ĢtvPIID(IN=B); BY WD_PIID; IF A;
270 +PROC SORT; BY GRANT_ID;
271 +
272 +DATA MRG3; MERGE MRG2(IN=A) MRGPI(IN=B); BY GRANT_ID; IF A;
The SAS System
273 +PROC SORT; BY GRANT_ID;
274 +
275 +PROC SQL;
276 +CREATE TABLE COPI AS
277 +SELECT EMPLOYEE_ID AS WD_COPIID,
278 +ORG_ID AS GRANT_ID,
279 +ROLE_NAME AS ROLE2
280 +FROM WDM.WORKER_ROLE
281 +WHERE role_name = 'Co-Principal_Investigator';
282 +PROC SORT; BY WD_COPIID;
283 +
284 +PROC SQL;
285 +CREATE TABLE ĢtvCOPIID AS
286 +SELECT EMPLOYEE_ID AS WD_COPIID,
287 +Ģtv_ID AS Ģtv_COPIID
288 +FROM WDM.KEYS;
289 +PROC SORT; BY WD_COPIID;
290 +
291 +DATA MRGCOPI;
292 +MERGE COPI(IN=A) ĢtvCOPIID(IN=B); BY WD_COPIID; IF A;
293 +PROC SORT; BY GRANT_ID;
294 +
295 +DATA MRG4; MERGE MRG3(IN=A) MRGCOPI(IN=B); BY GRANT_ID; IF A;
296 +PROC SORT; BY AWARD_NUMBER;*/
297 +
NOTE: There were 2601 observations read from the data set WORK.MRG2.
NOTE: The data set WORK.MRG2 has 2601 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
298 +proc sql;
299 +CREATE TABLE SPEC AS
300 +SELECT AWARD_NUMBER as award_budg,
301 +REF_ID
302 +FROM WDM.FIN_AWD_SPEC_COND
The SAS System
303 +WHERE REF_ID = 'Special_Condition_Type_Internal_Competition';
NOTE: Table WORK.SPEC created, with 38 rows and 2 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
304 +PROC SORT; BY award_budg;
305 +
NOTE: There were 38 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.SPEC has 38 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
306 +DATA MRG5; MERGE MRG2(IN=A) SPEC(IN=B); BY award_budg; IF A;
NOTE: There were 2601 observations read from the data set WORK.MRG2.
NOTE: There were 38 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.MRG5 has 2601 observations and 20 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
307 +PROC SORT; BY award_budg grant_id;
308 +
NOTE: There were 2601 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.MRG5 has 2601 observations and 20 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The SAS System
309 +data setmrg5; set mrg5; by award_budg grant_id;
310 +if first.grant_id then output;
NOTE: There were 2601 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.SETMRG5 has 2601 observations and 20 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
311 +proc sort; by award_budg grant_id;
312 +
313 +
314 +/*PROC SQL;
315 + CREATE TABLE SPAFILE AS
316 + SELECT ACCT_CODE AS ACCT
317 + ,BEGIN_DATE AS BEGIN
318 + ,INIT_TIMESTAMP AS IADD
319 + ,LONG_TITLE AS LONG
320 +FROM COA.ACCOUNTS
321 +WHERE CAMPUS_CD = '1' AND ACCT_TYPE = 'S'
322 +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6')
323 +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
324 +'190067') AND FISCAL_YEAR = &FYEAR;
325 +
326 +PROC SORT; BY ACCT;
327 +
328 +DATA COAS;
329 + MERGE COAFILE(IN=A) SPAFILE(IN=B);
330 + BY ACCT;
331 + IF A AND B;
332 +
333 +PROC SORT DATA = COAS; BY ACCT;
334 +
335 +DATA COA1(KEEP=STITLE LONG ACCT AGENCY EXPIRE BEGIN ADDTE TOTAWARD
336 + PIID COPIID PROPNBR INTFLAG TASK);
337 + SET COAS;
338 + FORMAT STITLE $60.;
The SAS System
339 + FORMAT ADATE YYMMDDN8.;
340 + ADATE = DATEPART(IADD);
341 + FORMAT BEGIN YYMMDDN8.;
342 + FORMAT EXPIRE YYMMDDN8.;
343 + FORMAT BEGINX $8.;
344 + BEGINX = INPUT(PUT(BEGIN,8.),$8.);
345 + FORMAT DPT $5.;
346 + DPT = SUBSTR(ACCT,1,5);
347 + AYR = YEAR(ADATE);
348 + AMTH= MONTH(ADATE);
349 + MONA = INPUT(PUT(AMTH,Z2.),$2.);
350 + YEARA = INPUT(PUT(AYR,4.),$4.);
351 + ADDTE = YEARA||MONA;
352 +BEGINZ = INPUT(PUT(BEGIN,Z8.),8.);
353 + IF BEGINZ <= &EFFDTE;*/
354 +
NOTE: There were 2601 observations read from the data set WORK.SETMRG5.
NOTE: The data set WORK.SETMRG5 has 2601 observations and 20 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
355 +PROC SQL;
356 +CREATE TABLE BUDG AS
357 +SELECT grant_id,
358 +grant_name,
359 +ledger_account,
360 +budget_revenue as AMT,
361 +budget_obj,
362 +award_name,
363 +award_report_code as BAADJCD,
364 +budget_amendment_date,
365 +budget_date_from
366 +from workday.award_budget
367 +where ledger_account in ('4200:Federal Grants and Contracts Revenue','4210:State and Local Grants and Contracts Revenue',
368 +'4220:Non-governmental Grants and Contracts Revenue','4230:Grants and Contracts Revenue') and budget_amendment_status not in
The SAS System
368 !+('Canceled','Draft','Denied')
369 +and company_code = 'ĢtvAM' and
370 +award_report_code in ('New','Continuation') ;
NOTE: Table WORK.BUDG created, with 1181 rows and 9 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds
371 +proc sort; by grant_id;
372 +
NOTE: There were 1181 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.BUDG has 1181 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
373 +data set1; set budg; by grant_id;
374 +format BUDGET_DATE1 yymmddn.;
375 +budget_date1 = budget_amendment_date;
376 +award_budg = scan(budget_obj,1,":");
NOTE: There were 1181 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.SET1 has 1181 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
377 +proc sort; by award_budg grant_id;
378 +
NOTE: There were 1181 observations read from the data set WORK.SET1.
NOTE: The data set WORK.SET1 has 1181 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
The SAS System
real time 0.01 seconds
cpu time 0.01 seconds
379 +data MARGE; merge mrg5(in=a) set1(in=b); by award_budg grant_id; if a and b;
380 +format budget_date yymmddn.;
381 +if budget_date1 = ' ' then budget_date = signed_date; else budget_date = budget_date1;
382 +if budget_date = ' ' then delete;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
381:19 382:18
WARNING: Multiple lengths were specified for the BY variable award_budg by input data sets. This may cause unexpected results.
NOTE: There were 2601 observations read from the data set WORK.MRG5.
NOTE: There were 1181 observations read from the data set WORK.SET1.
NOTE: The data set WORK.MARGE has 1175 observations and 29 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
383 +proc sort; by grant_id budget_date;
384 +
NOTE: There were 1175 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE has 1175 observations and 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
385 +data marge1; set marge; by grant_id budget_date;
386 +effdte = INPUT(PUT(budget_date,yymmddn.),8.);
387 +agency = substr(agency,14,25);
388 +*if effdte <= 20160930 then output;
NOTE: There were 1175 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE1 has 1175 observations and 30 variables.
NOTE: DATA statement used (Total process time):
The SAS System
real time 0.01 seconds
cpu time 0.01 seconds
389 +proc sort; by grant_id;
390 +
391 +
392 +
393 +
394 +/*DATA GLSD;
395 + INFILE GLSD;
396 + INPUT @1 FY $2.
397 + @3 ENTRY PD5.
398 + @10 ACCT $9.
399 + @19 TT $1.
400 + @20 OBJ $4.
401 + @24 SUBOBJ $1.
402 + @29 AMT PD6.2
403 + @168 BAADJCD $1.;
404 + IF TT = 'I' AND SUBSTR(ACCT,1,1) = '1' AND
405 + SUBSTR(ACCT,6,1) IN ('4','5','6') AND FY = &FYR
406 + AND BAADJCD IN ('N','C');
407 + IF AMT = 0 THEN DELETE;
408 + SOURCE = SUBSTR(ACCT,6,1);
409 +
410 +PROC SORT; BY SOURCE;
411 +
412 +DATA GLST; SET GLSD; BY SOURCE;
413 +FORMAT SF $7.;
414 +IF SOURCE = '3' THEN SF = 'FED AP ';
415 +IF SOURCE = '4' THEN SF = 'STATE';
416 +IF SOURCE = '5' THEN SF = 'FEDERAL';
417 +IF SOURCE = '6' THEN SF = 'PRIVATE';
418 +CALL SYMPUT('SF',SF);
419 +
420 +PROC SORT DATA=GLST; BY FY ENTRY;
421 +
422 +DATA GĢtvSRS;
The SAS System
423 + INFILE GĢtvSR;
424 + INPUT @ 1 FY $2.
425 + @ 3 ENTRY PD5.
426 + @ 8 ENTRYTYP $2.
427 + @ 57 VCHRTYPE $2.
428 + @ 64 EFFDTE PD5.
429 + @ 69 STATUS $1.;
430 + IF STATUS = 'C';
431 + IF FY = &FYR ;
432 + IF ENTRYTYP = 'GE';
433 +
434 +PROC SORT DATA=GĢtvSRS; BY FY ENTRY;
435 +
436 +DATA GLS;
437 + MERGE GĢtvSRS(IN=A) GLST(IN=B);
438 + BY FY ENTRY;
439 + IF A AND B;
440 +
441 +PROC SORT; BY ACCT;
442 +
443 +DATA GLSCOA;
444 + MERGE COA1(IN=A) GLS(IN=B);
445 + BY ACCT;
446 + IF A AND B;
447 +
448 +PROC SORT DATA = GLSCOA; BY FY ACCT ENTRY;*/
449 +
NOTE: There were 1175 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.MARGE1 has 1175 observations and 30 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
450 +DATA budg1 (DROP= EMTH ENDYRX BEGYRX END BEG);
451 + SET marge1; by grant_id effdte;
452 + * BY FY ACCT ENTRY;
The SAS System
453 + EDATE = INPUT(PUT(EFFDTE,8.),YYMMDD8.);
454 + EMTH= MONTH(EDATE);
455 +
456 + IF EFFDTE <= &EFFDTE;
SYMBOLGEN: Macro variable EFFDTE resolves to 20170531
457 +
458 + EMNX = INPUT(PUT(EMTH,Z2.),$2.);
459 + ENDYRX = &ENDYR;
SYMBOLGEN: Macro variable ENDYR resolves to 17
460 + BEGYRX = &BEGYR;
SYMBOLGEN: Macro variable BEGYR resolves to 16
461 + END = INPUT(PUT(ENDYRX,Z2.),$2.);
462 + BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
463 + IF EMTH > 6 THEN ACTDTE = BEG||EMNX;
464 + ELSE ACTDTE = END||EMNX;
465 +
466 + IF EMNX = &EFFMN THEN MONAMT = AMT;
SYMBOLGEN: Macro variable EFFMN resolves to 05
467 + ELSE MONAMT = 0;
468 +
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
466:6
NOTE: There were 1175 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.BUDG1 has 745 observations and 34 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
469 +PROC SORT DATA = budg1; BY ACTDTE grant_id;
470 +
NOTE: There were 745 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.BUDG1 has 745 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
The SAS System
471 +DATA GLSCOA15(DROP=AMT MONAMT); SET budg1;
472 + BY ACTDTE grant_id;
473 + IF FIRST.grant_id THEN DO; *MTHAMT = MONAMT; *TOTAMT = AMT; *END;
474 + IF BAADJCD = 'New' THEN DO;
475 + NMTHAMT = MONAMT; CMTHAMT = 0;
476 + NTOTAMT = AMT; CTOTAMT = 0; END;
477 + IF BAADJCD = 'Continuation' THEN DO;
478 + CMTHAMT = MONAMT; NMTHAMT = 0;
479 + CTOTAMT = AMT; NTOTAMT = 0; END;
480 + END;
481 + ELSE DO;
482 + IF BAADJCD = 'New' THEN DO;
483 + NMTHAMT + MONAMT; CMTHAMT + 0;
484 + NTOTAMT + AMT; CTOTAMT + 0; END;
485 + IF BAADJCD = 'Continuation' THEN DO;
486 + CMTHAMT + MONAMT; NMTHAMT + 0;
487 + CTOTAMT + AMT; NTOTAMT + 0; END;
488 + END;
489 + *ELSE DO; *MTHAMT + MONAMT; *TOTAMT + AMT; *END;
490 + IF LAST.grant_id THEN OUTPUT;
491 +
NOTE: There were 745 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 711 observations and 36 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
492 +PROC SQL;
493 + CREATE TABLE PROJTRAN AS
494 +SELECT PROPOSAL_NBR AS PROPNBR
495 + ,TRX_NBR AS TRXNBR
496 + ,TRX_TYPE AS TRXTYPE
497 + ,TRX_STATUS AS TRXSTAT
498 + ,TO_SPA_DATE AS RELDATE
The SAS System
499 +FROM SPM.PROJ_TRANSACTION
500 + WHERE TRX_STATUS IN ('AC','TE','CO');
NOTE: Table WORK.PROJTRAN created, with 17941 rows and 5 columns.
501 +
NOTE: PROCEDURE SQL used (Total process time):
real time 0.06 seconds
cpu time 0.03 seconds
502 + PROC SORT; BY PROPNBR TRXNBR RELDATE;
503 +
NOTE: There were 17941 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.PROJTRAN has 17941 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
504 +DATA SPS2;
505 + SET PROJTRAN; BY PROPNBR TRXNBR;
506 + LENGTH MO YY $2.;
507 + LENGTH YR $4.;
508 + MO=MONTH(RELDATE);
509 + YR=YEAR(RELDATE);
510 + YY=SUBSTR(YR,3,2);
511 + LENGTH EFFMY $4.;
512 + EFFMY=YY||MO;
513 + IF SUBSTR(EFFMY,3,1)=' ' THEN SUBSTR(EFFMY,3,1)='0';
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
508:8 509: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 508:8 212 at 509:8
NOTE: There were 17941 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.SPS2 has 17941 observations and 9 variables.
The SAS System
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
514 + PROC SORT; BY PROPNBR EFFMY RELDATE;
515 +
NOTE: There were 17941 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17941 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
516 + PROC SORT; BY PROPNBR TRXNBR;
517 +
NOTE: There were 17941 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17941 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
518 +PROC SQL;
519 + CREATE TABLE PISHR AS
520 + SELECT PROPOSAL_NBR AS PROPNBR,
521 + TRX_NBR AS TRXNBR,
522 + TASK_NBR AS TASK,
523 + Ģtv_ID AS ĢtvID,
524 + INVESTIGATOR_TYPE AS INVTYPE,
525 + DEPT_CD AS DEPT,
526 + PROJECT_SHARE AS SHARE
527 + FROM SPM.PROJ_INVESTIGATOR
528 + WHERE PROJECT_SHARE > 0;
NOTE: Table WORK.PISHR created, with 73657 rows and 7 columns.
The SAS System
NOTE: PROCEDURE SQL used (Total process time):
real time 0.17 seconds
cpu time 0.11 seconds
529 + PROC SORT; BY PROPNBR TRXNBR TASK;
530 +
NOTE: There were 73657 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.PISHR has 73657 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
531 +DATA SPS4;
532 + MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
533 +
NOTE: There were 17941 observations read from the data set WORK.SPS2.
NOTE: There were 73657 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.SPS4 has 31423 observations and 14 variables.
NOTE: DATA statement used (Total process time):
real time 0.03 seconds
cpu time 0.03 seconds
534 +PROC SORT; BY PROPNBR EFFMY RELDATE;
535 +
NOTE: There were 31423 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31423 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
536 + PROC SORT; BY PROPNBR TRXNBR;
The SAS System
537 +
NOTE: There were 31423 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31423 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
538 +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
539 + SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
540 + SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
541 + SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
542 + SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
543 + SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
544 + SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
545 + SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
546 + SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
547 + SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
548 + SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
549 + SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
550 + SET SPS4;
551 + ENDYRX = &ENDYR;
SYMBOLGEN: Macro variable ENDYR resolves to 17
552 + BEGYRX = &BEGYR;
SYMBOLGEN: Macro variable BEGYR resolves to 16
553 + END = INPUT(PUT(ENDYRX,Z2.),$2.);
554 + BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
555 + IF (YY=&BEGYR AND MO <= 07) OR YY < &BEGYR THEN DO;
SYMBOLGEN: Macro variable BEGYR resolves to 16
SYMBOLGEN: Macro variable BEGYR resolves to 16
556 + ACTDTE = BEG||'07';
557 + OUTPUT SPSFM1;
558 + END;
559 + 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
560 + ACTDTE = BEG||'08';
The SAS System
561 + OUTPUT SPSFM2;
562 + END;
563 + 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
564 + ACTDTE = BEG||'09';
565 + OUTPUT SPSFM3;
566 + END;
567 + 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
568 + ACTDTE = BEG||'10';
569 + OUTPUT SPSFM4;
570 + END;
571 + 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
572 + ACTDTE = BEG||'11';
573 + OUTPUT SPSFM5;
574 + END;
575 + 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
576 + ACTDTE = BEG||'12';
577 + OUTPUT SPSFM6;
578 + END;
579 + 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
580 + ACTDTE = END||'01';
581 + OUTPUT SPSFM7;
582 + END;
583 + 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
584 + ACTDTE = END||'02';
585 + OUTPUT SPSFM8;
586 + END;
The SAS System
587 + 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
588 + ACTDTE = END||'03';
589 + OUTPUT SPSFM9;
590 + END;
591 + 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
592 + ACTDTE = END||'04';
593 + OUTPUT SPSFM10;
594 + END;
595 + 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
596 + ACTDTE = END||'05';
597 + OUTPUT SPSFM11;
598 + END;
599 + 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
600 + ACTDTE = END||'06';
601 + OUTPUT SPSFM12;
602 + END;
603 +
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
555:10 555:24 555:37 559:10 559:24 559:37 563:10 563:24 563:37 567:10 567:24 567:37 571:10 571:24 571:37
575:10 575:24 575:37 579:9 579:26 579:40 583:9 583:26 583:40 587:9 587:26 587:40 591:9 591:26 591:40
595:9 595:26 595:40 599:9 599:26 599:40
NOTE: There were 31423 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.
The SAS System
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 31058 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.09 seconds
cpu time 0.09 seconds
604 +DATA SPS6;
605 + SET SPSFM1
606 + SPSFM2
607 + SPSFM3
608 + SPSFM4
609 + SPSFM5
610 + SPSFM6
611 + SPSFM7
612 + SPSFM8
613 + SPSFM9
614 + SPSFM10
615 + SPSFM11
616 + 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.
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 31058 observations read from the data set WORK.SPSFM12.
NOTE: The data set WORK.SPS6 has 360191 observations and 12 variables.
NOTE: DATA statement used (Total process time):
The SAS System
real time 0.09 seconds
cpu time 0.09 seconds
617 + PROC SORT; BY PROPNBR ACTDTE TRXNBR EFFMY;
618 +
619 +
NOTE: There were 360191 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS6 has 360191 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.10 seconds
cpu time 0.28 seconds
620 +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
621 + SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
622 + IF LAST.ACTDTE THEN OUTPUT SPS7X;
623 +
NOTE: There were 360191 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7X has 88509 observations and 3 variables.
NOTE: DATA statement used (Total process time):
real time 0.07 seconds
cpu time 0.07 seconds
624 +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
625 +
NOTE: There were 88509 observations read from the data set WORK.SPS7X.
NOTE: The data set WORK.SPS7X has 88509 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
626 +DATA SPS7;
The SAS System
627 + MERGE SPS7X(IN=A) SPS6(IN=B);
628 + BY PROPNBR ACTDTE TRXNBR;
629 + IF A AND B;
630 +
NOTE: There were 88509 observations read from the data set WORK.SPS7X.
NOTE: There were 360191 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7 has 129371 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.12 seconds
cpu time 0.12 seconds
631 +PROC SORT DATA = SPS7; BY ĢtvID;
632 +
NOTE: There were 129371 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS7 has 129371 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
633 +PROC SQL;
634 + CREATE TABLE DIRFILE AS
635 + SELECT INDIV_NAME AS PI
636 + ,Ģtv_ID AS ĢtvID
637 + FROM DIR.NAME;
NOTE: Table WORK.DIRFILE created, with 1166132 rows and 2 columns.
638 +
NOTE: PROCEDURE SQL used (Total process time):
real time 1.91 seconds
cpu time 0.85 seconds
639 +PROC SORT; BY ĢtvID;
640 +
The SAS System
NOTE: There were 1166132 observations read from the data set WORK.DIRFILE.
NOTE: The data set WORK.DIRFILE has 1166132 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.28 seconds
cpu time 0.59 seconds
641 +DATA SPS8(KEEP=PI ĢtvID DEPT PROPNBR ACTDTE SHARE TASK INVTYPE);
642 + MERGE DIRFILE(IN=A) SPS7(IN=B);
643 + BY ĢtvID;
644 + IF B;
645 +
646 +/*PROC SQL;
647 +CREATE TABLE CODES AS
648 +SELECT CODE_TYPE AS CDTYPE
649 + ,CODE_VALUE AS CODE
650 + ,CODE_DESC AS CODENAME
651 +FROM COA.CODES
652 +WHERE CODE_TYPE = 'DA';
653 +
654 +PROC SORT DATA = CODES;
655 + BY CODE;
656 +
657 +DATA NAMES(KEEP=DPT DPTNAME) COLNAME(KEEP=COLLEGE COLNAME);
658 + SET CODES;
659 +FORMAT COLLEGE DPT $5.;
660 +
661 +FORMAT COLNAME DPTNAME $35.;
662 + IF SUBSTR(CODE,4,2) = ' ' THEN DO;
663 + COLLEGE = CODE;
664 + COLNAME = CODENAME;
665 + OUTPUT COLNAME;
666 + END;
667 + ELSE DO;
668 + IF SUBSTR(CODE,4,1) NOT = ' ' AND SUBSTR(CODE,5,1) = ' ' THEN DELETE;
669 + DPT = CODE;
670 + DPTNAME = CODENAME;
The SAS System
671 + OUTPUT NAMES;
672 + END;
673 +
674 +PROC SORT DATA = NAMES;
675 + BY DPT;
676 +
677 +PROC SORT DATA = SPS8;
678 + BY DPT;
679 +
680 +DATA SPS9;
681 + MERGE NAMES(IN=A) SPS8(IN=B);
682 + BY DPT;
683 + IF B;
684 + FORMAT DPTNAME $35.;
685 + FORMAT COL $3.;
686 + COL = SUBSTR(DPT,1,3);
687 + COL1 = COL||' ';
688 + FORMAT COLLEGE $5.;
689 + COLLEGE = COMPRESS(COL1);
690 +
691 +PROC SORT DATA = SPS9;
692 + BY COLLEGE;
693 +
694 +PROC SORT DATA = COLNAME;
695 + BY COLLEGE;
696 +
697 +DATA SPS10;
698 + MERGE COLNAME(IN=A) SPS9(IN=B);
699 + BY COLLEGE;
700 + IF B;
701 +
702 +PROC SORT DATA = SPS10;
703 + BY PROPNBR ACTDTE TASK;*/
704 +
705 +
NOTE: There were 1166132 observations read from the data set WORK.DIRFILE.
NOTE: There were 129371 observations read from the data set WORK.SPS7.
The SAS System
NOTE: The data set WORK.SPS8 has 129371 observations and 8 variables.
NOTE: DATA statement used (Total process time):
real time 0.25 seconds
cpu time 0.25 seconds
706 + proc sql;
707 + create table ccdept as
708 + select code_value1 as dept,
709 + code_value2 as CC
710 + from spm.codes
711 +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
712 +proc sort; by dept;
713 +
NOTE: There were 2587 observations read from the data set WORK.CCDEPT.
NOTE: The data set WORK.CCDEPT has 2587 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
714 +PROC SORT DATA = SPS8;
715 + BY dept;
716 +
NOTE: There were 129371 observations read from the data set WORK.SPS8.
NOTE: The data set WORK.SPS8 has 129371 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
The SAS System
717 +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 129371 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 129371 observations and 9 variables.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
718 +proc sort; by cc;
719 +
NOTE: There were 129371 observations read from the data set WORK.MRGCC.
NOTE: The data set WORK.MRGCC has 129371 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.06 seconds
cpu time 0.06 seconds
720 +proc sql;
721 +create table org as
722 +select org_id as CC,
723 +org_name as Cost_Center,
724 +superior_org as CC_Hier
725 +from wdm.organization
726 +where org_type = 'Cost_Center';
NOTE: Table WORK.ORG created, with 1077 rows and 3 columns.
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
727 +proc sort; BY CC;
The SAS System
728 +
NOTE: There were 1077 observations read from the data set WORK.ORG.
NOTE: The data set WORK.ORG has 1077 observations and 3 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
729 +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 129371 observations read from the data set WORK.MRGCC.
NOTE: There were 1077 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 129371 observations and 11 variables.
NOTE: DATA statement used (Total process time):
real time 0.18 seconds
cpu time 0.18 seconds
730 +proc sort; BY CC_Hier;
731 +
NOTE: There were 129371 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 129371 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.34 seconds
cpu time 0.34 seconds
732 +proc sql;
733 +create table org as
734 +select org_id as CC_Hier,
735 +org_name as Cost_Center_Hierarchy
736 +from wdm.organization
737 +where org_type = 'Cost_Center_Hierarchy';
NOTE: Table WORK.ORG created, with 149 rows and 2 columns.
The SAS System
NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
738 +proc sort; BY CC_Hier;
739 +
NOTE: There were 149 observations read from the data set WORK.ORG.
NOTE: The data set WORK.ORG has 149 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
740 +data mrgcc2; merge mrgcc2(in=a) org(in=b); by CC_Hier; if a;
741 +Cost_Center_Hierarchy = scan(Cost_Center_Hierarchy,-1,'|');
742 +Cost_Center = scan(Cost_Center,-1,'|');
NOTE: There were 129371 observations read from the data set WORK.MRGCC2.
NOTE: There were 149 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 129371 observations and 12 variables.
NOTE: DATA statement used (Total process time):
real time 0.39 seconds
cpu time 0.39 seconds
743 +proc sort; BY PROPNBR ACTDTE TASK;
744 +
NOTE: There were 129371 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 129371 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.42 seconds
cpu time 0.42 seconds
745 +PROC SORT DATA = GLSCOA15;
The SAS System
746 + BY PROPNBR ACTDTE TASK;
747 +
NOTE: There were 711 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA15 has 711 observations and 36 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
748 +PROC SQL;
749 + CREATE TABLE GLSSPS1 AS
750 + SELECT A.*,
751 + B.PI,
752 + B.ĢtvID,
753 + B.INVTYPE,
754 + B.SHARE,
755 + B.Cost_Center_Hierarchy,
756 + B.CC,
757 + B.Cost_Center
758 +FROM GLSCOA15 A,
759 + mrgcc2 B
760 +WHERE A.PROPNBR = B.PROPNBR AND
761 + A.ACTDTE = B.ACTDTE AND
762 + A.TASK = B.TASK;
NOTE: Table WORK.GLSSPS1 created, with 1172 rows and 43 columns.
763 +
764 +
NOTE: PROCEDURE SQL used (Total process time):
real time 0.10 seconds
cpu time 0.10 seconds
765 +DATA GLSSPS10(KEEP=PROPNBR ACTDTE); SET GLSSPS1; BY PROPNBR ACTDTE;
766 + IF FIRST.ACTDTE THEN OUTPUT;
767 +
The SAS System
NOTE: There were 1172 observations read from the data set WORK.GLSSPS1.
NOTE: The data set WORK.GLSSPS10 has 529 observations and 2 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
768 +DATA GLSCOA10;
769 + MERGE GLSCOA15(IN=A) GLSSPS10(IN=B);
770 + BY PROPNBR ACTDTE;
771 + IF A AND NOT B;
772 +
NOTE: There were 711 observations read from the data set WORK.GLSCOA15.
NOTE: There were 529 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSCOA10 has 0 observations and 36 variables.
NOTE: DATA statement used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
773 +DATA GLSSPS;
774 + SET GLSSPS1 GLSCOA10;
775 +
776 + IF SHARE = '.' THEN DO; *DPTTOT = TOTAMT; *DPTMTH = MTHAMT; *END;
777 + NDPTTOT = NTOTAMT; CDPTTOT = CTOTAMT;
778 + NDPTMTH = NMTHAMT; CDPTMTH = CMTHAMT;
779 + END;
780 + ELSE DO;
781 + CDPTTOT = CTOTAMT * SHARE / 100;
782 + NDPTTOT = NTOTAMT * SHARE / 100;
783 + CDPTMTH = CMTHAMT * SHARE / 100;
784 + NDPTMTH = NMTHAMT * SHARE / 100;
785 + END;
786 +if flag = 'Y' then agency = sponsor_name; else agency = agency;
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
776:13
The SAS System
NOTE: There were 1172 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 1172 observations and 47 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
787 +PROC SORT; BY Cost_Center_Hierarchy CC SF AGENCY;
788 +*proc print;
789 +
NOTE: There were 1172 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 1172 observations and 47 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
790 +DATA GLSSPS10; SET GLSSPS; BY Cost_Center_Hierarchy CC SF AGENCY;
791 + IF FIRST.AGENCY THEN DO;
792 + CAGTOT = CDPTTOT;
793 + CAGMTH = CDPTMTH;
794 + NAGTOT = NDPTTOT;
795 + NAGMTH = NDPTMTH;
796 + END;
797 + ELSE DO;
798 + CAGTOT + CDPTTOT;
799 + CAGMTH + CDPTMTH;
800 + NAGTOT + NDPTTOT;
801 + NAGMTH + NDPTMTH;
802 + END;
803 + IF LAST.AGENCY THEN DO;
804 + CAGTOT = ROUND(CAGTOT,1.);
805 + CAGMTH = ROUND(CAGMTH,1.);
806 + NAGTOT = ROUND(NAGTOT,1.);
807 + NAGMTH = ROUND(NAGMTH,1.);
808 + OUTPUT;
The SAS System
809 + END;
810 +
NOTE: There were 1172 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS10 has 317 observations and 51 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
811 +PROC SORT; BY Cost_Center_Hierarchy CC AGENCY;
812 +
813 +/*PROC SQL;
814 +CREATE TABLE COACODE AS
815 + SELECT CODE_VALUE AS AGENCY,
816 + CODE_DESC AS AGNAME
817 +FROM COA.CODES
818 +WHERE CODE_TYPE = 'AC';
819 +
820 +PROC SORT DATA = COACODE; BY AGENCY;
821 +
822 +DATA GLSSPS20;
823 +MERGE COACODE(IN=A) GLSSPS10(IN=B);
824 +BY AGENCY;
825 +IF B;
826 +
827 +PROC SORT; BY COLLEGE DPT AGNAME;*/
828 +
NOTE: There were 317 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 317 observations and 51 variables.
NOTE: PROCEDURE SORT used (Total process time):
real time 0.00 seconds
cpu time 0.00 seconds
829 +DATA GLSOUT; SET GLSSPS10;
830 + BY Cost_Center_Hierarchy CC AGENCY;
The SAS System
831 + IF FIRST.agency THEN DO; *MTHTOT = AGMTH; *YTDTOT = AGTOT; *END;
832 + CMTHTOT = CAGMTH; CYTDTOT = CAGTOT;
833 + NMTHTOT = NAGMTH; NYTDTOT = NAGTOT; END;
834 + ELSE DO; *MTHTOT + AGMTH; *YTDTOT + AGTOT; *END;
835 + CMTHTOT + CAGMTH; CYTDTOT + CAGTOT;
836 + NMTHTOT + NAGMTH; NYTDTOT + NAGTOT; END;
837 + IF LAST.agency THEN OUTPUT;
838 +
839 +
840 +%global _ODSDEST;
841 +%global _ODSSTYLE;
842 +
843 +%MACRO PRINT;
844 +OPTIONS ORIENTATION=LANDSCAPE;
845 +
846 +%IF (%UPCASE("&_ODSDEST") eq "PHTML")+ (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
847 +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
848 +data _null_ ;
849 + rc = stpsrv_header('Content-type','text/html');
850 +run ;
851 +ods listing close;
852 +ods html body=_webout style=default;
853 +%END;
854 +
855 +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
856 +data _null_ ;
857 + rc = stpsrv_header('Content-type','application/pdf') ;
858 + rc = stpsrv_header('Content-disposition',"attachment; filename=&TME..pdf");
859 +run ;
860 +ods listing close;
861 +ods pdf file=_webout style=FSS;
862 +%END;
863 +
864 +DATA _NULL_; SET GLSOUT END=FINAL;
865 +FILE PRINT HEADER=A ls=150;
866 + BY Cost_Center_Hierarchy CC AGENCY;
867 +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
868 +TITLE2 " By Hierarchy, Cost Center, and Sponsor";
The SAS System
869 +TITLE3 " PROCESSED IN &MON &EFFYR ";
870 +TITLE4 ' ';
871 +CGRDAGMTH + CMTHTOT;
872 +NGRDAGMTH + NMTHTOT;
873 +CGRDAGTOT + CYTDTOT;
874 +NGRDAGTOT + NYTDTOT;
875 + IF FIRST.Cost_Center_Hierarchy THEN DO;
876 + NCOLAGMTH = NMTHTOT;
877 + NCOLAGTOT = NYTDTOT;
878 + CCOLAGMTH = CMTHTOT;
879 + CCOLAGTOT = CYTDTOT;
880 + PUT @1 Cost_Center_Hierarchy /;
881 + END;
882 + ELSE DO;
883 + NCOLAGMTH + NMTHTOT;
884 + NCOLAGTOT + NYTDTOT;
885 + CCOLAGMTH + CMTHTOT;
886 + CCOLAGTOT + CYTDTOT;
887 + END;
888 +
889 + IF FIRST.CC THEN DO;
890 + NDPTAGMTH = NMTHTOT;
891 + NDPTAGTOT = NYTDTOT;
892 + CDPTAGMTH = CMTHTOT;
893 + CDPTAGTOT = CYTDTOT;
894 + PUT @3 CC '- ' Cost_Center /
895 + @50 AGENCY
896 + @80 NMTHTOT COMMA16.
897 + @97 CMTHTOT COMMA16.
898 + @114 NYTDTOT COMMA16.
899 + @131 CYTDTOT COMMA16.;
900 +
901 + END;
902 + ELSE DO;
903 + NDPTAGMTH + NMTHTOT;
904 + NDPTAGTOT + NYTDTOT;
905 + CDPTAGMTH + CMTHTOT;
906 + CDPTAGTOT + CYTDTOT;
The SAS System
907 + PUT @50 AGENCY
908 + @80 NMTHTOT COMMA16.
909 + @97 CMTHTOT COMMA16.
910 + @114 NYTDTOT COMMA16.
911 + @131 CYTDTOT COMMA16.;
912 + END;
913 +
914 + IF LAST.CC THEN DO;
915 + PUT @1 /
916 + @50 'TOTAL COST CENTER'
917 + @80 NDPTAGMTH DOLLAR16.
918 + @97 CDPTAGMTH DOLLAR16.
919 + @114 NDPTAGTOT DOLLAR16.
920 + @131 CDPTAGTOT DOLLAR16./;
921 + END;
922 +
923 + IF LAST.Cost_Center_Hierarchy THEN DO;
924 + PUT @1 /
925 + @45 'TOTAL CC HIERARCHY'
926 + @80 NCOLAGMTH DOLLAR16.
927 + @97 CCOLAGMTH DOLLAR16.
928 + @114 NCOLAGTOT DOLLAR16.
929 + @131 CCOLAGTOT DOLLAR16./;
930 + END;
931 +
932 + IF FINAL THEN DO;
933 + PUT @1 /
934 + @45 'TOTAL'
935 + @80 NGRDAGMTH DOLLAR16.
936 + @97 CGRDAGMTH DOLLAR16.
937 + @114 NGRDAGTOT DOLLAR16.
938 + @131 CGRDAGTOT DOLLAR16./;
939 + END;
940 +
941 +RETURN;
942 +A:
943 + PUT @ 50 'AGENCY'
944 + @ 89 'MONTHLY AMOUNT'
The SAS System
945 + @118 'FISCAL YTD AMOUNT'/
946 + @ 87 'NEW'
947 + @102 'CONT'
948 + @117 'NEW'
949 + @132 'CONT'//;
950 +RETURN;
951 +
952 +PROC TEMPLATE;
953 + DEFINE STYLE WHITE ;
954 + PARENT=STYLES.PRINTER;
955 + REPLACE COLOR_LIST /
956 + 'LINK' = BLUE
957 + 'BGH' = WHITE
958 + 'FG' = BLACK
959 + 'BG' = WHITE;
960 + END;
961 + RUN;
962 +
963 +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
964 +ods html close;
965 +%END;
966 +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
967 +ods pdf close;
968 +%END;
969 +
970 +%END;
971 +%MEND PRINT;
972 +%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: There were 317 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSOUT has 316 observations and 55 variables.
NOTE: DATA statement used (Total process time):
real time 0.01 seconds
cpu time 0.01 seconds
The SAS System
SYMBOLGEN: Macro variable TME resolves to 39428.704
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".
SYMBOLGEN: Macro variable MON resolves to MAY
SYMBOLGEN: Macro variable EFFYR resolves to 2017
NOTE: 640 lines were written to file PRINT.
NOTE: There were 316 observations read from the data set WORK.GLSOUT.
NOTE: DATA statement used (Total process time):
real time 0.04 seconds
cpu time 0.04 seconds
NOTE: STYLE 'White' has been saved to: WORK.TEMPLAT
NOTE: PROCEDURE TEMPLATE used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
SYMBOLGEN: Macro variable _ODSDEST resolves to PDF
NOTE: ODS PDF printed 28 pages to B1BA3ED2-5671-4D28-9442-CBD2A1690F1B.
973 +/*
974 +ODS PDF FILE=&PFILE NOTOC STYLE = WHITE ;
975 +
976 +DATA _NULL_; SET GLSOUT END=FINAL;
977 +FILE PRINT HEADER=A;
978 + BY COLLEGE DPT AGNAME;
979 +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
980 +TITLE2 " BY COLLEGE, DEPARTMENT, AND SPONSOR";
The SAS System
981 +TITLE3 " PROCESSED IN &MON &EFFYR ";
982 +TITLE4 ' ';
983 +CGRDAGMTH + CMTHTOT;
984 +NGRDAGMTH + NMTHTOT;
985 +CGRDAGTOT + CYTDTOT;
986 +NGRDAGTOT + NYTDTOT;
987 + IF FIRST.COLLEGE THEN DO;
988 + NCOLAGMTH = NMTHTOT;
989 + NCOLAGTOT = NYTDTOT;
990 + CCOLAGMTH = CMTHTOT;
991 + CCOLAGTOT = CYTDTOT;
992 + PUT @1 COLLEGE '- ' COLNAME /;
993 + END;
994 + ELSE DO;
995 + NCOLAGMTH + NMTHTOT;
996 + NCOLAGTOT + NYTDTOT;
997 + CCOLAGMTH + CMTHTOT;
998 + CCOLAGTOT + CYTDTOT;
999 + END;
1000 +
1001 + IF FIRST.DPT THEN DO;
1002 + NDPTAGMTH = NMTHTOT;
1003 + NDPTAGTOT = NYTDTOT;
1004 + CDPTAGMTH = CMTHTOT;
1005 + CDPTAGTOT = CYTDTOT;
1006 + PUT @3 DPT '- ' DPTNAME /
1007 + @50 AGNAME
1008 + @80 NMTHTOT COMMA11.
1009 + @95 CMTHTOT COMMA11.
1010 + @110 NYTDTOT COMMA11.
1011 + @125 CYTDTOT COMMA11.;
1012 + END;
1013 + ELSE DO;
1014 + NDPTAGMTH + NMTHTOT;
1015 + NDPTAGTOT + NYTDTOT;
1016 + CDPTAGMTH + CMTHTOT;
1017 + CDPTAGTOT + CYTDTOT;
1018 + PUT @50 AGNAME
The SAS System
1019 + @80 NMTHTOT COMMA11.
1020 + @95 CMTHTOT COMMA11.
1021 + @110 NYTDTOT COMMA11.
1022 + @125 CYTDTOT COMMA11.;
1023 + END;
1024 +
1025 + IF LAST.DPT THEN DO;
1026 + PUT @1 /
1027 + @50 'TOTAL DEPARTMENT'
1028 + @80 NDPTAGMTH DOLLAR11.
1029 + @95 CDPTAGMTH DOLLAR11.
1030 + @110 NDPTAGTOT DOLLAR11.
1031 + @125 CDPTAGTOT DOLLAR11./;
1032 + END;
1033 +
1034 + IF LAST.COLLEGE THEN DO;
1035 + PUT @1 /
1036 + @45 'TOTAL COLLEGE'
1037 + @80 NCOLAGMTH DOLLAR11.
1038 + @95 CCOLAGMTH DOLLAR11.
1039 + @110 NCOLAGTOT DOLLAR11.
1040 + @125 CCOLAGTOT DOLLAR11./;
1041 + END;
1042 +
1043 + IF FINAL THEN DO;
1044 + PUT @1 /
1045 + @45 'TOTAL'
1046 + @80 NGRDAGMTH DOLLAR11.
1047 + @95 CGRDAGMTH DOLLAR11.
1048 + @110 NGRDAGTOT DOLLAR11.
1049 + @125 CGRDAGTOT DOLLAR11./;
1050 + END;
1051 +
1052 +RETURN;
1053 +A:
1054 + PUT @ 50 'AGENCY'
1055 + @ 89 'MONTHLY AMOUNT'
1056 + @118 'FISCAL YTD AMOUNT'/
The SAS System
1057 + @ 87 'NEW'
1058 + @102 'CONT'
1059 + @117 'NEW'
1060 + @132 'CONT'//;
1061 +RETURN;
1062 +RUN;
1063 +
1064 +ODS PDF CLOSE;
1065 +
1066 + ODS HTML FILE=&HFILE STYLE=MINIMAL RS=NONE;
1067 +
1068 +DATA _NULL_; SET GLSOUT END=FINAL;
1069 +FILE PRINT HEADER=A;
1070 + BY COLLEGE DPT AGNAME;
1071 +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
1072 +TITLE2 " BY COLLEGE, DEPARTMENT, AND SPONSOR";
1073 +TITLE3 " PROCESSED IN &MON &EFFYR ";
1074 +TITLE4 ' ';
1075 +CGRDAGMTH + CMTHTOT;
1076 +NGRDAGMTH + NMTHTOT;
1077 +CGRDAGTOT + CYTDTOT;
1078 +NGRDAGTOT + NYTDTOT;
1079 + IF FIRST.COLLEGE THEN DO;
1080 + NCOLAGMTH = NMTHTOT;
1081 + NCOLAGTOT = NYTDTOT;
1082 + CCOLAGMTH = CMTHTOT;
1083 + CCOLAGTOT = CYTDTOT;
1084 + PUT @1 COLLEGE '- ' COLNAME /;
1085 + END;
1086 + ELSE DO;
1087 + NCOLAGMTH + NMTHTOT;
1088 + NCOLAGTOT + NYTDTOT;
1089 + CCOLAGMTH + CMTHTOT;
1090 + CCOLAGTOT + CYTDTOT;
1091 + END;
1092 +
1093 + IF FIRST.DPT THEN DO;
1094 + NDPTAGMTH = NMTHTOT;
The SAS System
1095 + NDPTAGTOT = NYTDTOT;
1096 + CDPTAGMTH = CMTHTOT;
1097 + CDPTAGTOT = CYTDTOT;
1098 + PUT @3 DPT '- ' DPTNAME /
1099 + @50 AGNAME
1100 + @80 NMTHTOT COMMA11.
1101 + @95 CMTHTOT COMMA11.
1102 + @110 NYTDTOT COMMA11.
1103 + @125 CYTDTOT COMMA11.;
1104 + END;
1105 + ELSE DO;
1106 + NDPTAGMTH + NMTHTOT;
1107 + NDPTAGTOT + NYTDTOT;
1108 + CDPTAGMTH + CMTHTOT;
1109 + CDPTAGTOT + CYTDTOT;
1110 + PUT @50 AGNAME
1111 + @80 NMTHTOT COMMA11.
1112 + @95 CMTHTOT COMMA11.
1113 + @110 NYTDTOT COMMA11.
1114 + @125 CYTDTOT COMMA11.;
1115 + END;
1116 +
1117 + IF LAST.DPT THEN DO;
1118 + PUT @1 /
1119 + @50 'TOTAL DEPARTMENT'
1120 + @80 NDPTAGMTH DOLLAR11.
1121 + @95 CDPTAGMTH DOLLAR11.
1122 + @110 NDPTAGTOT DOLLAR11.
1123 + @125 CDPTAGTOT DOLLAR11./;
1124 + END;
1125 +
1126 + IF LAST.COLLEGE THEN DO;
1127 + PUT @1 /
1128 + @45 'TOTAL COLLEGE'
1129 + @80 NCOLAGMTH DOLLAR11.
1130 + @95 CCOLAGMTH DOLLAR11.
1131 + @110 NCOLAGTOT DOLLAR11.
1132 + @125 CCOLAGTOT DOLLAR11./;
The SAS System
1133 + END;
1134 +
1135 + IF FINAL THEN DO;
1136 + PUT @1 /
1137 + @45 'TOTAL'
1138 + @80 NGRDAGMTH DOLLAR11.
1139 + @95 CGRDAGMTH DOLLAR11.
1140 + @110 NGRDAGTOT DOLLAR11.
1141 + @125 CGRDAGTOT DOLLAR11./;
1142 + END;
1143 +
1144 +RETURN;
1145 +A:
1146 + PUT @ 50 'AGENCY'
1147 + @ 89 'MONTHLY AMOUNT'
1148 + @118 'FISCAL YTD AMOUNT'/
1149 + @ 87 'NEW'
1150 + @102 'CONT'
1151 + @117 'NEW'
1152 + @132 'CONT'//;
1153 +RETURN;
1154 +RUN;
1155 +
1156 +ODS HTML CLOSE;
1157 +
1158 +* Begin EG generated code (do not edit this line);
1159 +;*';*";*/;quit;
1160 +
1161 +* End EG generated code (do not edit this line);
1162 +
NOTE: %INCLUDE (level 1) ending.