SAS Log

1                                                                                                                        The SAS System                                                                                           18:00 Friday, October 27, 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=20170731
 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; JSESSIONID=B12F5390566265A18F266CE484550363; sso-logout-time="Sat Oct 28 2017 00:21:51 GMT-0500 (Central Daylight Time)"; LtpaToken=AAECAzU5RjNBMzMzNTlGND
     EzRUZrdHdlZWRAbHN1LmVkdcdWf3QzOoQT/y0rCsn2UmWdnyJL; __unam=7ac2274-151253bf750-b2127a8-1774
 _HTUA=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/61.0.3163.91 Safari/537.36
 _METAFOLDER=/FSS/
 _METAPERSON=FSSGuest
 _METAUSER=FSSGuest@saspw
 _ODSDEST=PDF
 _PASSWORD=XXXXXX
 _PROGRAM=/FSS/SPONCOL2
 _REPLAY="&_URL?_sessionid=2229B1B4-2751-4FAA-96BD-EA26D4C580CB&_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.TCAT0013
 _URL=/SASStoredProcess/do
 _USERLOCALE=en_US
 _USERNAME=FSSGuest@saspw
 _VERSION=Version 9.3 (Build 478)

NOTE: %INCLUDE (level 1) file D:\SAS Stored Processes\FSS\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        +	%GetLSUUser
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _HTCOOK resolves to _ga=GA1.2.833841193.1398869373; JSESSIONID=B12F5390566265A18F266CE484550363; sso-logout-time="Sat 
            Oct 28 2017 00:21:51 GMT-0500 (Central Daylight Time)"; 
            LtpaToken=AAECAzU5RjNBMzMzNTlGNDEzRUZrdHdlZWRAbHN1LmVkdcdWf3QzOoQT/y0rCsn2UmWdnyJL; __unam=7ac2274-151253bf750-b2127a8-1774
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 AAECAzU5RjNBMzMzNTlGNDEzRUZrdHdlZWRAbHN1LmVkdcdWf3QzOoQT/y0rCsn2UmWdnyJL
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 LSU is:
      Filename=http://cgi.lsu.edu:8080/eis/servlet/getuser?LtpaToken=AAECAzU5RjNBMzMzNTlGNDEzRUZrdHdlZWRAbHN1LmVkdcdWf3QzOoQT/y0rCsn2UmWdnyJL,
      Local Host Name=SASDCOMPUTE,
      Local Host IP addr=fe80::602f:416e:d266:b362%11,
      Service Hostname Name=cgi.uis.lsu.edu,
      Service IP addr=130.39.20.36,Service Name=N/A,
      Service Portno=8080,Lrecl=2000,Recfm=Stream

NOTE: 1 record was read from the infile LSU.
      The minimum record length was 33.
      The maximum record length was 33.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
                                                                 The SAS System

      cpu time            0.00 seconds
      

**END*USEREND*USER**


SYMBOLGEN:  Macro variable _LSUPERSON resolves to Keri M Tweed
SYMBOLGEN:  Macro variable _LSUUSER resolves to ktweed
****  This stored process was requested by Keri M Tweed with LSUUSERID: ktweed


**END*USEREND*USER**
SYMBOLGEN:  Macro variable _INFILE resolves to            0
SYMBOLGEN:  Macro variable _INUSER resolves to            1
46        +
47        +  *** ENTER EFFECTIVE DATE ***;
48        +*%LET EFFDTE = 20170228;
49        +
50        +DATA DATE;
51        +  EFFDTE  = "&EFFDTE";
SYMBOLGEN:  Macro variable EFFDTE resolves to 20170731
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 > 6 then begfy = effyr; else begfy = effyr - 1;	
74        +	format begdte yymmddn.;
75        +begdte = begfy||'0701';
76        +begdte1 = INPUT(PUT(begdte,$8.),8.);
WARNING: Variable begdte has already been defined as numeric.
77        +CALL SYMPUT('begdte1',begdte1);
78        +
79        +IF EFFMN = 01 THEN MON = 'JANUARY  ';
80        +IF EFFMN = 02 THEN MON = 'FEBRUARY ';
81        +IF EFFMN = 03 THEN MON = 'MARCH    ';
82        +IF EFFMN = 04 THEN MON = 'APRIL    ';
83        +IF EFFMN = 05 THEN MON = 'MAY      ';
84        +IF EFFMN = 06 THEN MON = 'JUNE     ';
85        +IF EFFMN = 07 THEN MON = 'JULY     ';
86        +IF EFFMN = 08 THEN MON = 'AUGUST   ';
87        +IF EFFMN = 09 THEN MON = 'SEPTEMBER';
88        +IF EFFMN = 10 THEN MON = 'OCTOBER  ';
89        +IF EFFMN = 11 THEN MON = 'NOVEMBER ';
90        +IF EFFMN = 12 THEN MON = 'DECEMBER ';
91        + CALL SYMPUT('MON',MON);
92        +
93        +BEGFY=FISCAL-1;
94        +BEGFX = INPUT(PUT(BEGFY,4.),$4.);
95        +FISX = INPUT(PUT(FISCAL,4.),$4.);
96        +FORMAT BEGYR ENDYR $2.;
97        +BEGYR = SUBSTR(BEGFX,3,2);
98        +ENDYR = SUBSTR(FISX,3,2);
99        +CALL SYMPUT('BEGYR',BEGYR);
100       +CALL SYMPUT('ENDYR',ENDYR);
101       +
102       +
103       +
104       +/*LIBNAME COA DB2 AUTHID=COA SSID=DB2;
105       +LIBNAME SPM DB2 AUTHID=SPM SSID=DB2;
                                                                 The SAS System

106       +LIBNAME DIR DB2 AUTHID=DIR SSID=DB2;
107       +
108       +
109       +PROC SQL;
110       + CREATE TABLE COAFILE AS
111       + SELECT P_I_LSU_ID          AS PIID
112       +       ,ACCT_CODE           AS ACCT
113       +       ,AGENCY_CD           AS AGENCY
114       +       ,GRANT_EXPIRE_DATE   AS EXPIRE
115       +       ,PROPOSAL_NBR        AS PROPNBR
116       +       ,GRANT_NAME          AS STITLE
117       +       ,TOTAL_AWARD_AMT     AS TOTAWARD
118       +       ,CO_P_I_LSU_ID       AS COPIID
119       +       ,INTERNAL_COMP_FLAG  AS INTFLAG
120       +       ,TASK_NBR            AS TASK
121       +FROM COA.SPONSORED_PROGRAMS
122       +WHERE SUBSTR(ACCT_CODE,1,1) = '1'
123       +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6') AND PROPOSAL_NBR <> 0
124       +AND AGENCY_CD NOT IN ('A1','C','Z','XF') AND BILL_CYCLE_CD <> 'G'
125       +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
126       +'190067') AND FISCAL_YEAR = &FYEAR;
127       +
128       +PROC SORT; BY ACCT;*/
129       +
130       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      56:6    57:18   73:5    73:48   75:15   79:4    80:4    81:4    82:4    83:4    84:4    85:4    86:4    87:4    88:4    89:4    90:4
      93:7    
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      57:24   71:20   73:54   77:23   93:13   
NOTE: The data set WORK.DATE has 1 observations and 19 variables.
NOTE: Compressing data set WORK.DATE increased size by 100.00 percent. 
      Compressed is 2 pages; un-compressed would require 1 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
                                                                 The SAS System


131       +PROC SQL;
132       +CREATE TABLE FUND1 AS
133       +SELECT ORG_ID AS GRANT_ID,
134       +FUND as SF
135       +FROM WDM.fin_fdm_DRIVERTAG
136       +WHERE FUND IN ('FD250','FD251','FD252');
NOTE: Compressing data set WORK.FUND1 decreased size by 48.11 percent. 
      Compressed is 55 pages; un-compressed would require 106 pages.
NOTE: Table WORK.FUND1 created, with 6101 rows and 2 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.03 seconds
      cpu time            0.00 seconds
      

137       +PROC SORT; BY GRANT_ID;
138       +

NOTE: There were 6101 observations read from the data set WORK.FUND1.
NOTE: The data set WORK.FUND1 has 6101 observations and 2 variables.
NOTE: Compressing data set WORK.FUND1 decreased size by 48.11 percent. 
      Compressed is 55 pages; un-compressed would require 106 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

139       +PROC SQL;
140       +CREATE TABLE GRANT1 AS
141       +SELECT GRANT_ID,
142       +AWARD_NUMBER as award_budg,
143       +TASK_NUMBER,
144       +TO_DATE AS GRANT_EXP_DATE,
145       +sponsor_id,
146       +cont_line_status,
147       +is_primary,
148       +workday_id
                                                                 The SAS System

149       +FROM WDM.FIN_AWD_LINE
150       +WHERE COMPANY = '10' and cont_status NE ' ';
NOTE: Compressing data set WORK.GRANT1 decreased size by 26.98 percent. 
      Compressed is 46 pages; un-compressed would require 63 pages.
NOTE: Table WORK.GRANT1 created, with 3498 rows and 8 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.04 seconds
      cpu time            0.01 seconds
      

151       +PROC SORT; BY GRANT_ID;
152       +

NOTE: There were 3498 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.GRANT1 has 3498 observations and 8 variables.
NOTE: Compressing data set WORK.GRANT1 decreased size by 26.98 percent. 
      Compressed is 46 pages; un-compressed would require 63 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

NOTE: There were 6101 observations read from the data set WORK.FUND1.
NOTE: There were 3498 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.MRG1 has 3042 observations and 9 variables.
NOTE: Compressing data set WORK.MRG1 decreased size by 38.57 percent. 
      Compressed is 43 pages; un-compressed would require 70 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

154       +PROC SORT; BY sponsor_id;
155       +

                                                                 The SAS System

NOTE: There were 3042 observations read from the data set WORK.MRG1.
NOTE: The data set WORK.MRG1 has 3042 observations and 9 variables.
NOTE: Compressing data set WORK.MRG1 decreased size by 38.57 percent. 
      Compressed is 43 pages; un-compressed would require 70 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

