SAS Log

1                                                                                                                        The SAS System                                                                                           16:22 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; __unam=7ac2274-151253bf750-b2127a8-1772; JSESSIONID=B12F5390566265A18F266CE484550363; sso-logout-time="Sat Oct 28 2017 00:21:51 GMT-0500 (Central Daylight
      Time)"; LtpaToken=AAECAzU5RjNBMzMzNTlGNDEzRUZrdHdlZWRAbHN1LmVkdcdWf3QzOoQT/y0rCsn2UmWdnyJL
 _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/FUNDCD2
 _REPLAY="&_URL?_sessionid=60135A93-9670-43BF-96B2-B3C1D44B7FF7&_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.TCAT000A
 _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\FUNDCD2.sas is file D:\SAS Stored Processes\FSS\FUNDCD2.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: FUNDCD2
9         +*  ====================================================================
10        +*
11        +*  Stored process prompt dictionary:
12        +*  ____________________________________
13        +*  _ODSDEST
14        +*       Type: Text
15        +*      Label: _ODSDEST
16        +*       Attr: Visible
17        +*  ____________________________________
18        +*  EFFDTE
19        +*       Type: Text
20        +*      Label: EFFDTE
21        +*       Attr: Visible
22        +*  ____________________________________
23        +*;
24        +
25        +
26        +*ProcessBody;
27        +
28        +%global _ODSDEST
29        +        EFFDTE;
30        +
31        +OPTIONS VALIDVARNAME=ANY;
32        +
33        +%macro ExtendValidMemName;
34        +
35        +%if %sysevalf(&sysver>=9.3) %then options validmemname=extend;
36        +
37        +%mend ExtendValidMemName;
38        +
                                                                                          The SAS System

39        +%ExtendValidMemName;
40        +
41        +*  End EG generated code (do not edit this line);
42        +
43        +OPTIONS MISSING = ' '
44        +     LINESIZE=145 symbolgen;
45        +
46        +  *** ENTER EFFECTIVE DATE ***;
47        +*%LET EFFDTE = 20170228;
48        +%GetÃÛÌÒAPPUser
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _HTCOOK resolves to _ga=GA1.2.833841193.1398869373; __unam=7ac2274-151253bf750-b2127a8-1772; 
            JSESSIONID=B12F5390566265A18F266CE484550363; sso-logout-time="Sat Oct 28 2017 00:21:51 GMT-0500 (Central Daylight Time)"; 
            LtpaToken=AAECAzU5RjNBMzMzNTlGNDEzRUZrdHdlZWRAbHN1LmVkdcdWf3QzOoQT/y0rCsn2UmWdnyJL
SYMBOLGEN:  Some characters in the above value which were subject to macro quoting have been unquoted for printing.

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

SYMBOLGEN:  Macro variable VALUE resolves to 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).
      48:118   48:240   
NOTE: The infile ÃÛÌÒAPP 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 ÃÛÌÒAPP.
      The minimum record length was 33.
                                                                 The SAS System

      The maximum record length was 33.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

**END*USEREND*USER**


SYMBOLGEN:  Macro variable _ÃÛÌÒAPPPERSON resolves to Keri M Tweed
SYMBOLGEN:  Macro variable _ÃÛÌÒAPPUSER resolves to ktweed
****  This stored process was requested by Keri M Tweed with ÃÛÌÒAPPUSERID: ktweed


**END*USEREND*USER**
SYMBOLGEN:  Macro variable _INFILE resolves to            0
SYMBOLGEN:  Macro variable _INUSER resolves to            1
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(V" || COMPRESS(PDATE) || ")'";
62        +     CALL SYMPUT('PFILE',PFILE);
63        +HFILE = "'ACGR14.PROD.HTML(V" || COMPRESS(PDATE) || ")'";
64        +     CALL SYMPUT ('HFILE', HFILE);*/
65        +     CALL SYMPUT('FYR',FYRX);
66        +     CALL SYMPUT('FYEAR',FYEARX);
67        +     CALL SYMPUT('EFFMN',EFFMN);
68        +     CALL SYMPUT('EFFYR',EFFYR);
                                                                 The SAS System

69        +     CALL SYMPUT('FISCAL',FISCAL);
70        +	 TME = TIME();
71        +	CALL SYMPUT('TME',TME);
72        +
73        +	
74        +	if EFFMN > 6 then begfy = effyr; else begfy = effyr - 1;	
75        +	format begdte yymmddn.;
76        +begdte = begfy||'0701';
77        +begdte1 = INPUT(PUT(begdte,$8.),8.);
WARNING: Variable begdte has already been defined as numeric.
78        +CALL SYMPUT('begdte1',begdte1);
79        +
80        +
81        +IF EFFMN = 01 THEN MON = 'JANUARY  ';
82        +IF EFFMN = 02 THEN MON = 'FEBRUARY ';
83        +IF EFFMN = 03 THEN MON = 'MARCH    ';
84        +IF EFFMN = 04 THEN MON = 'APRIL    ';
85        +IF EFFMN = 05 THEN MON = 'MAY      ';
86        +IF EFFMN = 06 THEN MON = 'JUNE     ';
87        +IF EFFMN = 07 THEN MON = 'JULY     ';
88        +IF EFFMN = 08 THEN MON = 'AUGUST   ';
89        +IF EFFMN = 09 THEN MON = 'SEPTEMBER';
90        +IF EFFMN = 10 THEN MON = 'OCTOBER  ';
91        +IF EFFMN = 11 THEN MON = 'NOVEMBER ';
92        +IF EFFMN = 12 THEN MON = 'DECEMBER ';
93        + CALL SYMPUT('MON',MON);
94        +
95        +BEGFY=FISCAL-1;
96        +BEGFX = INPUT(PUT(BEGFY,4.),$4.);
97        +FISX = INPUT(PUT(FISCAL,4.),$4.);
98        +FORMAT BEGYR ENDYR $2.;
99        +BEGYR = SUBSTR(BEGFX,3,2);
100       +ENDYR = SUBSTR(FISX,3,2);
101       +CALL SYMPUT('BEGYR',BEGYR);
102       +CALL SYMPUT('ENDYR',ENDYR);
103       +
104       +     IF EFFMN = 01 THEN HEADER = '  JANUARY';
105       +ELSE IF EFFMN = 02 THEN HEADER = ' FEBRUARY';
                                                                 The SAS System

106       +ELSE IF EFFMN = 03 THEN HEADER = '    MARCH';
107       +ELSE IF EFFMN = 04 THEN HEADER = '    APRIL';
108       +ELSE IF EFFMN = 05 THEN HEADER = '      MAY';
109       +ELSE IF EFFMN = 06 THEN HEADER = '     JUNE';
110       +ELSE IF EFFMN = 07 THEN HEADER = '     JULY';
111       +ELSE IF EFFMN = 08 THEN HEADER = '   AUGUST';
112       +ELSE IF EFFMN = 09 THEN HEADER = 'SEPTEMBER';
113       +ELSE IF EFFMN = 10 THEN HEADER = '  OCTOBER';
114       +ELSE IF EFFMN = 11 THEN HEADER = ' NOVEMBER';
115       +ELSE IF EFFMN = 12 THEN HEADER = ' DECEMBER';
116       +CALL SYMPUT('HEADER',HEADER);

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      56:6    57:18   74:5    74:48   76:15   81:4    82:4    83:4    84:4    85:4    86:4    87:4    88:4    89:4    90:4    91:4    92:4
      95:7    104:9   105:9   106:9   107:9   108:9   109:9   110:9   111:9   112:9   113:9   114:9   115:9   
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      57:24   71:20   74:54   78:23   95:13   
NOTE: The data set WORK.DATE has 1 observations and 18 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.01 seconds
      cpu time            0.01 seconds
      

