SAS Log

1                                                                                                                        The SAS System                                                                                        08:58 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.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=20170131
 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=274B568B-0A4C-4942-8FA4-FCC0E76D5686&_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.TCAT0009
 _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.00 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.01 seconds
                                                                 The SAS System

      cpu time            0.01 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 20170131
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 5943 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 5943 observations read from the data set WORK.FUND1.
NOTE: The data set WORK.FUND1 has 5943 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.03 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.01 seconds
      cpu time            0.01 seconds
      

147       +DATA MRG1; MERGE FUND1(IN=A) GRANT1(IN=B); BY GRANT_ID; IF A AND B;

NOTE: There were 5943 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.00 seconds
      cpu time            0.00 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.03 seconds
      cpu time            0.01 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.00 seconds
      cpu time            0.00 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.01 seconds
                                                                 The SAS System

      cpu time            0.01 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.00 seconds
      cpu time            0.00 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.01 seconds
      cpu time            0.01 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.00 seconds
      cpu time            0.00 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.00 seconds
      cpu time            0.00 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.01 seconds
      cpu time            0.01 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.01 seconds
      cpu time            0.01 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.00 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.01 seconds
      cpu time            0.01 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.01 seconds
      cpu time            0.01 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.00 seconds
      cpu time            0.00 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.01 seconds
      cpu time            0.01 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.00 seconds
      cpu time            0.00 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.01 seconds
      cpu time            0.01 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 20170131
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 01      
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 340 observations and 34 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

469       +PROC SORT DATA = budg1; BY ACTDTE grant_id;
470       +

NOTE: There were 340 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.BUDG1 has 340 observations and 34 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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 340 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 323 observations and 36 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 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 17940 rows and 5 columns.

501       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.06 seconds
      cpu time            0.06 seconds
      

502       + PROC SORT; BY PROPNBR TRXNBR RELDATE;
503       +

NOTE: There were 17940 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.PROJTRAN has 17940 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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 17940 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.SPS2 has 17940 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 17940 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17940 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 17940 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17940 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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 73651 rows and 7 columns.

                                                                 The SAS System

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.17 seconds
      cpu time            0.10 seconds
      

529       +    PROC SORT; BY PROPNBR TRXNBR TASK;
530       +

NOTE: There were 73651 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.PISHR has 73651 observations and 7 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

531       +DATA SPS4;
532       +  MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
533       +

NOTE: There were 17940 observations read from the data set WORK.SPS2.
NOTE: There were 73651 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.SPS4 has 31421 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 31421 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31421 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 31421 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31421 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 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 31421 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.10 seconds
      cpu time            0.10 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.12 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.03 seconds
      cpu time            0.03 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 1166164 rows and 2 columns.

638       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           1.91 seconds
      cpu time            0.88 seconds
      

639       +PROC SORT; BY Ä¢¹½tvID;
640       +
                                                                 The SAS System


NOTE: There were 1166164 observations read from the data set WORK.DIRFILE.
NOTE: The data set WORK.DIRFILE has 1166164 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.26 seconds
      cpu time            0.56 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 1166164 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.26 seconds
      cpu time            0.26 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.00 seconds
      cpu time            0.00 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.06 seconds
      cpu time            0.06 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.03 seconds
      cpu time            0.03 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.01 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.01 seconds
      cpu time            0.01 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.15 seconds
      cpu time            0.15 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.31 seconds
      cpu time            0.31 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.03 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.43 seconds
      cpu time            0.42 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.54 seconds
      cpu time            0.54 seconds
      

745       +PROC SORT DATA = GLSCOA15;
                                                                 The SAS System

746       + BY PROPNBR ACTDTE TASK;
747       +

NOTE: There were 323 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA15 has 323 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 547 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 547 observations read from the data set WORK.GLSSPS1.
NOTE: The data set WORK.GLSSPS10 has 260 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 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 323 observations read from the data set WORK.GLSCOA15.
NOTE: There were 260 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 547 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 547 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 547 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 547 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 547 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS10 has 185 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 185 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 185 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 185 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSOUT has 185 observations and 55 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
                                                                 The SAS System

      

SYMBOLGEN:  Macro variable TME resolves to    32335.727

NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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 JANUARY  
SYMBOLGEN:  Macro variable EFFYR resolves to 2017

NOTE: 433 lines were written to file PRINT.
NOTE: There were 185 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 20 pages to 6D00B3C6-3CA0-41F9-99A9-592E35B7A950.
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.