156       +proc sql;
157       +create table SPON as
158       +select sponsor_id,
159       +SPONSOR_NAME,
160       +sponsor_type as AGENCY,
161       +parent_id as parent
162       +from wdm.fin_awd_sponsor;
NOTE: Compressing data set WORK.SPON decreased size by 69.44 percent. 
      Compressed is 11 pages; un-compressed would require 36 pages.
NOTE: Table WORK.SPON created, with 1609 rows and 4 columns.

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

163       +proc sort; by sponsor_id;
164       +

NOTE: There were 1609 observations read from the data set WORK.SPON.
NOTE: The data set WORK.SPON has 1609 observations and 4 variables.
NOTE: Compressing data set WORK.SPON decreased size by 69.44 percent. 
      Compressed is 11 pages; un-compressed would require 36 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

165       +data mrgspon; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
                                                                 The SAS System


NOTE: There were 3042 observations read from the data set WORK.MRG1.
NOTE: There were 1609 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSPON has 3042 observations and 12 variables.
NOTE: Compressing data set WORK.MRGSPON decreased size by 62.63 percent. 
      Compressed is 37 pages; un-compressed would require 99 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

166       +PROC SORT; BY award_budg grant_id cont_line_status descending is_primary ;
167       +

NOTE: There were 3042 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.MRGSPON has 3042 observations and 12 variables.
NOTE: Compressing data set WORK.MRGSPON decreased size by 62.63 percent. 
      Compressed is 37 pages; un-compressed would require 99 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

168       +data setmrgspon1; set mrgspon; BY award_budg grant_id cont_line_status descending is_primary ;
169       +if first.grant_id then output;

NOTE: There were 3042 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.SETMRGSPON1 has 3038 observations and 12 variables.
NOTE: Compressing data set WORK.SETMRGSPON1 decreased size by 62.63 percent. 
      Compressed is 37 pages; un-compressed would require 99 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

170       +proc sort; by sponsor_id;
171       +

                                                                 The SAS System

NOTE: There were 3038 observations read from the data set WORK.SETMRGSPON1.
NOTE: The data set WORK.SETMRGSPON1 has 3038 observations and 12 variables.
NOTE: Compressing data set WORK.SETMRGSPON1 decreased size by 62.63 percent. 
      Compressed is 37 pages; un-compressed would require 99 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

172       +data setSPON; set setmrgspon1; by sponsor_id;
173       +if agency in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency'); *then do; *output statefed;
174       +	if parent ne ' ' then sponsor_id = parent; else sponsor_id = sponsor_id;
175       +	flag = 'Y';*output;
176       +	*end;

NOTE: There were 3038 observations read from the data set WORK.SETMRGSPON1.
NOTE: The data set WORK.SETSPON has 2084 observations and 13 variables.
NOTE: Compressing data set WORK.SETSPON decreased size by 61.76 percent. 
      Compressed is 26 pages; un-compressed would require 68 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

177       +proc sort; by sponsor_id;
178       +

NOTE: There were 2084 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.SETSPON has 2084 observations and 13 variables.
NOTE: Compressing data set WORK.SETSPON decreased size by 61.76 percent. 
      Compressed is 26 pages; un-compressed would require 68 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

179       +data setSPON2; set setmrgspon1; by sponsor_id;
180       +if agency not in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency');
                                                                 The SAS System


NOTE: There were 3038 observations read from the data set WORK.SETMRGSPON1.
NOTE: The data set WORK.SETSPON2 has 954 observations and 12 variables.
NOTE: Compressing data set WORK.SETSPON2 decreased size by 58.06 percent. 
      Compressed is 13 pages; un-compressed would require 31 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

181       +proc sort; by sponsor_id;
182       +
183       +
184       +/*proc sql;
185       +create table SPONparent as
186       +select sponsor_id,
187       +SPONSOR_NAME as Parent_name,
188       +sponsor_type as AGENCY,
189       +parent_id
190       +from wdm.fin_awd_sponsor;
191       +proc sort; by sponsor_id;
192       +
193       +data mrgspon; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
194       +*if agency in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency') then do; *output statefed;
195       +	if parent_id ne ' ' then do; sponsor_id = parent_id;
196       +*else sponsor_id = sponsor_id; end;
197       +else do;
198       +sponsor_id = sponsor_id;
199       +end;
200       +*else output mrgspon;
201       +proc sort; by AWARD_NUMBER;*/
202       +

NOTE: There were 954 observations read from the data set WORK.SETSPON2.
NOTE: The data set WORK.SETSPON2 has 954 observations and 12 variables.
NOTE: Compressing data set WORK.SETSPON2 decreased size by 58.06 percent. 
      Compressed is 13 pages; un-compressed would require 31 pages.
NOTE: PROCEDURE SORT used (Total process time):
                                                                 The SAS System

      real time           0.00 seconds
      cpu time            0.00 seconds
      

203       +data setSTATEFED (drop=sponsor_name agency); set setspon;
204       +if parent ne ' ' then sponsor_id = parent; else sponsor_id = sponsor_id;

NOTE: There were 2084 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.SETSTATEFED has 2084 observations and 11 variables.
NOTE: Compressing data set WORK.SETSTATEFED decreased size by 35.29 percent. 
      Compressed is 22 pages; un-compressed would require 34 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

205       +proc sort; by sponsor_id;
206       +
207       +/*data set2; set setstatefed; by sponsor_id;
208       +if last.sponsor_id then output;
209       +proc sort; by sponsor_id;*/
210       +
211       +
212       +/*data setspon (keep=sponsor_id); set spon; by sponsor_id;
213       +if sponsor_type in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency') then do;
214       +		if parent_id ne ' ' then sponsor_id = parent_id; else sponsor_id = sposnor_id;
215       +
216       +end;
217       +proc sort; by sponsor_id;*/
218       +
219       +/*data mrgspon statefed; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;
220       +if agency in ('Sponsor_Type_State_Agency','Sponsor_Type_Federal_Agency') then output statefed;
221       +else output mrgspon;
222       +proc sort; by AWARD_NUMBER;
223       +
224       +data setSTATEFED(keep=parent_id sponsor_id); set statefed;
225       +if parent_id ne ' ' then sponsor_id = parent_id; else sponsor_id = sponsor_id;
226       +proc sort; by sponsor_id;
                                                                 The SAS System

227       +
228       +data set2; set setstatefed; by sponsor_id;
229       +if last.sponsor_id then output;
230       +proc sort; by sponsor_id;*/
231       +

NOTE: There were 2084 observations read from the data set WORK.SETSTATEFED.
NOTE: The data set WORK.SETSTATEFED has 2084 observations and 11 variables.
NOTE: Compressing data set WORK.SETSTATEFED decreased size by 35.29 percent. 
      Compressed is 22 pages; un-compressed would require 34 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

232       +data mrgstate; merge setSTATEFED(in=a) spon(in=b); by sponsor_id; if a;

NOTE: There were 2084 observations read from the data set WORK.SETSTATEFED.
NOTE: There were 1609 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSTATE has 2084 observations and 13 variables.
NOTE: Compressing data set WORK.MRGSTATE decreased size by 63.24 percent. 
      Compressed is 25 pages; un-compressed would require 68 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

233       +proc sort; by sponsor_id;
234       +

NOTE: There were 2084 observations read from the data set WORK.MRGSTATE.
NOTE: The data set WORK.MRGSTATE has 2084 observations and 13 variables.
NOTE: Compressing data set WORK.MRGSTATE decreased size by 63.24 percent. 
      Compressed is 25 pages; un-compressed would require 68 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
                                                                 The SAS System


235       +data setspons; set mrgstate setspon2; by sponsor_id;

NOTE: There were 2084 observations read from the data set WORK.MRGSTATE.
NOTE: There were 954 observations read from the data set WORK.SETSPON2.
NOTE: The data set WORK.SETSPONS has 3038 observations and 13 variables.
NOTE: Compressing data set WORK.SETSPONS decreased size by 63.64 percent. 
      Compressed is 36 pages; un-compressed would require 99 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

236       +proc sort; by award_budg;
237       +
238       +/*data mrgspon1; merge mrg1(in=a) setspons(in=b); by sponsor_id; if a;
239       +proc sort; by award_number;*/
240       +

NOTE: There were 3038 observations read from the data set WORK.SETSPONS.
NOTE: The data set WORK.SETSPONS has 3038 observations and 13 variables.
NOTE: Compressing data set WORK.SETSPONS decreased size by 63.64 percent. 
      Compressed is 36 pages; un-compressed would require 99 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

241       +PROC SQL;
242       +CREATE TABLE AWARD1 AS
243       +SELECT AWARD_NUMBER as award_budg,
244       +PROPOSAL_ID as propnbr,
245       +AWARD_NAME,
246       +signed_date,
247       +TOTAL_AMOUNT AS AWD_TOTAL,
248       +award_date
249       +FROM WDM.FIN_AWD
250       +WHERE PROPOSAL_ID NE 0 and
                                                                 The SAS System

251       +award_type not in ('SPN_AWD_Type_Disaster_Relief','SPN_AWD_Type_Pell_SEOG_CWS','SPN_AWD_Type_Federal_Appropriations');
NOTE: Compressing data set WORK.AWARD1 decreased size by 76.12 percent. 
      Compressed is 16 pages; un-compressed would require 67 pages.
NOTE: Table WORK.AWARD1 created, with 1917 rows and 6 columns.

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

252       +PROC SORT; BY award_budg;
253       +

NOTE: There were 1917 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.AWARD1 has 1917 observations and 6 variables.
NOTE: Compressing data set WORK.AWARD1 decreased size by 76.12 percent. 
      Compressed is 16 pages; un-compressed would require 67 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

254       +DATA MRG2; MERGE setspons(IN=A) AWARD1(IN=B); BY award_budg; IF A AND B;
255       +format TASK 2.;
256       +task = substr(task_number,3,2);

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      256:8   
NOTE: There were 3038 observations read from the data set WORK.SETSPONS.
NOTE: There were 1917 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.MRG2 has 2734 observations and 19 variables.
NOTE: Compressing data set WORK.MRG2 decreased size by 72.68 percent. 
      Compressed is 50 pages; un-compressed would require 183 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

                                                                 The SAS System