117       +proc sort; by effmn;
118       +
119       +/*LIBNAME COA DB2 AUTHID=COA SSID=DB2;
120       +LIBNAME SPM DB2 AUTHID=SPM SSID=DB2;
121       +LIBNAME DIR DB2 AUTHID=DIR SSID=DB2;*/
122       +
123       +/ LEGACY COA INFORMATION ****
124       +PROC SQL;
125       + CREATE TABLE COAFILE AS
126       + SELECT P_I_ÃÛÌÒAPP_ID          AS PIID
127       +       ,ACCT_CODE           AS ACCT
128       +       ,AGENCY_CD           AS AGENCY
129       +       ,GRANT_EXPIRE_DATE   AS EXPIRE
                                                                 The SAS System

130       +       ,PROPOSAL_NBR        AS PROPNBR
131       +       ,GRANT_NAME          AS STITLE
132       +       ,TOTAL_AWARD_AMT     AS TOTAWARD
133       +       ,CO_P_I_ÃÛÌÒAPP_ID       AS COPIID
134       +       ,INTERNAL_COMP_FLAG  AS INTFLAG
135       +       ,TASK_NBR            AS TASK
136       +FROM COA.SPONSORED_PROGRAMS
137       +WHERE SUBSTR(ACCT_CODE,1,1) = '1'
138       +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6') AND PROPOSAL_NBR <> 0
139       +AND AGENCY_CD NOT IN ('A1','C','Z','XF') AND BILL_CYCLE_CD <> 'G'
140       +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
141       +'190067') AND FISCAL_YEAR = &FYEAR;
142       +PROC SORT; BY ACCT;*/
143       +

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

144       +PROC SQL;
145       +CREATE TABLE FUND1 AS
146       +SELECT ORG_ID AS GRANT_ID,
147       +FUND
148       +FROM WDM.fin_fdm_DRIVERTAG
149       +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.04 seconds
      cpu time            0.01 seconds
      
                                                                 The SAS System


150       +PROC SORT; BY GRANT_ID;
151       +

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
      

152       +PROC SQL;
153       +CREATE TABLE GRANT1 AS
154       +SELECT GRANT_ID,
155       +AWARD_NUMBER as award_budg,
156       +TO_DATE AS GRANT_EXP_DATE,
157       +sponsor_id,
158       +cont_line_status,
159       +workday_id,
160       +CONT_STATUS,
161       +is_primary
162       +FROM WDM.FIN_AWD_LINE
163       +where company = '10' and cont_status NE ' ';
NOTE: Compressing data set WORK.GRANT1 decreased size by 36.36 percent. 
      Compressed is 49 pages; un-compressed would require 77 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
      

164       +PROC SORT; BY GRANT_ID;
165       +

NOTE: There were 3498 observations read from the data set WORK.GRANT1.
                                                                 The SAS System

NOTE: The data set WORK.GRANT1 has 3498 observations and 8 variables.
NOTE: Compressing data set WORK.GRANT1 decreased size by 36.36 percent. 
      Compressed is 49 pages; un-compressed would require 77 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

166       +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 43.64 percent. 
      Compressed is 31 pages; un-compressed would require 55 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

167       +PROC SORT; BY sponsor_id;
168       +

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 43.64 percent. 
      Compressed is 31 pages; un-compressed would require 55 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

169       +proc sql;
170       +create table SPON as
171       +select sponsor_id,
172       +SPONSOR_NAME,
173       +sponsor_type
174       +from wdm.fin_awd_sponsor;
                                                                 The SAS System

NOTE: Compressing data set WORK.SPON decreased size by 67.65 percent. 
      Compressed is 11 pages; un-compressed would require 34 pages.
NOTE: Table WORK.SPON created, with 1609 rows and 3 columns.

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

175       +proc sort; by sponsor_id;
176       +

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

177       +data mrgspon; merge mrg1(in=a) spon(in=b); by sponsor_id; if a;

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 11 variables.
NOTE: Compressing data set WORK.MRGSPON decreased size by 63.73 percent. 
      Compressed is 37 pages; un-compressed would require 102 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

178       +PROC SORT; BY award_budg grant_id cont_line_status descending is_primary ;
179       +

NOTE: There were 3042 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.MRGSPON has 3042 observations and 11 variables.
                                                                 The SAS System

NOTE: Compressing data set WORK.MRGSPON decreased size by 63.73 percent. 
      Compressed is 37 pages; un-compressed would require 102 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

180       +data setspon; set mrgspon; BY award_budg grant_id cont_line_status descending is_primary ;
181       +if first.grant_id then output;

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

182       +proc sort; by workday_id;
183       +

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

184       +proc sql;
185       +create table task as
186       +select workday_id,
187       +org_id as tasknbr
188       +from WDM.FIN_AWD_LINE_ORG
189       +where substr(org_id,1,2) = 'TA';
NOTE: Compressing data set WORK.TASK decreased size by 22.22 percent. 
                                                                 The SAS System

      Compressed is 84 pages; un-compressed would require 108 pages.
NOTE: Table WORK.TASK created, with 6223 rows and 2 columns.

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

190       +proc sort; by workday_id;
191       +

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

192       +data mrggrnt; merge task(in=a) setspon(in=b); by workday_id;
193       +if b;

NOTE: There were 6223 observations read from the data set WORK.TASK.
NOTE: There were 3038 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.MRGGRNT has 3038 observations and 12 variables.
NOTE: Compressing data set WORK.MRGGRNT decreased size by 64.22 percent. 
      Compressed is 39 pages; un-compressed would require 109 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

194       +proc sort; by award_budg;
195       +

NOTE: There were 3038 observations read from the data set WORK.MRGGRNT.
NOTE: The data set WORK.MRGGRNT has 3038 observations and 12 variables.
                                                                 The SAS System

NOTE: Compressing data set WORK.MRGGRNT decreased size by 64.22 percent. 
      Compressed is 39 pages; un-compressed would require 109 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

196       +PROC SQL;
197       +CREATE TABLE AWARD1 AS
198       +SELECT AWARD_NUMBER as award_budg,
199       +PROPOSAL_ID as propnbr,
200       +AWARD_NAME,
201       +signed_date,
202       +TOTAL_AMOUNT AS AWD_TOTAL,
203       +award_date
204       +FROM WDM.FIN_AWD
205       +WHERE PROPOSAL_ID NE 0 and
206       +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.01 seconds
      

207       +PROC SORT; BY award_budg;
208       +

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
      
                                                                 The SAS System


209       +DATA MRG2; MERGE mrggrnt(IN=A) AWARD1(IN=B); BY award_budg; IF A AND B;
210       +format TASK 2.;
211       +task = substr(taskNBR,3,2);
212       +if task = 0 then task = 1;

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

213       +PROC SORT; BY award_budg;
214       +
215       +/*PROC SQL;
216       +CREATE TABLE LEADPI AS
217       +SELECT EMPLOYEE_ID AS WD_PIID,
218       +ORG_ID AS GRANT_ID,
219       +ROLE_NAME AS ROLE1
220       +FROM WDM.WORKER_ROLE
221       +WHERE role_name = 'Principal_Investigator';
222       +PROC SORT; BY WD_PIID;
223       +
224       +PROC SQL;
225       +CREATE TABLE ÃÛÌÒAPPPIID AS
226       +SELECT EMPLOYEE_ID AS WD_PIID,
227       +ÃÛÌÒAPP_ID AS ÃÛÌÒAPP_PIID
228       +FROM WDM.KEYS;
229       +PROC SORT; BY WD_PIID;
230       +
231       +DATA MRGPI;
232       +MERGE LEADPI(IN=A) ÃÛÌÒAPPPIID(IN=B); BY WD_PIID; IF A;
                                                                 The SAS System

233       +PROC SORT; BY GRANT_ID;
234       +
235       +DATA MRG3; MERGE MRG2(IN=A) MRGPI(IN=B); BY GRANT_ID; IF A;
236       +PROC SORT; BY award_budg;*/
237       +
238       +/*PROC SQL;
239       +CREATE TABLE COPI AS
240       +SELECT EMPLOYEE_ID AS WD_COPIID,
241       +ORG_ID AS GRANT_ID,
242       +ROLE_NAME AS ROLE2
243       +FROM WDM.WORKER_ROLE
244       +WHERE role_name = 'Co-Principal_Investigator';
245       +PROC SORT; BY WD_COPIID;
246       +
247       +PROC SQL;
248       +CREATE TABLE ÃÛÌÒAPPCOPIID AS
249       +SELECT EMPLOYEE_ID AS WD_COPIID,
250       +ÃÛÌÒAPP_ID AS ÃÛÌÒAPP_COPIID
251       +FROM WDM.KEYS;
252       +PROC SORT; BY WD_COPIID;
253       +
254       +DATA MRGCOPI;
255       +MERGE COPI(IN=A) ÃÛÌÒAPPCOPIID(IN=B); BY WD_COPIID; IF A;
256       +PROC SORT; BY GRANT_ID;
257       +
258       +DATA MRG4; MERGE MRG3(IN=A) MRGCOPI(IN=B); BY GRANT_ID; IF A;
259       +PROC SORT; BY award_budg;*/
260       +

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

                                                                 The SAS System

261       +proc sql;
262       +CREATE TABLE SPEC AS
263       +SELECT AWARD_NUMBER as award_budg,
264       +REF_ID
265       +FROM WDM.FIN_AWD_SPEC_COND
266       +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.01 seconds
      cpu time            0.01 seconds
      

267       +PROC SORT; BY award_budg;
268       +

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.00 seconds
      cpu time            0.00 seconds
      

269       +DATA MRG5; MERGE MRG2(IN=A) SPEC(IN=B); BY award_budg; IF A;
270       +if REF_ID = 'Special_Condition_Type_Internal_Competition' then intflag = 'Y';

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.71 percent. 
      Compressed is 53 pages; un-compressed would require 249 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
                                                                 The SAS System

      

271       +PROC SORT; BY award_budg grant_id;
272       +

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.71 percent. 
      Compressed is 53 pages; un-compressed would require 249 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

273       +data setmrg5; set mrg5; by award_budg grant_id;
274       +if first.grant_id ne last.grant_id then output;

NOTE: There were 2734 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.SETMRG5 has 0 observations and 20 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

275       +proc sort; by award_budg grant_id;
276       +
277       +
278       +
279       +/*PROC SQL;
280       + CREATE TABLE SPAFILE AS
281       + SELECT ACCT_CODE       AS ACCT
282       +       ,BEGIN_DATE      AS BEGIN
283       +       ,INIT_TIMESTAMP  AS IADD
284       +       ,LONG_TITLE      AS LONG
285       +FROM COA.ACCOUNTS
286       +WHERE CAMPUS_CD = '1' AND ACCT_TYPE = 'S'
287       +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6')
288       +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
                                                                 The SAS System

289       +'190067') AND FISCAL_YEAR = &FYEAR;
290       +
291       +PROC SORT; BY ACCT;
292       +
293       +DATA COAS;
294       +  MERGE COAFILE(IN=A) SPAFILE(IN=B);
295       +  BY ACCT;
296       +  IF A AND B;
297       +
298       +PROC SORT DATA = COAS;  BY ACCT;
299       +
300       +DATA COA1(KEEP=STITLE LONG ACCT AGENCY EXPIRE BEGIN ADDTE TOTAWARD
301       +          PIID COPIID PROPNBR INTFLAG TASK);
302       + SET COAS;
303       +  FORMAT STITLE $60.;
304       +  FORMAT ADATE YYMMDDN8.;
305       +  ADATE = DATEPART(IADD);
306       +  FORMAT BEGIN YYMMDDN8.;
307       +  FORMAT EXPIRE YYMMDDN8.;
308       +  AYR = YEAR(ADATE);
309       +  AMTH= MONTH(ADATE);
310       +    MONA = INPUT(PUT(AMTH,Z2.),$2.);
311       +    YEARA = INPUT(PUT(AYR,4.),$4.);
312       +  ADDTE = YEARA||MONA;
313       +  *IF BEGIN <= &DATE;*/
314       +

NOTE: Input data set is empty.
NOTE: The data set WORK.SETMRG5 has 0 observations and 20 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

315       +PROC SQL;
316       +CREATE TABLE BUDG AS
317       +SELECT grant_id,
318       +grant_name,
                                                                 The SAS System

319       +ledger_account,
320       +budget_revenue as AMT,
321       +budget_obj,
322       +award_name,
323       +award_report_code as BAADJCD,
324       +budget_amendment_date,
325       +budget_date_from
326       +from workday.award_budget
327       +where ledger_account in ('4200:Federal Grants and Contracts Revenue','4210:State and Local Grants and Contracts Revenue',
328       +'4220:Non-governmental Grants and Contracts Revenue','4230:Grants and Contracts Revenue') and budget_amendment_status not in
328      !+('Canceled','Draft','Denied')
329       +and company_code = 'ÃÛÌÒAPPAM' and
330       +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
      

331       +proc sort; by grant_id;
332       +

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.01 seconds
      cpu time            0.01 seconds
      

333       +data set1; set budg; by grant_id;
334       +format BUDGET_DATE1 yymmddn.;
335       +budget_date1 = budget_amendment_date;
336       +award_budg = scan(budget_obj,1,":");
                                                                 The SAS System


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
      

337       +proc sort; by award_budg grant_id;
338       +

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.01 seconds
      cpu time            0.01 seconds
      

339       +data MARGE; merge mrg5(in=a) set1(in=b); by award_budg grant_id; if a and b;
340       +format budget_date yymmddn.;
341       +if budget_date1 = ' ' then budget_date = signed_date; else budget_date = budget_date1;
342       +if budget_date = ' ' then delete;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      341:19   342: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 74.61 percent. 
      Compressed is 49 pages; un-compressed would require 193 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
                                                                 The SAS System

      

343       +proc sort; by grant_id budget_date;
344       +

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 74.61 percent. 
      Compressed is 49 pages; un-compressed would require 193 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

345       +data marge1; set marge; by grant_id budget_date;
346       +effdte = INPUT(PUT(budget_date,yymmddn.),8.);
347       +*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 74.09 percent. 
      Compressed is 50 pages; un-compressed would require 193 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