257       +PROC SORT; BY award_budg;
258       +
259       +/*PROC SQL;
260       +CREATE TABLE LEADPI AS
261       +SELECT EMPLOYEE_ID AS WD_PIID,
262       +ORG_ID AS GRANT_ID,
263       +ROLE_NAME AS ROLE1
264       +FROM WDM.WORKER_ROLE
265       +WHERE role_name = 'Principal_Investigator';
266       +PROC SORT; BY WD_PIID;
267       +
268       +PROC SQL;
269       +CREATE TABLE LSUPIID AS
270       +SELECT EMPLOYEE_ID AS WD_PIID,
271       +LSU_ID AS LSU_PIID
272       +FROM WDM.KEYS;
273       +PROC SORT; BY WD_PIID;
274       +
275       +DATA MRGPI;
276       +MERGE LEADPI(IN=A) LSUPIID(IN=B); BY WD_PIID; IF A;
277       +PROC SORT; BY GRANT_ID;
278       +
279       +DATA MRG3; MERGE MRG2(IN=A) MRGPI(IN=B); BY GRANT_ID; IF A;
280       +PROC SORT; BY GRANT_ID;
281       +
282       +PROC SQL;
283       +CREATE TABLE COPI AS
284       +SELECT EMPLOYEE_ID AS WD_COPIID,
285       +ORG_ID AS GRANT_ID,
286       +ROLE_NAME AS ROLE2
287       +FROM WDM.WORKER_ROLE
288       +WHERE role_name = 'Co-Principal_Investigator';
289       +PROC SORT; BY WD_COPIID;
290       +
291       +PROC SQL;
292       +CREATE TABLE LSUCOPIID AS
293       +SELECT EMPLOYEE_ID AS WD_COPIID,
294       +LSU_ID AS LSU_COPIID
                                                                 The SAS System

295       +FROM WDM.KEYS;
296       +PROC SORT; BY WD_COPIID;
297       +
298       +DATA MRGCOPI;
299       +MERGE COPI(IN=A) LSUCOPIID(IN=B); BY WD_COPIID; IF A;
300       +PROC SORT; BY GRANT_ID;
301       +
302       +DATA MRG4; MERGE MRG3(IN=A) MRGCOPI(IN=B); BY GRANT_ID; IF A;
303       +PROC SORT; BY AWARD_NUMBER;*/
304       +

NOTE: There were 2734 observations read from the data set WORK.MRG2.
NOTE: The data set WORK.MRG2 has 2734 observations and 19 variables.
NOTE: Compressing data set WORK.MRG2 decreased size by 72.68 percent. 
      Compressed is 50 pages; un-compressed would require 183 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

305       +proc sql;
306       +CREATE TABLE SPEC AS
307       +SELECT AWARD_NUMBER as award_budg,
308       +REF_ID
309       +FROM WDM.FIN_AWD_SPEC_COND
310       +WHERE REF_ID = 'Special_Condition_Type_Internal_Competition';
NOTE: Compressing data set WORK.SPEC decreased size by 0.00 percent. 
      Compressed is 2 pages; un-compressed would require 2 pages.
NOTE: Table WORK.SPEC created, with 52 rows and 2 columns.

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

311       +PROC SORT; BY award_budg;
312       +

                                                                 The SAS System

NOTE: There were 52 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.SPEC has 52 observations and 2 variables.
NOTE: Compressing data set WORK.SPEC decreased size by 0.00 percent. 
      Compressed is 2 pages; un-compressed would require 2 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

313       +DATA MRG5; MERGE MRG2(IN=A) SPEC(IN=B); BY award_budg; IF A;

NOTE: There were 2734 observations read from the data set WORK.MRG2.
NOTE: There were 52 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.MRG5 has 2734 observations and 20 variables.
NOTE: Compressing data set WORK.MRG5 decreased size by 78.17 percent. 
      Compressed is 50 pages; un-compressed would require 229 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

314       +PROC SORT; BY award_budg grant_id;
315       +

NOTE: There were 2734 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.MRG5 has 2734 observations and 20 variables.
NOTE: Compressing data set WORK.MRG5 decreased size by 78.17 percent. 
      Compressed is 50 pages; un-compressed would require 229 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

316       +data setmrg5; set mrg5; by award_budg grant_id;
317       +if first.grant_id then output;

NOTE: There were 2734 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.SETMRG5 has 2734 observations and 20 variables.
                                                                 The SAS System

NOTE: Compressing data set WORK.SETMRG5 decreased size by 78.17 percent. 
      Compressed is 50 pages; un-compressed would require 229 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

318       +proc sort; by award_budg grant_id;
319       +
320       +
321       +/*PROC SQL;
322       + CREATE TABLE SPAFILE AS
323       + SELECT ACCT_CODE       AS ACCT
324       +       ,BEGIN_DATE      AS BEGIN
325       +       ,INIT_TIMESTAMP  AS IADD
326       +       ,LONG_TITLE      AS LONG
327       +FROM COA.ACCOUNTS
328       +WHERE CAMPUS_CD = '1' AND ACCT_TYPE = 'S'
329       +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6')
330       +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
331       +'190067') AND FISCAL_YEAR = &FYEAR;
332       +
333       +PROC SORT; BY ACCT;
334       +
335       +DATA COAS;
336       +  MERGE COAFILE(IN=A) SPAFILE(IN=B);
337       +  BY ACCT;
338       +  IF A AND B;
339       +
340       +PROC SORT DATA = COAS;  BY ACCT;
341       +
342       +DATA COA1(KEEP=STITLE LONG ACCT AGENCY EXPIRE BEGIN ADDTE TOTAWARD
343       +          PIID COPIID PROPNBR INTFLAG TASK);
344       + SET COAS;
345       +  FORMAT STITLE $60.;
346       +  FORMAT ADATE YYMMDDN8.;
347       +  ADATE = DATEPART(IADD);
348       +  FORMAT BEGIN YYMMDDN8.;
                                                                 The SAS System

349       +  FORMAT EXPIRE YYMMDDN8.;
350       +  FORMAT BEGINX $8.;
351       +  BEGINX = INPUT(PUT(BEGIN,8.),$8.);
352       +  FORMAT DPT $5.;
353       +  DPT = SUBSTR(ACCT,1,5);
354       +  AYR = YEAR(ADATE);
355       +  AMTH= MONTH(ADATE);
356       +    MONA = INPUT(PUT(AMTH,Z2.),$2.);
357       +    YEARA = INPUT(PUT(AYR,4.),$4.);
358       +  ADDTE = YEARA||MONA;
359       +BEGINZ = INPUT(PUT(BEGIN,Z8.),8.);
360       +  IF BEGINZ <= &EFFDTE;*/
361       +

NOTE: There were 2734 observations read from the data set WORK.SETMRG5.
NOTE: The data set WORK.SETMRG5 has 2734 observations and 20 variables.
NOTE: Compressing data set WORK.SETMRG5 decreased size by 78.17 percent. 
      Compressed is 50 pages; un-compressed would require 229 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

362       +PROC SQL;
363       +CREATE TABLE BUDG AS
364       +SELECT grant_id,
365       +grant_name,
366       +ledger_account,
367       +budget_revenue as AMT,
368       +budget_obj,
369       +award_name,
370       +award_report_code as BAADJCD,
371       +budget_amendment_date,
372       +budget_date_from
373       +from workday.award_budget
374       +where ledger_account in ('4200:Federal Grants and Contracts Revenue','4210:State and Local Grants and Contracts Revenue',
375       +'4220:Non-governmental Grants and Contracts Revenue','4230:Grants and Contracts Revenue') and budget_amendment_status not in
375      !+('Canceled','Draft','Denied')
                                                                 The SAS System

376       +and company_code = 'LSUAM' and
377       +award_report_code in ('New','Continuation') ;
NOTE: Compressing data set WORK.BUDG decreased size by 63.53 percent. 
      Compressed is 31 pages; un-compressed would require 85 pages.
NOTE: Table WORK.BUDG created, with 1349 rows and 9 columns.

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

378       +proc sort; by grant_id;
379       +

NOTE: There were 1349 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.BUDG has 1349 observations and 9 variables.
NOTE: Compressing data set WORK.BUDG decreased size by 63.53 percent. 
      Compressed is 31 pages; un-compressed would require 85 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

380       +data set1; set budg; by grant_id;
381       +format BUDGET_DATE1 yymmddn.;
382       +budget_date1 = budget_amendment_date;
383       +award_budg = scan(budget_obj,1,":");

NOTE: There were 1349 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.SET1 has 1349 observations and 11 variables.
NOTE: Compressing data set WORK.SET1 decreased size by 68.27 percent. 
      Compressed is 33 pages; un-compressed would require 104 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

384       +proc sort; by award_budg grant_id;
                                                                 The SAS System

385       +

NOTE: There were 1349 observations read from the data set WORK.SET1.
NOTE: The data set WORK.SET1 has 1349 observations and 11 variables.
NOTE: Compressing data set WORK.SET1 decreased size by 68.27 percent. 
      Compressed is 33 pages; un-compressed would require 104 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

386       +data MARGE; merge mrg5(in=a) set1(in=b); by award_budg grant_id; if a and b;
387       +format budget_date yymmddn.;
388       +if budget_date1 = ' ' then budget_date = signed_date; else budget_date = budget_date1;
389       +if budget_date = ' ' then delete;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      388:19   389:18   
WARNING: Multiple lengths were specified for the BY variable award_budg by input data sets. This may cause unexpected results.
NOTE: There were 2734 observations read from the data set WORK.MRG5.
NOTE: There were 1349 observations read from the data set WORK.SET1.
NOTE: The data set WORK.MARGE has 1346 observations and 29 variables.
NOTE: Compressing data set WORK.MARGE decreased size by 71.60 percent. 
      Compressed is 48 pages; un-compressed would require 169 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