348       +proc sort; by grant_id;
349       +
350       +
351       +
352       +/*
353       +DATA GLSD;
354       +  INFILE GLSD;
355       +  INPUT  @1   FY       $2.
356       +         @3   ENTRY   PD5.
357       +         @10  ACCT       $9.
358       +         @19  TT         $1.
                                                                 The SAS System

359       +         @20  OBJ      $4.
360       +         @24  SUBOBJ   $1.
361       +         @29  AMT        PD6.2
362       +         @168 BAADJCD  $1.;
363       +  IF TT = 'I' AND SUBSTR(ACCT,1,1) = '1' AND
364       +    SUBSTR(ACCT,6,1) IN ('4','5','6') AND FY = &FYR
365       +    AND BAADJCD IN ('N','C');
366       +  IF AMT = 0 THEN DELETE;
367       +  SF = SUBSTR(ACCT,6,1);
368       +
369       +PROC SORT DATA=GLSD; BY FY ENTRY;
370       +
371       +DATA GÃÛÌÒAPPSRS;
372       +  INFILE GÃÛÌÒAPPSR;
373       +   INPUT  @   1  FY        $2.
374       +          @   3  ENTRY     PD5.
375       +          @   8  ENTRYTYP  $2.
376       +          @  57  VCHRTYPE  $2.
377       +          @  64  EFFDTE    PD5.
378       +          @  69  STATUS    $1.;
379       +          IF STATUS = 'C';
380       +          IF FY = &FYR ;
381       +          IF ENTRYTYP = 'GE';
382       +
383       +PROC SORT DATA=GÃÛÌÒAPPSRS;  BY FY ENTRY;
384       +
385       +DATA GLS;
386       +  MERGE GÃÛÌÒAPPSRS(IN=A) GLSD(IN=B);
387       +  BY FY ENTRY;
388       +  IF A AND B;
389       +
390       +
391       +PROC SORT; BY ACCT;
392       +
393       +DATA GLSCOA;
394       +  MERGE COA1(IN=A) GLS(IN=B);
395       +  BY ACCT;
396       +  IF A AND B;
                                                                 The SAS System

397       +
398       +PROC SORT DATA = GLSCOA;  BY FY ACCT ENTRY;*/
399       +

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 74.09 percent. 
      Compressed is 50 pages; un-compressed would require 193 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

400       +DATA BUDG1 (DROP= EMTH ENDYRX BEGYRX END BEG);
401       + SET marge1; by grant_id effdte;
402       +  *BY FY ACCT ENTRY;
403       + *edate = effdte;
404       +  EDATE = INPUT(PUT(effdte,8.),YYMMDD8.);
405       +  EMTH= MONTH(EDATE);
406       +
407       +  IF effdte <= &EFFDTE and effdte >= &begdte1;
SYMBOLGEN:  Macro variable EFFDTE resolves to 20170731
SYMBOLGEN:  Macro variable BEGDTE1 resolves to     20170701
408       +
409       +  EMNX = INPUT(PUT(EMTH,Z2.),$2.);
410       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 18
411       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
412       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
413       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
414       +  IF EMTH > 6 THEN ACTDTE = BEG||EMNX;
415       +   ELSE ACTDTE = END||EMNX;
416       +
417       +  IF EMNX = &EFFMN THEN MONAMT = AMT;
SYMBOLGEN:  Macro variable EFFMN resolves to 07      
418       +  ELSE MONAMT = 0;
419       +
                                                                 The SAS System


NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      417: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.01 seconds
      cpu time            0.01 seconds
      

420       +PROC SORT DATA = budg1; BY ACTDTE grant_id;
421       +

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
      

422       +DATA GLSCOA15; SET budg1;
423       + BY ACTDTE grant_id;
424       + IF FIRST.grant_id THEN DO;
425       +        IF BAADJCD = 'New' THEN DO; NAMT = MONAMT; CAMT = 0; END;
426       +        IF BAADJCD = 'Continuation' THEN DO; NAMT = 0; CAMT = MONAMT; END;
427       +  END;
428       +  ELSE DO;
429       +         IF BAADJCD = 'New' THEN DO; NAMT + MONAMT; CAMT + 0; END;
430       +         IF BAADJCD = 'Continuation' THEN DO; NAMT + 0; CAMT + MONAMT; END;
431       + END;
432       + IF LAST.grant_id THEN OUTPUT;
433       +
434       +

                                                                 The SAS System

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
      

435       +PROC SQL;
436       +  CREATE TABLE PROJTRAN AS
437       +SELECT PROPOSAL_NBR     AS PROPNBR
438       +      ,TRX_NBR          AS TRXNBR
439       +      ,TRX_TYPE         AS TRXTYPE
440       +      ,TRX_STATUS       AS TRXSTAT
441       +      ,TO_SPA_DATE      AS RELDATE
442       +FROM SPM.PROJ_TRANSACTION
443       + 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.

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

445       + PROC SORT; BY PROPNBR TRXNBR RELDATE;
446       +

NOTE: There were 18085 observations read from the data set WORK.PROJTRAN.
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.03 seconds
      cpu time            0.03 seconds
                                                                 The SAS System

      

447       +DATA SPS2;
448       + SET PROJTRAN; BY PROPNBR TRXNBR;
449       +    LENGTH MO YY $2.;
450       +    LENGTH YR $4.;
451       +    MO=MONTH(RELDATE);
452       +    YR=YEAR(RELDATE);
453       +    YY=SUBSTR(YR,3,2);
454       +    LENGTH EFFMY $4.;
455       +    EFFMY=YY||MO;
456       +    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).
      451:8   452: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 451:8   212 at 452: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
      

457       +    PROC SORT; BY PROPNBR EFFMY RELDATE;
458       +

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.03 seconds
      cpu time            0.03 seconds
      
                                                                 The SAS System


459       + PROC SORT; BY PROPNBR TRXNBR;
460       +

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
      

461       +PROC SQL;
462       +    CREATE TABLE PISHR AS
463       +    SELECT PROPOSAL_NBR    AS PROPNBR,
464       +           TRX_NBR         AS TRXNBR,
465       +           TASK_NBR        AS TASK,
466       +           ÃÛÌÒAPP_ID          AS ÃÛÌÒAPPID,
467       +           INVESTIGATOR_TYPE AS INVTYPE,
468       +           DEPT_CD         AS DPT,
469       +           PROJECT_SHARE   AS SHARE
470       +    FROM SPM.PROJ_INVESTIGATOR
471       +    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 74360 rows and 7 columns.

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

472       +    PROC SORT; BY PROPNBR TRXNBR TASK;
473       +

NOTE: There were 74360 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.PISHR has 74360 observations and 7 variables.
                                                                 The SAS System

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
      

474       +DATA SPS4;
475       +  MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
476       +

NOTE: There were 18085 observations read from the data set WORK.SPS2.
NOTE: There were 74360 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.07 seconds
      cpu time            0.07 seconds
      

477       +PROC SORT;  BY PROPNBR EFFMY RELDATE;
478       +

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
      

479       +    PROC SORT; BY PROPNBR TRXNBR;
480       +

NOTE: There were 31770 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31770 observations and 14 variables.
                                                                 The SAS System

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.07 seconds
      cpu time            0.04 seconds
      

481       +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
482       +     SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
483       +     SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
484       +     SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
485       +     SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
486       +     SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
487       +     SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
488       +     SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
489       +     SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
490       +     SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
491       +     SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
492       +     SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
493       +     SET SPS4;
494       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 18
495       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
496       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
497       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
498       +     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
499       +         ACTDTE = BEG||'07';
500       +         OUTPUT SPSFM1;
501       +         END;
502       +     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
503       +         ACTDTE = BEG||'08';
504       +         OUTPUT SPSFM2;
505       +         END;
                                                                 The SAS System