390       +proc sort; by grant_id budget_date;
391       +

NOTE: There were 1346 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE has 1346 observations and 29 variables.
NOTE: Compressing data set WORK.MARGE decreased size by 71.60 percent. 
      Compressed is 48 pages; un-compressed would require 169 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
                                                                 The SAS System

      cpu time            0.01 seconds
      

392       +data marge1; set marge; by grant_id budget_date;
393       +effdte = INPUT(PUT(budget_date,yymmddn.),8.);
394       +agency = substr(agency,14,25);
395       +*if effdte <= 20160930 then output;

NOTE: There were 1346 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE1 has 1346 observations and 30 variables.
NOTE: Compressing data set WORK.MARGE1 decreased size by 72.19 percent. 
      Compressed is 47 pages; un-compressed would require 169 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

396       +proc sort; by grant_id;
397       +
398       +
399       +
400       +
401       +/*DATA GLSD;
402       +  INFILE GLSD;
403       +  INPUT  @1   FY       $2.
404       +         @3   ENTRY   PD5.
405       +         @10  ACCT       $9.
406       +         @19  TT         $1.
407       +         @20  OBJ      $4.
408       +         @24  SUBOBJ   $1.
409       +         @29  AMT        PD6.2
410       +         @168 BAADJCD  $1.;
411       +  IF TT = 'I' AND SUBSTR(ACCT,1,1) = '1' AND
412       +    SUBSTR(ACCT,6,1) IN ('4','5','6') AND FY = &FYR
413       +    AND BAADJCD IN ('N','C');
414       +  IF AMT = 0 THEN DELETE;
415       +  SOURCE = SUBSTR(ACCT,6,1);
416       +
                                                                 The SAS System

417       +PROC SORT; BY SOURCE;
418       +
419       +DATA GLST;  SET GLSD;  BY SOURCE;
420       +FORMAT SF $7.;
421       +IF SOURCE = '3' THEN SF = 'FED AP ';
422       +IF SOURCE = '4' THEN SF = 'STATE';
423       +IF SOURCE = '5' THEN SF = 'FEDERAL';
424       +IF SOURCE = '6' THEN SF = 'PRIVATE';
425       +CALL SYMPUT('SF',SF);
426       +
427       +PROC SORT DATA=GLST; BY FY ENTRY;
428       +
429       +DATA GLSUSRS;
430       +  INFILE GLSUSR;
431       +   INPUT  @   1  FY        $2.
432       +          @   3  ENTRY     PD5.
433       +          @   8  ENTRYTYP  $2.
434       +          @  57  VCHRTYPE  $2.
435       +          @  64  EFFDTE    PD5.
436       +          @  69  STATUS    $1.;
437       +          IF STATUS = 'C';
438       +          IF FY = &FYR ;
439       +          IF ENTRYTYP = 'GE';
440       +
441       +PROC SORT DATA=GLSUSRS;  BY FY ENTRY;
442       +
443       +DATA GLS;
444       +  MERGE GLSUSRS(IN=A) GLST(IN=B);
445       +  BY FY ENTRY;
446       +  IF A AND B;
447       +
448       +PROC SORT; BY ACCT;
449       +
450       +DATA GLSCOA;
451       +  MERGE COA1(IN=A) GLS(IN=B);
452       +  BY ACCT;
453       +  IF A AND B;
454       +
                                                                 The SAS System

455       +PROC SORT DATA = GLSCOA;  BY FY ACCT ENTRY;*/
456       +

NOTE: There were 1346 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.MARGE1 has 1346 observations and 30 variables.
NOTE: Compressing data set WORK.MARGE1 decreased size by 72.19 percent. 
      Compressed is 47 pages; un-compressed would require 169 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

457       +DATA budg1 (DROP= EMTH ENDYRX BEGYRX END BEG);
458       + SET marge1; by grant_id effdte;
459       + * BY FY ACCT ENTRY;
460       +  EDATE = INPUT(PUT(EFFDTE,8.),YYMMDD8.);
461       +  EMTH= MONTH(EDATE);
462       +
463       +  IF EFFDTE <= &EFFDTE and effdte >= &begdte1;
SYMBOLGEN:  Macro variable EFFDTE resolves to 20170731
SYMBOLGEN:  Macro variable BEGDTE1 resolves to     20170701
464       +
465       +  EMNX = INPUT(PUT(EMTH,Z2.),$2.);
466       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 18
467       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
468       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
469       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
470       +  IF EMTH > 6 THEN ACTDTE = BEG||EMNX;
471       +   ELSE ACTDTE = END||EMNX;
472       +
473       +  IF EMNX = &EFFMN THEN MONAMT = AMT;
SYMBOLGEN:  Macro variable EFFMN resolves to 07      
474       +  ELSE MONAMT = 0;
475       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
                                                                 The SAS System

      473:6   
NOTE: There were 1346 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.BUDG1 has 70 observations and 34 variables.
NOTE: Compressing data set WORK.BUDG1 decreased size by 63.64 percent. 
      Compressed is 4 pages; un-compressed would require 11 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

476       +PROC SORT DATA = budg1; BY ACTDTE grant_id;
477       +

NOTE: There were 70 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.BUDG1 has 70 observations and 34 variables.
NOTE: Compressing data set WORK.BUDG1 decreased size by 63.64 percent. 
      Compressed is 4 pages; un-compressed would require 11 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

478       +DATA GLSCOA15(DROP=AMT MONAMT); SET budg1;
479       + BY ACTDTE grant_id;
480       + IF FIRST.grant_id THEN DO; *MTHAMT = MONAMT; *TOTAMT = AMT; *END;
481       +      IF BAADJCD = 'New' THEN DO;
482       +               NMTHAMT = MONAMT; CMTHAMT = 0;
483       +               NTOTAMT = AMT;    CTOTAMT = 0; END;
484       +      IF BAADJCD = 'Continuation' THEN DO;
485       +               CMTHAMT = MONAMT; NMTHAMT = 0;
486       +               CTOTAMT = AMT;    NTOTAMT = 0; END;
487       + END;
488       + ELSE DO;
489       +      IF BAADJCD = 'New' THEN DO;
490       +               NMTHAMT + MONAMT; CMTHAMT + 0;
491       +               NTOTAMT + AMT;    CTOTAMT + 0; END;
492       +      IF BAADJCD = 'Continuation' THEN DO;
493       +               CMTHAMT + MONAMT; NMTHAMT + 0;
                                                                 The SAS System

494       +               CTOTAMT + AMT;    NTOTAMT + 0; END;
495       + END;
496       + *ELSE DO; *MTHAMT + MONAMT; *TOTAMT + AMT; *END;
497       + IF LAST.grant_id THEN OUTPUT;
498       +

NOTE: There were 70 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 66 observations and 36 variables.
NOTE: Compressing data set WORK.GLSCOA15 decreased size by 60.00 percent. 
      Compressed is 4 pages; un-compressed would require 10 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

499       +PROC SQL;
500       +  CREATE TABLE PROJTRAN AS
501       +SELECT PROPOSAL_NBR     AS PROPNBR
502       +      ,TRX_NBR          AS TRXNBR
503       +      ,TRX_TYPE         AS TRXTYPE
504       +      ,TRX_STATUS       AS TRXSTAT
505       +      ,TO_SPA_DATE      AS RELDATE
506       +FROM SPM.PROJ_TRANSACTION
507       + WHERE TRX_STATUS IN ('AC','TE','CO');
NOTE: Compressing data set WORK.PROJTRAN decreased size by 1.39 percent. 
      Compressed is 142 pages; un-compressed would require 144 pages.
NOTE: Table WORK.PROJTRAN created, with 18085 rows and 5 columns.

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

509       + PROC SORT; BY PROPNBR TRXNBR RELDATE;
510       +

NOTE: There were 18085 observations read from the data set WORK.PROJTRAN.
                                                                 The SAS System

NOTE: The data set WORK.PROJTRAN has 18085 observations and 5 variables.
NOTE: Compressing data set WORK.PROJTRAN decreased size by 1.39 percent. 
      Compressed is 142 pages; un-compressed would require 144 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

511       +DATA SPS2;
512       + SET PROJTRAN; BY PROPNBR TRXNBR;
513       +    LENGTH MO YY $2.;
514       +    LENGTH YR $4.;
515       +    MO=MONTH(RELDATE);
516       +    YR=YEAR(RELDATE);
517       +    YY=SUBSTR(YR,3,2);
518       +    LENGTH EFFMY $4.;
519       +    EFFMY=YY||MO;
520       +    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).
      515:8   516: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 515:8   212 at 516:8   
NOTE: There were 18085 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.SPS2 has 18085 observations and 9 variables.
NOTE: Compressing data set WORK.SPS2 increased size by 8.33 percent. 
      Compressed is 195 pages; un-compressed would require 180 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

521       +    PROC SORT; BY PROPNBR EFFMY RELDATE;
522       +

NOTE: There were 18085 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 18085 observations and 9 variables.
                                                                 The SAS System

NOTE: Compressing data set WORK.SPS2 increased size by 8.33 percent. 
      Compressed is 195 pages; un-compressed would require 180 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

523       + PROC SORT; BY PROPNBR TRXNBR;
524       +

NOTE: There were 18085 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 18085 observations and 9 variables.
NOTE: Compressing data set WORK.SPS2 increased size by 8.33 percent. 
      Compressed is 195 pages; un-compressed would require 180 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

525       +PROC SQL;
526       +    CREATE TABLE PISHR AS
527       +    SELECT PROPOSAL_NBR    AS PROPNBR,
528       +           TRX_NBR         AS TRXNBR,
529       +           TASK_NBR        AS TASK,
530       +           LSU_ID          AS LSUID,
531       +           INVESTIGATOR_TYPE AS INVTYPE,
532       +           DEPT_CD         AS DEPT,
533       +           PROJECT_SHARE   AS SHARE
534       +    FROM SPM.PROJ_INVESTIGATOR
535       +    WHERE PROJECT_SHARE > 0;
NOTE: Compressing data set WORK.PISHR decreased size by 6.66 percent. 
      Compressed is 827 pages; un-compressed would require 886 pages.