506       +     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
507       +         ACTDTE = BEG||'09';
508       +         OUTPUT SPSFM3;
509       +         END;
510       +     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
511       +         ACTDTE = BEG||'10';
512       +         OUTPUT SPSFM4;
513       +         END;
514       +     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
515       +         ACTDTE = BEG||'11';
516       +         OUTPUT SPSFM5;
517       +         END;
518       +     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
519       +         ACTDTE = BEG||'12';
520       +         OUTPUT SPSFM6;
521       +         END;
522       +     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
523       +         ACTDTE = END||'01';
524       +         OUTPUT SPSFM7;
525       +         END;
526       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 2) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
SYMBOLGEN:  Macro variable ENDYR resolves to 18
527       +         ACTDTE = END||'02';
528       +         OUTPUT SPSFM8;
529       +         END;
530       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 3) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
                                                                 The SAS System

SYMBOLGEN:  Macro variable ENDYR resolves to 18
531       +         ACTDTE = END||'03';
532       +         OUTPUT SPSFM9;
533       +         END;
534       +     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
535       +         ACTDTE = END||'04';
536       +         OUTPUT SPSFM10;
537       +         END;
538       +     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
539       +         ACTDTE = END||'05';
540       +         OUTPUT SPSFM11;
541       +         END;
542       +     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
543       +         ACTDTE = END||'06';
544       +         OUTPUT SPSFM12;
545       +         END;
546       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      498:10   498:24   498:37   502:10   502:24   502:37   506:10   506:24   506:37   510:10   510:24   510:37   514:10   514:24   514:37
      518:10   518:24   518:37   522:9    522:26   522:40   526:9    526:26   526:40   530:9    530:26   530:40   534:9    534:26   534:40
      538:9    538:26   538:40   542:9    542:26   542: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.
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.
                                                                 The SAS System

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.29 seconds
      cpu time            0.29 seconds
      

547       +DATA SPS6;
548       +    SET SPSFM1
549       +        SPSFM2
550       +        SPSFM3
551       +        SPSFM4
552       +        SPSFM5
                                                                 The SAS System

553       +        SPSFM6
554       +        SPSFM7
555       +        SPSFM8
556       +        SPSFM9
557       +        SPSFM10
558       +        SPSFM11
559       +        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.34 seconds
      cpu time            0.34 seconds
      

560       +    PROC SORT; BY PROPNBR ACTDTE TRXNBR EFFMY;
561       +
562       +

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.35 seconds
                                                                 The SAS System

      cpu time            0.65 seconds
      

563       +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
564       +  SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
565       +    IF LAST.ACTDTE THEN OUTPUT SPS7X;
566       +

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.15 seconds
      cpu time            0.15 seconds
      

567       +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
568       +

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
      

569       +DATA SPS7;
570       + MERGE SPS7X(IN=A) SPS6(IN=B);
571       + BY PROPNBR ACTDTE TRXNBR;
572       + IF A AND B;
573       +

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.
                                                                 The SAS System

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.27 seconds
      cpu time            0.28 seconds
      

574       +PROC SORT DATA = SPS7;  BY ÃÛÌÒAPPID;
575       +

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.11 seconds
      cpu time            0.14 seconds
      

576       +PROC SQL;
577       +  CREATE TABLE DIRFILE AS
578       + SELECT INDIV_NAME     AS PI
579       +       ,ÃÛÌÒAPP_ID         AS ÃÛÌÒAPPID
580       + FROM DIR.NAME;
NOTE: Compressing data set WORK.DIRFILE decreased size by 1.51 percent. 
      Compressed is 12522 pages; un-compressed would require 12714 pages.
NOTE: Table WORK.DIRFILE created, with 1169646 rows and 2 columns.

581       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           2.38 seconds
      cpu time            1.32 seconds
      

582       +PROC SORT; BY ÃÛÌÒAPPID;
583       +

NOTE: There were 1169646 observations read from the data set WORK.DIRFILE.
                                                                 The SAS System

NOTE: The data set WORK.DIRFILE has 1169646 observations and 2 variables.
NOTE: Compressing data set WORK.DIRFILE decreased size by 1.51 percent. 
      Compressed is 12522 pages; un-compressed would require 12714 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.71 seconds
      cpu time            1.06 seconds
      

584       +DATA SPS8(KEEP=PI ÃÛÌÒAPPID DPT PROPNBR ACTDTE SHARE TASK INVTYPE);
585       +  MERGE DIRFILE(IN=A) SPS7(IN=B);
586       +  BY ÃÛÌÒAPPID;
587       +  IF B;
588       +
589       +/*PROC SQL;
590       +CREATE TABLE CODES AS
591       +SELECT CODE_TYPE AS CDTYPE
592       +      ,CODE_VALUE AS CODE
593       +      ,CODE_DESC AS CODENAME
594       +FROM COA.CODES
595       +WHERE CODE_TYPE = 'DA';
596       +
597       +PROC SORT DATA = CODES;
598       +  BY CODE;
599       +
600       +DATA NAMES(KEEP=DPT DPTNAME) COLNAME(KEEP=COLLEGE COLNAME);
601       + SET CODES;
602       +FORMAT COLLEGE DPT $5.;
603       +FORMAT COLNAME DPTNAME $35.;
604       + IF SUBSTR(CODE,4,2) = '  ' THEN DO;
605       +  COLLEGE = CODE;
606       +  COLNAME = CODENAME;
607       +  OUTPUT COLNAME;
608       + END;
609       + ELSE DO;
610       +  DPT = CODE;
611       +  DPTNAME = CODENAME;
612       +  OUTPUT NAMES;
613       + END;
                                                                 The SAS System

614       +
615       +PROC SORT DATA = NAMES;
616       +  BY DPT;
617       +
618       +PROC SORT DATA = SPS8;
619       +  BY DPT;
620       +
621       +DATA SPS9;
622       + MERGE NAMES(IN=A) SPS8(IN=B);
623       + BY DPT;
624       + IF B;
625       +  FORMAT DPTNAME $35.;
626       +  FORMAT COL $3.;
627       +  COL = SUBSTR(DPT,1,3);
628       +  COL1 = COL||'  ';
629       +  FORMAT COLLEGE $5.;
630       +  COLLEGE = COMPRESS(COL1);
631       +
632       +PROC SORT DATA = SPS9;
633       +  BY COLLEGE;
634       +
635       +PROC SORT DATA = COLNAME;
636       +  BY COLLEGE;
637       +
638       +DATA SPS10;
639       + MERGE COLNAME(IN=A) SPS9(IN=B);
640       + BY COLLEGE;
641       + IF B;*/
642       +

NOTE: There were 1169646 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.48 seconds
      cpu time            0.48 seconds
                                                                 The SAS System

      

643       +  proc sql;
644       +  create table ccdept as
645       +  select code_value1 as dpt,
646       +  code_value2 as CC
647       +  from spm.codes
648       +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
      

649       +proc sort; by  dpt;
650       +

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
      

651       +PROC SORT DATA = SPS8;
652       + BY dpt;
653       +

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):
                                                                 The SAS System

      real time           0.10 seconds
      cpu time            0.15 seconds
      

654       +data mrgcc; merge sps8(in=a) ccdept(in=b); by dpt; if a;

WARNING: Multiple lengths were specified for the BY variable DPT 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
      

655       +proc sort; by cc;
656       +

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.10 seconds
      cpu time            0.14 seconds
      

657       +proc sql;
658       +create table org as
659       +select org_id as CC,
660       +org_name as Cost_Center,
661       +superior_org as CC_Hier
662       +from wdm.organization
663       +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.
                                                                 The SAS System

NOTE: Table WORK.ORG created, with 1079 rows and 3 columns.

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

664       +proc sort;  BY CC;
665       +

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.00 seconds
      cpu time            0.00 seconds
      

666       +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.
NOTE: DATA statement used (Total process time):
      real time           0.21 seconds
      cpu time            0.21 seconds
      