NOTE: Table WORK.PISHR created, with 74364 rows and 7 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.18 seconds
      cpu time            0.12 seconds
      
                                                                 The SAS System


536       +    PROC SORT; BY PROPNBR TRXNBR TASK;
537       +

NOTE: There were 74364 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.PISHR has 74364 observations and 7 variables.
NOTE: Compressing data set WORK.PISHR decreased size by 6.55 percent. 
      Compressed is 828 pages; un-compressed would require 886 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.07 seconds
      cpu time            0.07 seconds
      

538       +DATA SPS4;
539       +  MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
540       +

NOTE: There were 18085 observations read from the data set WORK.SPS2.
NOTE: There were 74364 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.SPS4 has 31770 observations and 14 variables.
NOTE: Compressing data set WORK.SPS4 decreased size by 7.22 percent. 
      Compressed is 527 pages; un-compressed would require 568 pages.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

541       +PROC SORT;  BY PROPNBR EFFMY RELDATE;
542       +

NOTE: There were 31770 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31770 observations and 14 variables.
NOTE: Compressing data set WORK.SPS4 decreased size by 7.22 percent. 
      Compressed is 527 pages; un-compressed would require 568 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      
                                                                 The SAS System


543       +    PROC SORT; BY PROPNBR TRXNBR;
544       +

NOTE: There were 31770 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31770 observations and 14 variables.
NOTE: Compressing data set WORK.SPS4 decreased size by 7.22 percent. 
      Compressed is 527 pages; un-compressed would require 568 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

545       +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
546       +     SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
547       +     SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
548       +     SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
549       +     SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
550       +     SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
551       +     SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
552       +     SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
553       +     SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
554       +     SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
555       +     SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
556       +     SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
557       +     SET SPS4;
558       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 18
559       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
560       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
561       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
562       +     IF (YY=&BEGYR AND MO <= 07) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable BEGYR resolves to 17
563       +         ACTDTE = BEG||'07';
564       +         OUTPUT SPSFM1;
565       +         END;
                                                                 The SAS System

566       +     IF (YY=&BEGYR AND MO <= 08) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable BEGYR resolves to 17
567       +         ACTDTE = BEG||'08';
568       +         OUTPUT SPSFM2;
569       +         END;
570       +     IF (YY=&BEGYR AND MO <= 09) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable BEGYR resolves to 17
571       +         ACTDTE = BEG||'09';
572       +         OUTPUT SPSFM3;
573       +         END;
574       +     IF (YY=&BEGYR AND MO <= 10) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable BEGYR resolves to 17
575       +         ACTDTE = BEG||'10';
576       +         OUTPUT SPSFM4;
577       +         END;
578       +     IF (YY=&BEGYR AND MO <= 11) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable BEGYR resolves to 17
579       +         ACTDTE = BEG||'11';
580       +         OUTPUT SPSFM5;
581       +         END;
582       +     IF (YY=&BEGYR AND MO <= 12) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable BEGYR resolves to 17
583       +         ACTDTE = BEG||'12';
584       +         OUTPUT SPSFM6;
585       +         END;
586       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 1) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable ENDYR resolves to 18
587       +         ACTDTE = END||'01';
588       +         OUTPUT SPSFM7;
589       +         END;
590       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 2) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
                                                                 The SAS System

SYMBOLGEN:  Macro variable ENDYR resolves to 18
591       +         ACTDTE = END||'02';
592       +         OUTPUT SPSFM8;
593       +         END;
594       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 3) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable ENDYR resolves to 18
595       +         ACTDTE = END||'03';
596       +         OUTPUT SPSFM9;
597       +         END;
598       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=4) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable ENDYR resolves to 18
599       +         ACTDTE = END||'04';
600       +         OUTPUT SPSFM10;
601       +         END;
602       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=5) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable ENDYR resolves to 18
603       +         ACTDTE = END||'05';
604       +         OUTPUT SPSFM11;
605       +         END;
606       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=6) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable ENDYR resolves to 18
607       +         ACTDTE = END||'06';
608       +         OUTPUT SPSFM12;
609       +         END;
610       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      562:10   562:24   562:37   566:10   566:24   566:37   570:10   570:24   570:37   574:10   574:24   574:37   578:10   578:24   578:37
      582:10   582:24   582:37   586:9    586:26   586:40   590:9    590:26   590:40   594:9    594:26   594:40   598:9    598:26   598:40
      602:9    602:26   602:40   606:9    606:26   606:40   
NOTE: There were 31770 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPSFM1 has 31172 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM1 decreased size by 12.72 percent. 
      Compressed is 487 pages; un-compressed would require 558 pages.
                                                                 The SAS System

NOTE: The data set WORK.SPSFM2 has 31351 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM2 decreased size by 12.66 percent. 
      Compressed is 490 pages; un-compressed would require 561 pages.
NOTE: The data set WORK.SPSFM3 has 31503 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM3 decreased size by 12.59 percent. 
      Compressed is 493 pages; un-compressed would require 564 pages.
NOTE: The data set WORK.SPSFM4 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM4 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM5 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM5 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM6 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM6 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM7 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM7 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM8 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM8 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM9 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM9 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM10 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM10 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM11 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM11 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: The data set WORK.SPSFM12 has 31759 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM12 decreased size by 12.50 percent. 
      Compressed is 497 pages; un-compressed would require 568 pages.
NOTE: DATA statement used (Total process time):
      real time           0.26 seconds
      cpu time            0.26 seconds
      

                                                                 The SAS System

611       +DATA SPS6;
612       +    SET SPSFM1
613       +        SPSFM2
614       +        SPSFM3
615       +        SPSFM4
616       +        SPSFM5
617       +        SPSFM6
618       +        SPSFM7
619       +        SPSFM8
620       +        SPSFM9
621       +        SPSFM10
622       +        SPSFM11
623       +        SPSFM12;

NOTE: There were 31172 observations read from the data set WORK.SPSFM1.
NOTE: There were 31351 observations read from the data set WORK.SPSFM2.
NOTE: There were 31503 observations read from the data set WORK.SPSFM3.
NOTE: There were 31759 observations read from the data set WORK.SPSFM4.
NOTE: There were 31759 observations read from the data set WORK.SPSFM5.
NOTE: There were 31759 observations read from the data set WORK.SPSFM6.
NOTE: There were 31759 observations read from the data set WORK.SPSFM7.
NOTE: There were 31759 observations read from the data set WORK.SPSFM8.
NOTE: There were 31759 observations read from the data set WORK.SPSFM9.
NOTE: There were 31759 observations read from the data set WORK.SPSFM10.
NOTE: There were 31759 observations read from the data set WORK.SPSFM11.
NOTE: There were 31759 observations read from the data set WORK.SPSFM12.
NOTE: The data set WORK.SPS6 has 379857 observations and 12 variables.
NOTE: Compressing data set WORK.SPS6 decreased size by 12.91 percent. 
      Compressed is 5908 pages; un-compressed would require 6784 pages.
NOTE: DATA statement used (Total process time):
      real time           0.32 seconds
      cpu time            0.31 seconds
      

624       +    PROC SORT; BY PROPNBR ACTDTE TRXNBR EFFMY;
625       +
626       +

                                                                 The SAS System

NOTE: There were 379857 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS6 has 379857 observations and 12 variables.
NOTE: Compressing data set WORK.SPS6 decreased size by 12.84 percent. 
      Compressed is 5913 pages; un-compressed would require 6784 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.34 seconds
      cpu time            0.46 seconds
      

627       +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
628       +  SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
629       +    IF LAST.ACTDTE THEN OUTPUT SPS7X;
630       +

NOTE: There were 379857 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7X has 92744 observations and 3 variables.
NOTE: Compressing data set WORK.SPS7X increased size by 6.69 percent. 
      Compressed is 590 pages; un-compressed would require 553 pages.
NOTE: DATA statement used (Total process time):
      real time           0.18 seconds
      cpu time            0.18 seconds
      

631       +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
632       +

NOTE: There were 92744 observations read from the data set WORK.SPS7X.
NOTE: The data set WORK.SPS7X has 92744 observations and 3 variables.
NOTE: Compressing data set WORK.SPS7X increased size by 6.69 percent. 
      Compressed is 590 pages; un-compressed would require 553 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.06 seconds
      cpu time            0.06 seconds
      

633       +DATA SPS7;
634       + MERGE SPS7X(IN=A) SPS6(IN=B);
635       + BY PROPNBR ACTDTE TRXNBR;
                                                                 The SAS System

636       + IF A AND B;
637       +

NOTE: There were 92744 observations read from the data set WORK.SPS7X.
NOTE: There were 379857 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7 has 135749 observations and 12 variables.
NOTE: Compressing data set WORK.SPS7 decreased size by 12.99 percent. 
      Compressed is 2110 pages; un-compressed would require 2425 pages.
NOTE: DATA statement used (Total process time):
      real time           0.26 seconds
      cpu time            0.26 seconds
      

638       +PROC SORT DATA = SPS7;  BY LSUID;
639       +

NOTE: There were 135749 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS7 has 135749 observations and 12 variables.
NOTE: Compressing data set WORK.SPS7 decreased size by 12.99 percent. 
      Compressed is 2110 pages; un-compressed would require 2425 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.12 seconds
      cpu time            0.17 seconds
      

640       +PROC SQL;
641       +  CREATE TABLE DIRFILE AS
642       + SELECT INDIV_NAME     AS PI
643       +       ,LSU_ID         AS LSUID
644       + FROM DIR.NAME;
NOTE: Compressing data set WORK.DIRFILE decreased size by 1.52 percent. 
      Compressed is 12522 pages; un-compressed would require 12715 pages.
NOTE: Table WORK.DIRFILE created, with 1169670 rows and 2 columns.

645       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           2.48 seconds
      cpu time            1.49 seconds
                                                                 The SAS System

      

646       +PROC SORT; BY LSUID;
647       +

NOTE: There were 1169670 observations read from the data set WORK.DIRFILE.
NOTE: The data set WORK.DIRFILE has 1169670 observations and 2 variables.
NOTE: Compressing data set WORK.DIRFILE decreased size by 1.52 percent. 
      Compressed is 12522 pages; un-compressed would require 12715 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.73 seconds
      cpu time            1.03 seconds
      

648       +DATA SPS8(KEEP=PI LSUID DEPT PROPNBR ACTDTE SHARE TASK INVTYPE);
649       +  MERGE DIRFILE(IN=A) SPS7(IN=B);
650       +  BY LSUID;
651       +  IF B;
652       +
653       +/*PROC SQL;
654       +CREATE TABLE CODES AS
655       +SELECT CODE_TYPE AS CDTYPE
656       +      ,CODE_VALUE AS CODE
657       +      ,CODE_DESC AS CODENAME
658       +FROM COA.CODES
659       +WHERE CODE_TYPE = 'DA';
660       +
661       +PROC SORT DATA = CODES;
662       +  BY CODE;
663       +
664       +DATA NAMES(KEEP=DPT DPTNAME) COLNAME(KEEP=COLLEGE COLNAME);
665       + SET CODES;
666       +FORMAT COLLEGE DPT $5.;
667       +FORMAT COLNAME DPTNAME $35.;
668       + IF SUBSTR(CODE,4,2) = '  ' THEN DO;
669       +  COLLEGE = CODE;
670       +  COLNAME = CODENAME;
671       +  OUTPUT COLNAME;
                                                                 The SAS System

672       + END;
673       + ELSE DO;
674       + IF SUBSTR(CODE,4,1) NOT = ' ' AND SUBSTR(CODE,5,1) = ' ' THEN DELETE;
675       +  DPT = CODE;
676       +  DPTNAME = CODENAME;
677       +  OUTPUT NAMES;
678       + END;
679       +
680       +PROC SORT DATA = NAMES;
681       +  BY DPT;
682       +
683       +PROC SORT DATA = SPS8;
684       +  BY DPT;
685       +
686       +DATA SPS9;
687       + MERGE NAMES(IN=A) SPS8(IN=B);
688       + BY DPT;
689       + IF B;
690       +  FORMAT DPTNAME $35.;
691       +  FORMAT COL $3.;
692       +  COL = SUBSTR(DPT,1,3);
693       +  COL1 = COL||'  ';
694       +  FORMAT COLLEGE $5.;
695       +  COLLEGE = COMPRESS(COL1);
696       +
697       +PROC SORT DATA = SPS9;
698       +  BY COLLEGE;
699       +
700       +PROC SORT DATA = COLNAME;
701       +  BY COLLEGE;
702       +
703       +DATA SPS10;
704       + MERGE COLNAME(IN=A) SPS9(IN=B);
705       + BY COLLEGE;
706       + IF B;
707       +
708       +PROC SORT DATA = SPS10;
709       + BY PROPNBR ACTDTE TASK;*/
                                                                 The SAS System

710       +
711       +

NOTE: There were 1169670 observations read from the data set WORK.DIRFILE.
NOTE: There were 135749 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS8 has 135749 observations and 8 variables.
NOTE: Compressing data set WORK.SPS8 decreased size by 19.41 percent. 
      Compressed is 1084 pages; un-compressed would require 1345 pages.
NOTE: DATA statement used (Total process time):
      real time           0.49 seconds
      cpu time            0.49 seconds
      

712       +  proc sql;
713       +  create table ccdept as
714       +  select code_value1 as dept,
715       +  code_value2 as CC
716       +  from spm.codes
717       +where code_type = 'CCDEPT';
NOTE: Compressing data set WORK.CCDEPT increased size by 14.29 percent. 
      Compressed is 16 pages; un-compressed would require 14 pages.
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.00 seconds
      

718       +proc sort; by  dept;
719       +

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: Compressing data set WORK.CCDEPT increased size by 14.29 percent. 
      Compressed is 16 pages; un-compressed would require 14 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
                                                                 The SAS System

      

720       +PROC SORT DATA = SPS8;
721       + BY dept;
722       +

NOTE: There were 135749 observations read from the data set WORK.SPS8.
NOTE: The data set WORK.SPS8 has 135749 observations and 8 variables.
NOTE: Compressing data set WORK.SPS8 decreased size by 19.41 percent. 
      Compressed is 1084 pages; un-compressed would require 1345 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.10 seconds
      cpu time            0.15 seconds
      

723       +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 135749 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 135749 observations and 9 variables.
NOTE: Compressing data set WORK.MRGCC decreased size by 17.68 percent. 
      Compressed is 1215 pages; un-compressed would require 1476 pages.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.12 seconds
      

724       +proc sort; by cc;
725       +

NOTE: There were 135749 observations read from the data set WORK.MRGCC.
NOTE: The data set WORK.MRGCC has 135749 observations and 9 variables.
NOTE: Compressing data set WORK.MRGCC decreased size by 17.68 percent. 
      Compressed is 1215 pages; un-compressed would require 1476 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.12 seconds
      cpu time            0.18 seconds
                                                                 The SAS System

      

726       +proc sql;
727       +create table org as
728       +select org_id as CC,
729       +org_name as Cost_Center,
730       +superior_org as CC_Hier
731       +from wdm.organization
732       +where org_type = 'Cost_Center';
NOTE: Compressing data set WORK.ORG decreased size by 88.24 percent. 
      Compressed is 8 pages; un-compressed would require 68 pages.
NOTE: Table WORK.ORG created, with 1079 rows and 3 columns.

NOTE: PROCEDURE SQL used (Total process time):
      real time           0.01 seconds
      cpu time            0.00 seconds
      

733       +proc sort;  BY CC;
734       +

NOTE: There were 1079 observations read from the data set WORK.ORG.
NOTE: The data set WORK.ORG has 1079 observations and 3 variables.
NOTE: Compressing data set WORK.ORG decreased size by 88.24 percent. 
      Compressed is 8 pages; un-compressed would require 68 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

735       +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 135749 observations read from the data set WORK.MRGCC.
NOTE: There were 1079 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 135749 observations and 11 variables.
NOTE: Compressing data set WORK.MRGCC2 decreased size by 81.27 percent. 
      Compressed is 1338 pages; un-compressed would require 7145 pages.
                                                                 The SAS System

NOTE: DATA statement used (Total process time):
      real time           0.21 seconds
      cpu time            0.21 seconds
      

736       +proc sort;  BY CC_Hier;
737       +

NOTE: There were 135749 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 135749 observations and 11 variables.
NOTE: Compressing data set WORK.MRGCC2 decreased size by 81.27 percent. 
      Compressed is 1338 pages; un-compressed would require 7145 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.29 seconds
      cpu time            0.42 seconds
      

738       +proc sql;
739       +create table org as
740       +select org_id as CC_Hier,
741       +org_name as Cost_Center_Hierarchy
742       +from wdm.organization
743       +where org_type = 'Cost_Center_Hierarchy';
NOTE: Compressing data set WORK.ORG decreased size by 75.00 percent. 
      Compressed is 2 pages; un-compressed would require 8 pages.
NOTE: Table WORK.ORG created, with 149 rows and 2 columns.

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

744       +proc sort;  BY CC_Hier;
745       +

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: Compressing data set WORK.ORG decreased size by 75.00 percent. 
                                                                 The SAS System

      Compressed is 2 pages; un-compressed would require 8 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

746       +data mrgcc2; merge mrgcc2(in=a) org(in=b); by CC_Hier; if a;
747       +Cost_Center_Hierarchy = scan(Cost_Center_Hierarchy,-1,'|');
748       +Cost_Center = scan(Cost_Center,-1,'|');

NOTE: There were 135749 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 135749 observations and 12 variables.
NOTE: Compressing data set WORK.MRGCC2 decreased size by 87.68 percent. 
      Compressed is 1394 pages; un-compressed would require 11313 pages.
NOTE: DATA statement used (Total process time):
      real time           0.39 seconds
      cpu time            0.39 seconds
      

749       +proc sort;  BY PROPNBR ACTDTE TASK;
750       +

NOTE: There were 135749 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 135749 observations and 12 variables.
NOTE: Compressing data set WORK.MRGCC2 decreased size by 87.68 percent. 
      Compressed is 1394 pages; un-compressed would require 11313 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.38 seconds
      cpu time            0.51 seconds
      

751       +PROC SORT DATA = GLSCOA15;
752       + BY PROPNBR ACTDTE TASK;
753       +

NOTE: There were 66 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA15 has 66 observations and 36 variables.
                                                                 The SAS System

NOTE: Compressing data set WORK.GLSCOA15 decreased size by 60.00 percent. 
      Compressed is 4 pages; un-compressed would require 10 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

754       +PROC SQL;
755       + CREATE TABLE GLSSPS1 AS
756       + SELECT A.*,
757       +        B.PI,
758       +        B.LSUID,
759       +        B.INVTYPE,
760       +        B.SHARE,
761       +        B.Cost_Center_Hierarchy,
762       +        B.CC,
763       +        B.Cost_Center
764       +FROM GLSCOA15 A,
765       +     mrgcc2  B
766       +WHERE A.PROPNBR = B.PROPNBR AND
767       +      A.ACTDTE  = B.ACTDTE AND
768       +      A.TASK    = B.TASK;
NOTE: Compressing data set WORK.GLSSPS1 decreased size by 71.43 percent. 
      Compressed is 6 pages; un-compressed would require 21 pages.
NOTE: Table WORK.GLSSPS1 created, with 99 rows and 43 columns.

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

771       +DATA GLSSPS10(KEEP=PROPNBR ACTDTE); SET GLSSPS1; BY PROPNBR ACTDTE;
772       + IF FIRST.ACTDTE THEN OUTPUT;
773       +

NOTE: Compression was disabled for data set WORK.GLSSPS10 because compression overhead would increase the size of the data set.
                                                                 The SAS System

NOTE: There were 99 observations read from the data set WORK.GLSSPS1.
NOTE: The data set WORK.GLSSPS10 has 57 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