667       +proc sort;  BY CC_Hier;
668       +

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. 
                                                                 The SAS System

      Compressed is 1338 pages; un-compressed would require 7145 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.27 seconds
      cpu time            0.42 seconds
      

669       +proc sql;
670       +create table org as
671       +select org_id as CC_Hier,
672       +org_name as Cost_Center_Hierarchy
673       +from wdm.organization
674       +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.00 seconds
      

675       +proc sort;  BY CC_Hier;
676       +

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. 
      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
      

677       +data mrgcc2; merge mrgcc2(in=a) org(in=b); by CC_Hier; if a;
678       +Cost_Center_Hierarchy = scan(Cost_Center_Hierarchy,-1,'|');
679       +Cost_Center = scan(Cost_Center,-1,'|');

NOTE: There were 135749 observations read from the data set WORK.MRGCC2.
                                                                 The SAS System

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.38 seconds
      cpu time            0.39 seconds
      

680       +proc sort;  BY PROPNBR ACTDTE TASK;
681       +
682       +

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.37 seconds
      cpu time            0.46 seconds
      

683       +PROC SORT DATA = GLSCOA15;
684       + BY PROPNBR ACTDTE TASK;
685       +

NOTE: There were 66 observations read from the data set WORK.GLSCOA15.
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: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

686       +PROC SQL;
687       + CREATE TABLE GLSSPS1 AS
688       + SELECT A.*,
                                                                 The SAS System

689       +        B.PI,
690       +        B.ÃÛÌÒAPPID,
691       +        B.INVTYPE,
692       +        B.SHARE,
693       +        B.Cost_Center_Hierarchy,
694       +        B.CC,
695       +        B.Cost_Center
696       +FROM GLSCOA15 A,
697       +     mrgcc2  B
698       +WHERE A.PROPNBR = B.PROPNBR AND
699       +      A.ACTDTE  = B.ACTDTE AND
700       +      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.

701       +
702       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           0.07 seconds
      cpu time            0.07 seconds
      

703       +DATA GLSSPS10(KEEP=PROPNBR ACTDTE); SET GLSSPS1; BY PROPNBR ACTDTE;
704       + IF FIRST.ACTDTE THEN OUTPUT;
705       +

NOTE: Compression was disabled for data set WORK.GLSSPS10 because compression overhead would increase the size of the data set.
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.00 seconds
      cpu time            0.00 seconds
      

706       +DATA GLSCOA10;
707       + MERGE GLSCOA15(IN=A) GLSSPS10(IN=B);
708       + BY PROPNBR ACTDTE;
                                                                 The SAS System

709       + IF A AND NOT B;
710       +

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
      

711       +DATA GLSSPS;
712       + SET GLSSPS1 GLSCOA10;
713       +
714       + IF SHARE = '.' THEN DO; ÃÛÌÒAPPIDNTOT = NAMT; ÃÛÌÒAPPIDCTOT = CAMT; END;
715       + ELSE DO;
716       + ÃÛÌÒAPPIDNTOT = NAMT * SHARE / 100; ÃÛÌÒAPPIDCTOT = CAMT * SHARE / 100;
717       + END;
718       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      714:13   
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 45 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
      

719       +PROC SORT; BY PROPNBR ACTDTE grant_id;
720       +

NOTE: There were 99 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 99 observations and 45 variables.
NOTE: Compressing data set WORK.GLSSPS decreased size by 71.43 percent. 
                                                                 The SAS System

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

721       +PROC SORT DATA = GLSSPS; BY PROPNBR grant_id ÃÛÌÒAPPID Cost_Center;
722       +

NOTE: There were 99 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 99 observations and 45 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
      

723       +DATA GLSSPS10; SET GLSSPS; BY PROPNBR grant_id ÃÛÌÒAPPID Cost_Center;
724       +format grant_name1 grant_name2 $35.;
725       +grant_name1 = scan(Grant_name,2,"|");
726       +Grant_name2 = scan(grant_name,3,"|");
727       +grant_name = strip(grant_name1)||" | "||strip(grant_name2);
728       + IF FIRST.Cost_Center THEN DO;
729       +  DEPTCAMT = CAMT;
730       +  DEPTNAMT = NAMT;
731       +  ÃÛÌÒAPPIDNSH = ÃÛÌÒAPPIDNTOT;
732       +  ÃÛÌÒAPPIDCSH = ÃÛÌÒAPPIDCTOT;
733       + END;
734       + ELSE DO;
735       +  DEPTCAMT = CAMT;
736       +  DEPTNAMT = NAMT;
737       +  ÃÛÌÒAPPIDNSH = ÃÛÌÒAPPIDNTOT;
738       +  ÃÛÌÒAPPIDCSH = ÃÛÌÒAPPIDCTOT;
739       + END;
740       + IF LAST.Cost_Center THEN DO;
741       +   ÃÛÌÒAPPIDNSH = ROUND(ÃÛÌÒAPPIDNSH,1.);
742       +   ÃÛÌÒAPPIDCSH = ROUND(ÃÛÌÒAPPIDCSH,1.);
                                                                 The SAS System

743       +   IF (ÃÛÌÒAPPIDNSH = 0 AND ÃÛÌÒAPPIDCSH = 0) THEN DELETE;
744       +   OUTPUT;
745       + END;
746       +

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

747       +PROC SORT; BY Cost_Center_Hierarchy Cost_Center PROPNBR grant_id;
748       +
749       +/*proc sql;
750       +create table test as
751       +select *
752       +from k2_wd.wd_fdm_translation_table;
753       +proc sort; by code_value;
754       +
755       +data test2 (keep=dept cost_center); set test; by code_value;
756       +dept= substr(code_value,1,5);
757       +proc sort; by dept;
758       +
759       +data test3; set test2; by dept;
760       +if last.dept then output;
761       +proc sort; by dept;*/
762       +
763       +

NOTE: There were 88 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 88 observations and 51 variables.
NOTE: Compressing data set WORK.GLSSPS10 decreased size by 73.91 percent. 
      Compressed is 6 pages; un-compressed would require 23 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
                                                                 The SAS System

      cpu time            0.01 seconds
      

764       +PROC TEMPLATE;
765       + DEFINE STYLE WHITE ;
766       + PARENT=STYLES.PRINTER;
767       + REPLACE COLOR_LIST /
768       +  'LINK' = BLUE
769       +  'BGH' = WHITE
770       +  'FG' = BLACK
771       +  'BG' = WHITE;
772       + END;
NOTE: STYLE 'White' has been saved to: WORK.TEMPLAT
773       + RUN;
NOTE: PROCEDURE TEMPLATE used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      