774       +DATA GLSCOA10;
775       + MERGE GLSCOA15(IN=A) GLSSPS10(IN=B);
776       + BY PROPNBR ACTDTE;
777       + IF A AND NOT B;
778       +

NOTE: There were 66 observations read from the data set WORK.GLSCOA15.
NOTE: There were 57 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
      

779       +DATA GLSSPS;
780       + SET GLSSPS1 GLSCOA10;
781       +
782       + IF SHARE = '.' THEN DO; *DPTTOT = TOTAMT; *DPTMTH = MTHAMT; *END;
783       +          NDPTTOT = NTOTAMT; CDPTTOT = CTOTAMT;
784       +          NDPTMTH = NMTHAMT; CDPTMTH = CMTHAMT;
785       + END;
786       + ELSE DO;
787       +   CDPTTOT = CTOTAMT * SHARE / 100;
788       +   NDPTTOT = NTOTAMT * SHARE / 100;
789       +   CDPTMTH = CMTHAMT * SHARE / 100;
790       +   NDPTMTH = NMTHAMT * SHARE / 100;
791       + END;
792       +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).
      782:13   
                                                                 The SAS System

NOTE: There were 99 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 99 observations and 47 variables.
NOTE: Compressing data set WORK.GLSSPS decreased size by 71.43 percent. 
      Compressed is 6 pages; un-compressed would require 21 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

793       +PROC SORT; BY Cost_Center_Hierarchy CC SF AGENCY;
794       +*proc print;
795       +

NOTE: There were 99 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 99 observations and 47 variables.
NOTE: Compressing data set WORK.GLSSPS decreased size by 71.43 percent. 
      Compressed is 6 pages; un-compressed would require 21 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

796       +DATA GLSSPS10; SET GLSSPS; BY Cost_Center_Hierarchy CC SF AGENCY;
797       + IF FIRST.AGENCY THEN DO;
798       +  CAGTOT = CDPTTOT;
799       +  CAGMTH = CDPTMTH;
800       +  NAGTOT = NDPTTOT;
801       +  NAGMTH = NDPTMTH;
802       + END;
803       + ELSE DO;
804       +  CAGTOT + CDPTTOT;
805       +  CAGMTH + CDPTMTH;
806       +  NAGTOT + NDPTTOT;
807       +  NAGMTH + NDPTMTH;
808       + END;
809       + IF LAST.AGENCY THEN DO;
810       +   CAGTOT = ROUND(CAGTOT,1.);
                                                                 The SAS System

811       +   CAGMTH = ROUND(CAGMTH,1.);
812       +   NAGTOT = ROUND(NAGTOT,1.);
813       +   NAGMTH = ROUND(NAGMTH,1.);
814       +   OUTPUT;
815       + END;
816       +

NOTE: There were 99 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS10 has 51 observations and 51 variables.
NOTE: Compressing data set WORK.GLSSPS10 decreased size by 63.64 percent. 
      Compressed is 4 pages; un-compressed would require 11 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

817       +PROC SORT; BY Cost_Center_Hierarchy CC AGENCY;
818       +
819       +/*PROC SQL;
820       +CREATE TABLE COACODE AS
821       + SELECT CODE_VALUE    AS AGENCY,
822       +        CODE_DESC     AS AGNAME
823       +FROM COA.CODES
824       +WHERE CODE_TYPE = 'AC';
825       +
826       +PROC SORT DATA = COACODE;  BY AGENCY;
827       +
828       +DATA GLSSPS20;
829       +MERGE COACODE(IN=A) GLSSPS10(IN=B);
830       +BY AGENCY;
831       +IF B;
832       +
833       +PROC SORT; BY COLLEGE DPT AGNAME;*/
834       +

NOTE: There were 51 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 51 observations and 51 variables.
NOTE: Compressing data set WORK.GLSSPS10 decreased size by 63.64 percent. 
                                                                 The SAS System

      Compressed is 4 pages; un-compressed would require 11 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