774       +
775       +*ODS PDF FILE=&PFILE NOTOC STYLE = WHITE ;
776       +
777       + %global _ODSDEST;
778       +%global _ODSSTYLE;
779       +
780       +%MACRO PRINT;
781       +OPTIONS ORIENTATION=LANDSCAPE;
782       +
783       +%IF (%UPCASE("&_ODSDEST") eq "PHTML")+ (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
784       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
785       +data _null_ ;
786       +	rc = stpsrv_header('Content-type','text/html');
787       +run ;
788       +ods listing close;
789       +ods html body=_webout style=WHITE;
790       +%END;
791       +
792       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
                                                                 The SAS System

793       +data _null_ ;
794       +	rc = stpsrv_header('Content-type','application/pdf') ;
795       +	rc = stpsrv_header('Content-disposition',"attachment; filename=&TME..pdf");
796       +run ;
797       +ods listing close;
798       +ods pdf file=_webout style=WHITE;
799       +%END;
800       +
801       +DATA _NULL_;
802       +    SET GLSSPS10 END=FINAL; BY Cost_Center_Hierarchy Cost_Center PROPNBR grant_id;
803       +    FILE PRINT HEADER=A ; options ls=160 pagesize=50;
804       +    NAM = TRIM(DPTNAME);
805       +      ATTLEN = LENGTH(NAM);
806       +      LEN = ATTLEN - 1 + 10;
807       +      UNDERLNE = REPEAT('_',LEN);
808       +    LONG = TRIM(LONG);
809       +
810       +    IF INTFLAG = 'Y' THEN DO;
811       +     NINTAMT = ÃÛÌÒAPPIDNSH;
812       +     CINTAMT = ÃÛÌÒAPPIDCSH;
813       +     NEXTAMT = 0;
814       +     CEXTAMT = 0;
815       +    END;
816       +    ELSE DO;
817       +     NINTAMT = 0;
818       +     CINTAMT = 0;
819       +     NEXTAMT = ÃÛÌÒAPPIDNSH;
820       +     CEXTAMT = ÃÛÌÒAPPIDCSH;
821       +    END;
822       +
823       +    GRAND + ÃÛÌÒAPPIDCSH + ÃÛÌÒAPPIDNSH;
824       +    CINTTOT + CINTAMT;
825       +    NINTTOT + NINTAMT;
826       +    CEXTTOT + CEXTAMT;
827       +    NEXTTOT + NEXTAMT;
828       +
829       +    IF FIRST.Cost_Center_Hierarchy THEN DO;
830       +    COLCINT = CINTAMT;
                                                                 The SAS System

831       +    COLNINT = NINTAMT;
832       +    COLCEXT = CEXTAMT;
833       +    COLNEXT = NEXTAMT;
834       +
835       +    PUT / @  5  Cost_Center_Hierarchy /;
836       +    END;
837       +
838       +    ELSE DO;
839       +     COLCINT + CINTAMT;
840       +     COLNINT + NINTAMT;
841       +     COLCEXT + CEXTAMT;
842       +     COLNEXT + NEXTAMT;
843       +    END;
844       +
845       +    IF FIRST.Cost_Center THEN DO;
846       +    DPTCINT = CINTAMT;
847       +    DPTNINT = NINTAMT;
848       +    DPTCEXT = CEXTAMT;
849       +    DPTNEXT = NEXTAMT;
850       +     PUT /      @1   CC '- ' Cost_Center //
851       +                @97   '  % '
852       +                @115   'INTERNAL'
853       +                @141  'EXTERNAL'/
854       +                @ 5   'INVESTIGATOR'
855       +                @25   'TITLE'
856       +                @58   'PROPOSAL #'
857       +                @69   'GRANT ID'
858       +                @96   'CREDIT'
859       +                @104  '       NEW         CONT'
860       +                @130  '       NEW         CONT'
861       +     OVERPRINT  @ 5   '___________________'
862       +                @25   '_______________________________'
863       +                @58   '__________'
864       +                @69   '_________'
865       +                @96 '______'
866       +                @104  '_______________________'
867       +                @130  '_______________________'        /
868       +                @ 1   INVTYPE $1.
                                                                 The SAS System

869       +                @ 5   PI $19.
870       +                @25   grant_name $31.
871       +                @57   PROPNBR 11.
872       +                @69   GRANT_ID $25.
873       +                @96   SHARE 6.2
874       +                @104  NINTAMT COMMA11.
875       +                @116 CINTAMT COMMA11.
876       +                @130  NEXTAMT COMMA11.
877       +                @142 CEXTAMT COMMA11./
878       +                @25   LONG   $31./;
879       +     END;
880       +
881       +    ELSE DO;
882       +    DPTCINT + CINTAMT;
883       +    DPTNINT + NINTAMT;
884       +    DPTCEXT + CEXTAMT;
885       +    DPTNEXT + NEXTAMT;
886       +   PUT       @ 1   INVTYPE $1.
887       +             @ 5   PI $19.
888       +             @25   grant_name $31.
889       +             @57   PROPNBR 11.
890       +             @69   GRANT_ID $25.
891       +             @96   SHARE 6.2
892       +             @104  NINTAMT COMMA11.
893       +             @116 CINTAMT COMMA11.
894       +             @130  NEXTAMT COMMA11.
895       +             @142 CEXTAMT COMMA11./
896       +             @25   LONG   $31./;
897       +    END;
898       +
899       +    IF LAST.Cost_Center THEN DO;
900       +    PUT        @1 /
901       +               @84 'TOTAL COST CENTER'
902       +               @104  DPTNINT DOLLAR11.
903       +               @116 DPTCINT DOLLAR11.
904       +               @130 DPTNEXT DOLLAR11.
905       +               @142 DPTCEXT DOLLAR11./;
906       +    END;
                                                                 The SAS System

907       +
908       +    IF LAST.Cost_Center_Hierarchy THEN DO;
909       +    PUT        @1 /
910       +               @84 'TOTAL CC HIERARCHY'
911       +               @104  COLNINT DOLLAR11.
912       +               @116 COLCINT DOLLAR11.
913       +               @130 COLNEXT DOLLAR11.
914       +               @142 COLCEXT DOLLAR11./;
915       +    PUT _PAGE_;
916       +    END;
917       +
918       +    IF FINAL THEN DO;
919       +    PUT        @1 /
920       +               @104 NINTTOT DOLLAR11.
921       +               @116 CINTTOT DOLLAR11.
922       +               @130 NEXTTOT DOLLAR11.
923       +               @142 CEXTTOT DOLLAR11.
924       +               @1 /
925       +               @66 'GRAND TOTAL'
926       +               @78  GRAND DOLLAR16./;
927       +    PUT _PAGE_;
928       +    END;
929       +
930       +RETURN;
931       +A:
932       +PUT            @97   '  % '
933       +               @115   'INTERNAL'
934       +               @141  'EXTERNAL'/
935       +               @ 5   'INVESTIGATOR'
936       +               @25   'TITLE'
937       +               @58   'PROPOSAL #'
938       +                @69   'GRANT ID'
939       +                @96   'CREDIT'
940       +                @104  '       NEW         CONT'
941       +                @130  '       NEW         CONT'
942       +     OVERPRINT  @ 5   '___________________'
943       +                @25   '_______________________________'
944       +                @58   '__________'
                                                                 The SAS System

945       +                @69   '_________'
946       +                @96 '______'
947       +                @104  '_______________________'
948       +                @130  '_______________________'        /;
949       +RETURN;
950       +
951       +TITLE 'MONTHLY REPORT OF SPONSORED AGREEMENTS';
952       +TITLE2 'BY COST CENTER AND CC HIERARCHY';
953       +TITLE3 "PROCESSED IN &MON &EFFYR";
954       +TITLE4 '  ';
955       +RUN;
956       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
957       +ods html close;
958       +%END;
959       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
960       +ods pdf close;
961       +%END;
962       +
963       +%END;
964       +%MEND PRINT;
965       +%PRINT;
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable TME resolves to    58925.046

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

NOTE: Writing ODS PDF output to DISK destination "_WEBOUT", printer "PDF".
WARNING: Variable LONG has already been defined as numeric.
WARNING: Variable LONG has already been defined as numeric.
SYMBOLGEN:  Macro variable MON resolves to JULY     
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      965:168   965:35    
NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      965:30   
NOTE: Variable DPTNAME is uninitialized.
NOTE: 368 lines were written to file PRINT.
NOTE: There were 88 observations read from the data set WORK.GLSSPS10.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      
                                                                         The SAS System


SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
NOTE: ODS PDF printed 21 pages to 148330E1-8B70-46B4-92DE-F47A450B49F6.
966       +
967       +*ODS PDF CLOSE;
968       +
969       +/*ODS HTML FILE=&HFILE STYLE=MINIMAL  RS=NONE ;
970       +
971       +DATA _NULL_;
972       +    SET GLSSPS10 END=FINAL; BY COLLEGE DPT PROPNBR ACCT;
973       +    FILE PRINT HEADER=A;
974       +    NAM = TRIM(DPTNAME);
975       +      ATTLEN = LENGTH(NAM);
976       +      LEN = ATTLEN - 1 + 10;
977       +      UNDERLNE = REPEAT('_',LEN);
978       +    LONG = TRIM(LONG);
979       +
980       +    IF INTFLAG = 'Y' THEN DO;
981       +     NINTAMT = ÃÛÌÒAPPIDNSH;
982       +     CINTAMT = ÃÛÌÒAPPIDCSH;
983       +     NEXTAMT = 0;
984       +     CEXTAMT = 0;
985       +    END;
986       +    ELSE DO;
987       +     NINTAMT = 0;
988       +     CINTAMT = 0;
989       +     NEXTAMT = ÃÛÌÒAPPIDNSH;
990       +     CEXTAMT = ÃÛÌÒAPPIDCSH;
991       +    END;
992       +
993       +    GRAND + ÃÛÌÒAPPIDCSH + ÃÛÌÒAPPIDNSH;
994       +    CINTTOT + CINTAMT;
995       +    NINTTOT + NINTAMT;
996       +    CEXTTOT + CEXTAMT;
997       +    NEXTTOT + NEXTAMT;
998       +
999       +    IF FIRST.COLLEGE THEN DO;
1000      +    COLCINT = CINTAMT;
1001      +    COLNINT = NINTAMT;
1002      +    COLCEXT = CEXTAMT;
1003      +    COLNEXT = NEXTAMT;
1004      +    PUT / @  5  COLLEGE '- ' COLNAME /;
1005      +    END;
1006      +
1007      +    ELSE DO;
1008      +     COLCINT + CINTAMT;
1009      +     COLNINT + NINTAMT;
                                                                         The SAS System

1010      +     COLCEXT + CEXTAMT;
1011      +     COLNEXT + NEXTAMT;
1012      +    END;
1013      +
1014      +    IF FIRST.DPT THEN DO;
1015      +    DPTCINT = CINTAMT;
1016      +    DPTNINT = NINTAMT;
1017      +    DPTCEXT = CEXTAMT;
1018      +    DPTNEXT = NEXTAMT;
1019      +     PUT /      @1   DPTNAME '- ' DPT //
1020      +                @81   '  % '
1021      +                @99   'INTERNAL'
1022      +                @125  'EXTERNAL'/
1023      +                @ 5   'INVESTIGATOR'
1024      +                @25   'TITLE'
1025      +                @58   'PROPOSAL #'
1026      +                @69   'ACCOUNT'
1027      +                @80   'CREDIT'
1028      +                @88  '       NEW         CONT'
1029      +                @114  '       NEW         CONT'
1030      +     OVERPRINT  @ 5   '___________________'
1031      +                @25   '_______________________________'
1032      +                @58   '__________'
1033      +                @69   '_________'
1034      +                @80 '______'
1035      +                @88  '_______________________'
1036      +                @114  '_______________________'        /
1037      +                @ 1   INVTYPE $1.
1038      +                @ 5   PI $19.
1039      +               @25   STITLE $31.
1040      +               @57   PROPNBR 11.
1041      +               @69   ACCT $9.
1042      +               @80   SHARE 6.2
1043      +               @88  NINTAMT COMMA11.
1044      +               @100 CINTAMT COMMA11.
1045      +               @114  NEXTAMT COMMA11.
1046      +               @126 CEXTAMT COMMA11./
1047      +               @25   LONG   $31./;
1048      +     END;
1049      +
1050      +    ELSE DO;
1051      +    DPTCINT + CINTAMT;
1052      +    DPTNINT + NINTAMT;
1053      +    DPTCEXT + CEXTAMT;
1054      +    DPTNEXT + NEXTAMT;
1055      +   PUT         @ 1   INVTYPE $1.
1056      +               @ 5   PI $24.
1057      +               @25   STITLE $35.
                                                                         The SAS System

1058      +               @57   PROPNBR 11.
1059      +               @69   ACCT $9.
1060      +               @80   SHARE 6.2
1061      +               @88  NINTAMT COMMA11.
1062      +               @100 CINTAMT COMMA11.
1063      +               @114  NEXTAMT COMMA11.
1064      +               @126 CEXTAMT COMMA11./
1065      +               @25   LONG   $31./;
1066      +    END;
1067      +
1068      +    IF LAST.DPT THEN DO;
1069      +    PUT        @1 /
1070      +               @68 'TOTAL DEPARTMENT'
1071      +               @88  DPTNINT DOLLAR11.
1072      +               @100 DPTCINT DOLLAR11.
1073      +               @114 DPTNEXT DOLLAR11.
1074      +               @126 DPTCEXT DOLLAR11./;
1075      +    END;
1076      +
1077      +    IF LAST.COLLEGE THEN DO;
1078      +    PUT        @1 /
1079      +               @75 'TOTAL COLLEGE'
1080      +               @88  COLNINT DOLLAR11.
1081      +               @100 COLCINT DOLLAR11.
1082      +               @114 COLNEXT DOLLAR11.
1083      +               @126 COLCEXT DOLLAR11./;
1084      +    PUT _PAGE_;
1085      +    END;
1086      +
1087      +    IF FINAL THEN DO;
1088      +    PUT        @1 /
1089      +               @88 NINTTOT DOLLAR11.
1090      +               @100 CINTTOT DOLLAR11.
1091      +               @114 NEXTTOT DOLLAR11.
1092      +               @126 CEXTTOT DOLLAR11.
1093      +               @1 /
1094      +               @50 'GRAND TOTAL'
1095      +               @62  GRAND DOLLAR16./;
1096      +    PUT _PAGE_;
1097      +    END;
1098      +
1099      +RETURN;
1100      +A:
1101      +PUT             @81   '  % '
1102      +                @99   'INTERNAL'
1103      +                @125  'EXTERNAL'/
1104      +                @ 5   'INVESTIGATOR'
1105      +                @25   'TITLE'
                                                                         The SAS System

1106      +                @58   'PROPOSAL #'
1107      +                @69   'ACCOUNT'
1108      +                @80   'CREDIT'
1109      +                @88  '       NEW         CONT'
1110      +                @114  '       NEW         CONT'
1111      +    OVERPRINT   @ 5   '___________________'
1112      +                @25   '_______________________________'
1113      +                @58   '__________'
1114      +                @69   '_________'
1115      +                @80 '______'
1116      +                @88  '_______________________'
1117      +                @114  '_______________________'        /;
1118      +RETURN;
1119      +
1120      +TITLE 'MONTHLY REPORT OF SPONSORED AGREEMENTS';
1121      +TITLE2 'BY COLLEGE AND DEPARTMENT';
1122      +TITLE3 "PROCESSED IN &MON &EFFYR";
1123      +TITLE4 '  ';
1124      +RUN;
1125      +
1126      +ODS HTML CLOSE;
1127      +
1128      +*  Begin EG generated code (do not edit this line);
1129      +;*';*";*/;quit;
1130      +
1131      +*  End EG generated code (do not edit this line);
1132      +
NOTE: %INCLUDE (level 1) ending.