835       +DATA GLSOUT; SET GLSSPS10;
836       + BY Cost_Center_Hierarchy CC AGENCY;
837       + IF FIRST.agency THEN DO; *MTHTOT = AGMTH; *YTDTOT = AGTOT; *END;
838       +        CMTHTOT = CAGMTH; CYTDTOT = CAGTOT;
839       +        NMTHTOT = NAGMTH; NYTDTOT = NAGTOT; END;
840       + ELSE DO; *MTHTOT + AGMTH; *YTDTOT + AGTOT; *END;
841       +        CMTHTOT + CAGMTH; CYTDTOT + CAGTOT;
842       +        NMTHTOT + NAGMTH; NYTDTOT + NAGTOT; END;
843       + IF LAST.agency THEN OUTPUT;
844       +
845       +
846       +%global _ODSDEST;
847       +%global _ODSSTYLE;
848       +
849       +%MACRO PRINT;
850       +OPTIONS ORIENTATION=LANDSCAPE;
851       +
852       +%IF (%UPCASE("&_ODSDEST") eq "PHTML")+ (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
853       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
854       +data _null_ ;
855       +	rc = stpsrv_header('Content-type','text/html');
856       +run ;
857       +ods listing close;
858       +ods html body=_webout style=default;
859       +%END;
860       +
861       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
862       +data _null_ ;
863       +	rc = stpsrv_header('Content-type','application/pdf') ;
864       +	rc = stpsrv_header('Content-disposition',"attachment; filename=&TME..pdf");
865       +run ;
866       +ods listing close;
                                                                 The SAS System

867       +ods pdf file=_webout style=FSS;
868       +%END;
869       +
870       +DATA _NULL_; SET GLSOUT END=FINAL;
871       +FILE PRINT HEADER=A ls=150;
872       + BY Cost_Center_Hierarchy CC AGENCY;
873       +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
874       +TITLE2 " By Hierarchy, Cost Center, and Sponsor";
875       +TITLE3 " PROCESSED IN &MON &EFFYR  ";
876       +TITLE4 '  ';
877       +
878       +CGRDAGMTH + CMTHTOT;
879       +NGRDAGMTH + NMTHTOT;
880       +CGRDAGTOT + CYTDTOT;
881       +NGRDAGTOT + NYTDTOT;
882       + IF FIRST.Cost_Center_Hierarchy THEN DO;
883       +    NCOLAGMTH = NMTHTOT;
884       +    NCOLAGTOT = NYTDTOT;
885       +    CCOLAGMTH = CMTHTOT;
886       +    CCOLAGTOT = CYTDTOT;
887       +    PUT @1 Cost_Center_Hierarchy /;
888       + END;
889       + ELSE DO;
890       +    NCOLAGMTH + NMTHTOT;
891       +    NCOLAGTOT + NYTDTOT;
892       +    CCOLAGMTH + CMTHTOT;
893       +    CCOLAGTOT + CYTDTOT;
894       + END;
895       +
896       +   IF FIRST.CC THEN DO;
897       +    NDPTAGMTH = NMTHTOT;
898       +    NDPTAGTOT = NYTDTOT;
899       +    CDPTAGMTH = CMTHTOT;
900       +    CDPTAGTOT = CYTDTOT;
901       +    PUT @3 CC '- ' Cost_Center /
902       +        @50  AGENCY
903       +        @80  NMTHTOT  COMMA16.
904       +        @97  CMTHTOT  COMMA16.
                                                                 The SAS System

905       +        @114 NYTDTOT  COMMA16.
906       +        @131 CYTDTOT  COMMA16.;
907       +
908       +   END;
909       +   ELSE DO;
910       +    NDPTAGMTH + NMTHTOT;
911       +    NDPTAGTOT + NYTDTOT;
912       +    CDPTAGMTH + CMTHTOT;
913       +    CDPTAGTOT + CYTDTOT;
914       +    PUT @50  AGENCY
915       +        @80  NMTHTOT  COMMA16.
916       +        @97  CMTHTOT  COMMA16.
917       +        @114 NYTDTOT  COMMA16.
918       +        @131 CYTDTOT  COMMA16.;
919       +   END;
920       +
921       +    IF LAST.CC THEN DO;
922       +    PUT        @1 /
923       +               @50 'TOTAL COST CENTER'
924       +               @80  NDPTAGMTH DOLLAR16.
925       +               @97  CDPTAGMTH DOLLAR16.
926       +               @114 NDPTAGTOT DOLLAR16.
927       +               @131 CDPTAGTOT DOLLAR16./;
928       +    END;
929       +
930       +    IF LAST.Cost_Center_Hierarchy THEN DO;
931       +    PUT        @1 /
932       +               @45 'TOTAL CC HIERARCHY'
933       +               @80  NCOLAGMTH DOLLAR16.
934       +               @97  CCOLAGMTH DOLLAR16.
935       +               @114 NCOLAGTOT DOLLAR16.
936       +               @131 CCOLAGTOT DOLLAR16./;
937       +    END;
938       +
939       +    IF FINAL THEN DO;
940       +    PUT        @1 /
941       +               @45 'TOTAL'
942       +               @80  NGRDAGMTH DOLLAR16.
                                                                 The SAS System

943       +               @97  CGRDAGMTH DOLLAR16.
944       +               @114 NGRDAGTOT DOLLAR16.
945       +               @131 CGRDAGTOT DOLLAR16./;
946       +    END;
947       +
948       +RETURN;
949       +A:
950       + PUT @ 50 'AGENCY'
951       +     @ 89 'MONTHLY AMOUNT'
952       +     @118 'FISCAL YTD AMOUNT'/
953       +     @ 87 'NEW'
954       +     @102 'CONT'
955       +     @117 'NEW'
956       +     @132 'CONT'//;
957       +RETURN;
958       +
959       +PROC TEMPLATE;
960       +    DEFINE STYLE WHITE ;
961       +    PARENT=STYLES.PRINTER;
962       +    REPLACE COLOR_LIST /
963       +       'LINK' = BLUE
964       +       'BGH' = WHITE
965       +       'FG' = BLACK
966       +       'BG' = WHITE;
967       +    END;
968       +    RUN;
969       +
970       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
971       +ods html close;
972       +%END;
973       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
974       +ods pdf close;
975       +%END;
976       +
977       +%END;
978       +%MEND PRINT;
979       +%PRINT;
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
                                                                 The SAS System

SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF

NOTE: There were 51 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSOUT has 51 observations and 55 variables.
NOTE: Compressing data set WORK.GLSOUT decreased size by 63.64 percent. 
      Compressed is 4 pages; un-compressed would require 11 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

SYMBOLGEN:  Macro variable TME resolves to    64811.166

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 JULY     
SYMBOLGEN:  Macro variable EFFYR resolves to 2017

NOTE: 163 lines were written to file PRINT.
NOTE: There were 51 observations read from the data set WORK.GLSOUT.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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
      

                                                                 The SAS System

SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
NOTE: ODS PDF printed 8 pages to E8283740-D7F4-49B3-B902-80AE91E28A2D.
980       +/*
981       +ODS PDF FILE=&PFILE NOTOC STYLE = WHITE  ;
982       +
983       +DATA _NULL_; SET GLSOUT END=FINAL;
984       +FILE PRINT HEADER=A;
985       + BY COLLEGE DPT AGNAME;
986       +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
987       +TITLE2 " BY COLLEGE, DEPARTMENT, AND SPONSOR";
988       +TITLE3 " PROCESSED IN &MON &EFFYR  ";
989       +TITLE4 '  ';
990       +CGRDAGMTH + CMTHTOT;
991       +NGRDAGMTH + NMTHTOT;
992       +CGRDAGTOT + CYTDTOT;
993       +NGRDAGTOT + NYTDTOT;
994       + IF FIRST.COLLEGE THEN DO;
995       +        NCOLAGMTH = NMTHTOT;
996       +        NCOLAGTOT = NYTDTOT;
997       +        CCOLAGMTH = CMTHTOT;
998       +        CCOLAGTOT = CYTDTOT;
999       +    PUT @1 COLLEGE '- ' COLNAME /;
1000      + END;
1001      + ELSE DO;
1002      +    NCOLAGMTH + NMTHTOT;
1003      +        NCOLAGTOT + NYTDTOT;
1004      +        CCOLAGMTH + CMTHTOT;
1005      +        CCOLAGTOT + CYTDTOT;
1006      + END;
1007      +
1008      +   IF FIRST.DPT THEN DO;
1009      +    NDPTAGMTH = NMTHTOT;
1010      +    NDPTAGTOT = NYTDTOT;
1011      +    CDPTAGMTH = CMTHTOT;
1012      +    CDPTAGTOT = CYTDTOT;
1013      +    PUT @3 DPT '- ' DPTNAME /
1014      +        @50  AGNAME
                                                                 The SAS System

1015      +       @80  NMTHTOT  COMMA11.
1016      +       @95  CMTHTOT  COMMA11.
1017      +       @110 NYTDTOT  COMMA11.
1018      +       @125 CYTDTOT  COMMA11.;
1019      +   END;
1020      +   ELSE DO;
1021      +    NDPTAGMTH + NMTHTOT;
1022      +    NDPTAGTOT + NYTDTOT;
1023      +    CDPTAGMTH + CMTHTOT;
1024      +    CDPTAGTOT + CYTDTOT;
1025      +    PUT @50  AGNAME
1026      +       @80  NMTHTOT  COMMA11.
1027      +       @95  CMTHTOT  COMMA11.
1028      +       @110 NYTDTOT  COMMA11.
1029      +       @125 CYTDTOT  COMMA11.;
1030      +   END;
1031      +
1032      +    IF LAST.DPT THEN DO;
1033      +    PUT        @1 /
1034      +               @50 'TOTAL DEPARTMENT'
1035      +                 @80  NDPTAGMTH DOLLAR11.
1036      +                 @95  CDPTAGMTH DOLLAR11.
1037      +                 @110 NDPTAGTOT DOLLAR11.
1038      +                 @125 CDPTAGTOT DOLLAR11./;
1039      +    END;
1040      +
1041      +    IF LAST.COLLEGE THEN DO;
1042      +    PUT        @1 /
1043      +               @45 'TOTAL COLLEGE'
1044      +                @80  NCOLAGMTH DOLLAR11.
1045      +                @95  CCOLAGMTH DOLLAR11.
1046      +                @110 NCOLAGTOT DOLLAR11.
1047      +                   @125 CCOLAGTOT DOLLAR11./;
1048      +    END;
1049      +
1050      +    IF FINAL THEN DO;
1051      +    PUT        @1 /
1052      +               @45 'TOTAL'
                                                                 The SAS System

1053      +                    @80  NGRDAGMTH DOLLAR11.
1054      +                    @95  CGRDAGMTH DOLLAR11.
1055      +                    @110 NGRDAGTOT DOLLAR11.
1056      +                    @125 CGRDAGTOT DOLLAR11./;
1057      +         END;
1058      +
1059      +RETURN;
1060      +A:
1061      + PUT @ 50 'AGENCY'
1062      +     @ 89 'MONTHLY AMOUNT'
1063      +     @118 'FISCAL YTD AMOUNT'/
1064      +     @ 87 'NEW'
1065      +     @102 'CONT'
1066      +     @117 'NEW'
1067      +      @132 'CONT'//;
1068      +RETURN;
1069      +RUN;
1070      +
1071      +ODS PDF CLOSE;
1072      +
1073      + ODS HTML FILE=&HFILE STYLE=MINIMAL   RS=NONE;
1074      +
1075      +DATA _NULL_; SET GLSOUT END=FINAL;
1076      +FILE PRINT HEADER=A;
1077      + BY COLLEGE DPT AGNAME;
1078      +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
1079      +TITLE2 " BY COLLEGE, DEPARTMENT, AND SPONSOR";
1080      +TITLE3 " PROCESSED IN &MON &EFFYR  ";
1081      +TITLE4 '  ';
1082      +CGRDAGMTH + CMTHTOT;
1083      +NGRDAGMTH + NMTHTOT;
1084      +CGRDAGTOT + CYTDTOT;
1085      +NGRDAGTOT + NYTDTOT;
1086      + IF FIRST.COLLEGE THEN DO;
1087      +    NCOLAGMTH = NMTHTOT;
1088      +    NCOLAGTOT = NYTDTOT;
1089      +    CCOLAGMTH = CMTHTOT;
1090      +    CCOLAGTOT = CYTDTOT;
                                                                 The SAS System

1091      +    PUT @1 COLLEGE '- ' COLNAME /;
1092      + END;
1093      + ELSE DO;
1094      +     NCOLAGMTH + NMTHTOT;
1095      +     NCOLAGTOT + NYTDTOT;
1096      +     CCOLAGMTH + CMTHTOT;
1097      +     CCOLAGTOT + CYTDTOT;
1098      + END;
1099      +
1100      +   IF FIRST.DPT THEN DO;
1101      +    NDPTAGMTH = NMTHTOT;
1102      +    NDPTAGTOT = NYTDTOT;
1103      +    CDPTAGMTH = CMTHTOT;
1104      +    CDPTAGTOT = CYTDTOT;
1105      +    PUT @3 DPT '- ' DPTNAME /
1106      +        @50  AGNAME
1107      +        @80  NMTHTOT  COMMA11.
1108      +        @95  CMTHTOT  COMMA11.
1109      +        @110 NYTDTOT  COMMA11.
1110      +        @125 CYTDTOT  COMMA11.;
1111      +   END;
1112      +   ELSE DO;
1113      +     NDPTAGMTH + NMTHTOT;
1114      +     NDPTAGTOT + NYTDTOT;
1115      +     CDPTAGMTH + CMTHTOT;
1116      +     CDPTAGTOT + CYTDTOT;
1117      +    PUT @50  AGNAME
1118      +         @80  NMTHTOT  COMMA11.
1119      +         @95  CMTHTOT  COMMA11.
1120      +         @110 NYTDTOT  COMMA11.
1121      +         @125 CYTDTOT  COMMA11.;
1122      +   END;
1123      +
1124      +    IF LAST.DPT THEN DO;
1125      +    PUT        @1 /
1126      +               @50 'TOTAL DEPARTMENT'
1127      +                  @80  NDPTAGMTH DOLLAR11.
1128      +                  @95  CDPTAGMTH DOLLAR11.
                                                                 The SAS System

1129      +                  @110 NDPTAGTOT DOLLAR11.
1130      +                  @125 CDPTAGTOT DOLLAR11./;
1131      +    END;
1132      +
1133      +    IF LAST.COLLEGE THEN DO;
1134      +    PUT        @1 /
1135      +               @45 'TOTAL COLLEGE'
1136      +                 @80  NCOLAGMTH DOLLAR11.
1137      +                 @95  CCOLAGMTH DOLLAR11.
1138      +                 @110 NCOLAGTOT DOLLAR11.
1139      +                    @125 CCOLAGTOT DOLLAR11./;
1140      +    END;
1141      +
1142      +    IF FINAL THEN DO;
1143      +    PUT        @1 /
1144      +               @45 'TOTAL'
1145      +                    @80  NGRDAGMTH DOLLAR11.
1146      +                    @95  CGRDAGMTH DOLLAR11.
1147      +                    @110 NGRDAGTOT DOLLAR11.
1148      +                    @125 CGRDAGTOT DOLLAR11./;
1149      +    END;
1150      +
1151      +RETURN;
1152      +A:
1153      + PUT @ 50 'AGENCY'
1154      +     @ 89 'MONTHLY AMOUNT'
1155      +     @118 'FISCAL YTD AMOUNT'/
1156      +     @ 87 'NEW'
1157      +     @102 'CONT'
1158      +     @117 'NEW'
1159      +      @132 'CONT'//;
1160      +RETURN;
1161      +RUN;
1162      +
1163      +ODS HTML CLOSE;
1164      +
1165      +*  Begin EG generated code (do not edit this line);
1166      +;*';*";*/;quit;
                                                                 The SAS System

1167      +
1168      +*  End EG generated code (do not edit this line);
1169      +
NOTE: %INCLUDE (level 1) ending.