SAS Log

1                                                                                                                        The SAS System                                                                                          09:11 Tuesday, January 16, 2018

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=20171231
 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=__unam=6bbc56c-15fdf384e5a-60cabe17-316; JSESSIONID=5C9847A8BCCC403F1640821F3CAFA122; sso-logout-time="Tue Jan 16 2018 16:59:27 GMT-0600 (Central Standard Time)"; LtpaToken=AAECAzVBNUUxN
     TgyNUE1RTgzQ0ZrdHdlZWRAbHN1LmVkdbT7pSB1GYc6t1BvWGWGMOgl9Mgv
 _HTUA=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36
 _METAFOLDER=/FSS/
 _METAPERSON=FSSGuest
 _METAUSER=FSSGuest@saspw
 _ODSDEST=PDF
 _PASSWORD=XXXXXX
 _PROGRAM=/FSS/FUNDCOL2
 _REPLAY="&_URL?_sessionid=DFE61070-2619-44AF-8CCE-B3C77B31CEF6&_program=replay&_entry=&_TMPCAT.."
 _REQMETH=POST
 _RESULT=STREAM
 _RMTADDR=130.39.74.110
 _RMTHOST=130.39.74.110
 _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\FUNDCOL2.sas is file D:\SAS Stored Processes\FSS\FUNDCOL2.sas.
2         +*  Begin EG generated code (do not edit this line);
3         +*
4         +*  Stored process registered by
5         +*  Enterprise Guide Stored Process Manager V5.1
6         +*
7         +*  ====================================================================
8         +*  Stored process name: FUNDCOL2
9         +*  ====================================================================
10        +*
11        +*  Stored process prompt dictionary:
12        +*  ____________________________________
13        +*  _ODSDEST
14        +*       Type: Text
15        +*      Label: _ODSDEST
16        +*       Attr: Visible
17        +*  ____________________________________
18        +*  EFFDTE
19        +*       Type: Text
20        +*      Label: EFFDTE
21        +*       Attr: Visible
22        +*  ____________________________________
23        +*;
24        +
25        +
26        +*ProcessBody;
27        +
28        +%global _ODSDEST
29        +        EFFDTE;
30        +
31        +OPTIONS VALIDVARNAME=ANY;
32        +
33        +%macro ExtendValidMemName;
34        +
35        +%if %sysevalf(&sysver>=9.3) %then options validmemname=extend;
36        +
37        +%mend ExtendValidMemName;
38        +
                                                                                          The SAS System

39        +%ExtendValidMemName;
40        +
41        +*  End EG generated code (do not edit this line);
42        +
43        +OPTIONS MISSING = ' '
44        +     LINESIZE=145 symbolgen;
45        +
46        +%GetÄ¢¹½tvUser
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _HTCOOK resolves to __unam=6bbc56c-15fdf384e5a-60cabe17-316; JSESSIONID=5C9847A8BCCC403F1640821F3CAFA122; 
            sso-logout-time="Tue Jan 16 2018 16:59:27 GMT-0600 (Central Standard Time)"; 
            LtpaToken=AAECAzVBNUUxNTgyNUE1RTgzQ0ZrdHdlZWRAbHN1LmVkdbT7pSB1GYc6t1BvWGWGMOgl9Mgv
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 AAECAzVBNUUxNTgyNUE1RTgzQ0ZrdHdlZWRAbHN1LmVkdbT7pSB1GYc6t1BvWGWGMOgl9Mgv
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw
SYMBOLGEN:  Macro variable _METAUSER resolves to FSSGuest@saspw

NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      46:118   46:240   
NOTE: The infile Ä¢¹½tv is:
      Filename=http://cgi.lsu.edu:8080/eis/servlet/getuser?LtpaToken=AAECAzVBNUUxNTgyNUE1RTgzQ0ZrdHdlZWRAbHN1LmVkdbT7pSB1GYc6t1BvWGWGMOgl9Mgv,
      Local Host Name=SASDCOMPUTE,
      Local Host IP addr=fe80::602f:416e:d266:b362%11,
      Service Hostname Name=cgi.uis.lsu.edu,
      Service IP addr=130.39.20.36,Service Name=N/A,
      Service Portno=8080,Lrecl=2000,Recfm=Stream

NOTE: 1 record was read from the infile Ä¢¹½tv.
      The minimum record length was 33.
      The maximum record length was 33.
NOTE: DATA statement used (Total process time):
                                                                 The SAS System

      real time           0.01 seconds
      cpu time            0.00 seconds
      

**END*USEREND*USER**


SYMBOLGEN:  Macro variable _Ä¢¹½tvPERSON resolves to Keri M Tweed
SYMBOLGEN:  Macro variable _Ä¢¹½tvUSER resolves to ktweed
****  This stored process was requested by Keri M Tweed with Ä¢¹½tvUSERID: ktweed


**END*USEREND*USER**
SYMBOLGEN:  Macro variable _INFILE resolves to            0
SYMBOLGEN:  Macro variable _INUSER resolves to            1
47        +  *** ENTER EFFECTIVE DATE ***;
48        +*%LET EFFDTE = 20170626;
49        +
50        +DATA DATE;
51        +  EFFDTE  = "&EFFDTE";
SYMBOLGEN:  Macro variable EFFDTE resolves to 20171231
52        +  EFFDTEX = INPUT(PUT(EFFDTE,8.),$8.);
53        +  FORMAT EFFYR $4.;
54        +  EFFYR = SUBSTR(EFFDTEX,1,4);
55        +  EFFMN = SUBSTR(EFFDTEX,5,2);
56        +  IF EFFMN < 7 THEN FISCAL = EFFYR;
57        +   ELSE FISCAL = EFFYR + 1;
58        +     FYEARX = COMPRESS("'"||TRIM(FISCAL)||"'");
59        +     FYRX = "'"||SUBSTR(FYEARX,4,2)||"'";
60        +     PDATE = COMPRESS(EFFYR) || COMPRESS(EFFMN);
61        +/*PFILE = "'ACGR14.PROD.PDF(V" || COMPRESS(PDATE) || ")'";
62        +     CALL SYMPUT('PFILE',PFILE);
63        +HFILE = "'ACGR14.PROD.HTML(V" || COMPRESS(PDATE) || ")'";
64        +     CALL SYMPUT ('HFILE', HFILE);*/
65        +     CALL SYMPUT('FYR',FYRX);
66        +     CALL SYMPUT('FYEAR',FYEARX);
67        +     CALL SYMPUT('EFFMN',EFFMN);
68        +     CALL SYMPUT('EFFYR',EFFYR);
                                                                 The SAS System

69        +     CALL SYMPUT('FISCAL',FISCAL);
70        +	 	 TME = TIME();
71        +	CALL SYMPUT('TME',TME);
72        +
73        +if EFFMN > 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        +
80        +IF EFFMN = 01 THEN MON = 'JANUARY  ';
81        +IF EFFMN = 02 THEN MON = 'FEBRUARY ';
82        +IF EFFMN = 03 THEN MON = 'MARCH    ';
83        +IF EFFMN = 04 THEN MON = 'APRIL    ';
84        +IF EFFMN = 05 THEN MON = 'MAY      ';
85        +IF EFFMN = 06 THEN MON = 'JUNE     ';
86        +IF EFFMN = 07 THEN MON = 'JULY     ';
87        +IF EFFMN = 08 THEN MON = 'AUGUST   ';
88        +IF EFFMN = 09 THEN MON = 'SEPTEMBER';
89        +IF EFFMN = 10 THEN MON = 'OCTOBER  ';
90        +IF EFFMN = 11 THEN MON = 'NOVEMBER ';
91        +IF EFFMN = 12 THEN MON = 'DECEMBER ';
92        + CALL SYMPUT('MON',MON);
93        +
94        +BEGFY=FISCAL-1;
95        +BEGFX = INPUT(PUT(BEGFY,4.),$4.);
96        +FISX = INPUT(PUT(FISCAL,4.),$4.);
97        +FORMAT BEGYR ENDYR $2.;
98        +BEGYR = SUBSTR(BEGFX,3,2);
99        +ENDYR = SUBSTR(FISX,3,2);
100       +CALL SYMPUT('BEGYR',BEGYR);
101       +CALL SYMPUT('ENDYR',ENDYR);
102       +
103       +     IF EFFMN = 01 THEN HEADER = '  JANUARY';
104       +ELSE IF EFFMN = 02 THEN HEADER = ' FEBRUARY';
105       +ELSE IF EFFMN = 03 THEN HEADER = '    MARCH';
                                                                 The SAS System

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

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      56:6    57:18   73:4    73:47   75:15   80:4    81:4    82:4    83:4    84:4    85:4    86:4    87:4    88:4    89:4    90:4    91:4
      94:7    103:9   104:9   105:9   106:9   107:9   108:9   109:9   110:9   111:9   112:9   113:9   114:9   
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      57:24   71:20   73:53   77:23   94: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.00 seconds
      cpu time            0.00 seconds
      

116       +proc sort; by effmn;
117       +
118       +/*LIBNAME COA DB2 AUTHID=COA SSID=DB2;
119       +LIBNAME SPM DB2 AUTHID=SPM SSID=DB2;
120       +LIBNAME DIR DB2 AUTHID=DIR SSID=DB2;*/
121       +
122       +/ LEGACY COA INFORMATION ****
123       +PROC SQL;
124       + CREATE TABLE COAFILE AS
125       + SELECT P_I_Ä¢¹½tv_ID          AS PIID
126       +       ,ACCT_CODE           AS ACCT
127       +       ,AGENCY_CD           AS AGENCY
128       +       ,GRANT_EXPIRE_DATE   AS EXPIRE
129       +       ,PROPOSAL_NBR        AS PROPNBR
                                                                 The SAS System

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

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
      

143       +PROC SQL;
144       +CREATE TABLE FUND1 AS
145       +SELECT ORG_ID AS GRANT_ID,
146       +FUND
147       +FROM WDM.fin_fdm_DRIVERTAG
148       +WHERE FUND IN ('FD250','FD251','FD252');
NOTE: Compressing data set WORK.FUND1 decreased size by 47.71 percent. 
      Compressed is 57 pages; un-compressed would require 109 pages.
NOTE: Table WORK.FUND1 created, with 6300 rows and 2 columns.

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

                                                                 The SAS System

149       +PROC SORT; BY GRANT_ID;
150       +

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

151       +PROC SQL;
152       +CREATE TABLE GRANT1 AS
153       +SELECT GRANT_ID,
154       +AWARD_NUMBER as award_budg,
155       +TO_DATE AS GRANT_EXP_DATE,
156       +sponsor_id,
157       +cont_line_status,
158       +workday_id,
159       +CONT_STATUS,
160       +is_primary
161       +FROM WDM.FIN_AWD_LINE
162       +where company = '10' and cont_status NE ' ';
NOTE: Compressing data set WORK.GRANT1 decreased size by 35.37 percent. 
      Compressed is 53 pages; un-compressed would require 82 pages.
NOTE: Table WORK.GRANT1 created, with 3725 rows and 8 columns.

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

163       +PROC SORT; BY GRANT_ID;
164       +

NOTE: There were 3725 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.GRANT1 has 3725 observations and 8 variables.
                                                                 The SAS System

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

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

NOTE: There were 6300 observations read from the data set WORK.FUND1.
NOTE: There were 3725 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.MRG1 has 3225 observations and 9 variables.
NOTE: Compressing data set WORK.MRG1 decreased size by 43.10 percent. 
      Compressed is 33 pages; un-compressed would require 58 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

166       +PROC SORT; BY sponsor_id;
167       +

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

168       +proc sql;
169       +create table SPON as
170       +select sponsor_id,
171       +SPONSOR_NAME,
172       +sponsor_type
173       +from wdm.fin_awd_sponsor;
NOTE: Compressing data set WORK.SPON decreased size by 68.57 percent. 
                                                                 The SAS System

      Compressed is 11 pages; un-compressed would require 35 pages.
NOTE: Table WORK.SPON created, with 1651 rows and 3 columns.

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

174       +proc sort; by sponsor_id;
175       +

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

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

NOTE: There were 3225 observations read from the data set WORK.MRG1.
NOTE: There were 1651 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSPON has 3225 observations and 11 variables.
NOTE: Compressing data set WORK.MRGSPON decreased size by 63.89 percent. 
      Compressed is 39 pages; un-compressed would require 108 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

NOTE: There were 3225 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.MRGSPON has 3225 observations and 11 variables.
NOTE: Compressing data set WORK.MRGSPON decreased size by 63.89 percent. 
                                                                 The SAS System

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

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

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

181       +proc sort; by workday_id;
182       +

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

183       +proc sql;
184       +create table task as
185       +select workday_id,
186       +org_id as tasknbr
187       +from WDM.FIN_AWD_LINE_ORG
188       +where substr(org_id,1,2) = 'TA';
NOTE: Compressing data set WORK.TASK decreased size by 22.61 percent. 
      Compressed is 89 pages; un-compressed would require 115 pages.
                                                                 The SAS System

NOTE: Table WORK.TASK created, with 6596 rows and 2 columns.

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

189       +proc sort; by workday_id;
190       +

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

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

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

193       +proc sort; by award_budg;
194       +

NOTE: There were 3220 observations read from the data set WORK.MRGGRNT.
NOTE: The data set WORK.MRGGRNT has 3220 observations and 12 variables.
NOTE: Compressing data set WORK.MRGGRNT decreased size by 64.66 percent. 
                                                                 The SAS System

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

195       +PROC SQL;
196       +CREATE TABLE AWARD1 AS
197       +SELECT AWARD_NUMBER as award_budg,
198       +PROPOSAL_ID as propnbr,
199       +AWARD_NAME,
200       +signed_date,
201       +TOTAL_AMOUNT AS AWD_TOTAL,
202       +award_date
203       +FROM WDM.FIN_AWD
204       +WHERE PROPOSAL_ID NE 0 and
205       +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 75.71 percent. 
      Compressed is 17 pages; un-compressed would require 70 pages.
NOTE: Table WORK.AWARD1 created, with 1999 rows and 6 columns.

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

206       +PROC SORT; BY award_budg;
207       +

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

                                                                 The SAS System

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

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      210:8   
NOTE: There were 3220 observations read from the data set WORK.MRGGRNT.
NOTE: There were 1999 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.MRG2 has 2886 observations and 18 variables.
NOTE: Compressing data set WORK.MRG2 decreased size by 73.43 percent. 
      Compressed is 55 pages; un-compressed would require 207 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

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

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

260       +proc sql;
                                                                 The SAS System

261       +CREATE TABLE SPEC AS
262       +SELECT AWARD_NUMBER as award_budg,
263       +REF_ID
264       +FROM WDM.FIN_AWD_SPEC_COND
265       +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 55 rows and 2 columns.

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

266       +PROC SORT; BY award_budg;
267       +

NOTE: There were 55 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.SPEC has 55 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
      

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

NOTE: There were 2886 observations read from the data set WORK.MRG2.
NOTE: There were 55 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.MRG5 has 2886 observations and 19 variables.
NOTE: Compressing data set WORK.MRG5 decreased size by 79.09 percent. 
      Compressed is 55 pages; un-compressed would require 263 pages.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

                                                                 The SAS System

269       +PROC SORT; BY award_budg grant_id;
270       +

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

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

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

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

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

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

313       +PROC SQL;
314       +CREATE TABLE BUDG AS
315       +SELECT grant_id,
316       +grant_name,
317       +ledger_account,
318       +budget_revenue as AMT,
                                                                 The SAS System

319       +budget_obj,
320       +award_name,
321       +award_report_code as BAADJCD,
322       +budget_amendment_date,
323       +budget_date_from
324       +from workday.award_budget
325       +where ledger_account in ('4200:Federal Grants and Contracts Revenue','4210:State and Local Grants and Contracts Revenue',
326       +'4220:Non-governmental Grants and Contracts Revenue','4230:Grants and Contracts Revenue') and budget_amendment_status not in
326      !+('Canceled','Draft','Denied')
327       +and company_code = 'Ä¢¹½tvAM' and
328       +award_report_code in ('New','Continuation') ;
NOTE: Compressing data set WORK.BUDG decreased size by 62.63 percent. 
      Compressed is 37 pages; un-compressed would require 99 pages.
NOTE: Table WORK.BUDG created, with 1580 rows and 9 columns.

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

329       +proc sort; by grant_id;
330       +

NOTE: There were 1580 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.BUDG has 1580 observations and 9 variables.
NOTE: Compressing data set WORK.BUDG 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
      

331       +data set1; set budg; by grant_id;
332       +format BUDGET_DATE1 yymmddn.;
333       +budget_date1 = budget_amendment_date;
334       +award_budg = scan(budget_obj,1,":");

NOTE: There were 1580 observations read from the data set WORK.BUDG.
                                                                 The SAS System

NOTE: The data set WORK.SET1 has 1580 observations and 11 variables.
NOTE: Compressing data set WORK.SET1 decreased size by 68.85 percent. 
      Compressed is 38 pages; un-compressed would require 122 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

335       +proc sort; by award_budg grant_id;
336       +

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

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

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

                                                                 The SAS System

341       +proc sort; by grant_id budget_date;
342       +

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

343       +data marge1; set marge; by grant_id budget_date;
344       +effdte = INPUT(PUT(budget_date,yymmddn.),8.);
345       +
346       +*if effdte <= 20160930 then output;

NOTE: There were 1576 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE1 has 1576 observations and 29 variables.
NOTE: Compressing data set WORK.MARGE1 decreased size by 74.34 percent. 
      Compressed is 58 pages; un-compressed would require 226 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

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


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

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

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

NOTE: There were 1576 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.BUDG1 has 550 observations and 33 variables.
NOTE: Compressing data set WORK.BUDG1 decreased size by 72.15 percent. 
      Compressed is 22 pages; un-compressed would require 79 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

417       +PROC SORT DATA = budg1; BY ACTDTE grant_id;
418       +

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

419       +DATA GLSCOA15(DROP=AMT MONAMT); SET budg1;
420       + BY ACTDTE grant_id;
421       + IF FIRST.grant_id THEN DO;
422       +         IF BAADJCD = 'New' THEN DO;
423       +                   NACCTAMT = AMT; NTOTMON = MONAMT;
424       +                   CACCTAMT = 0; CTOTMON = 0;
425       +         END;
426       +         IF BAADJCD = 'Continuation' THEN DO;
427       +                   NACCTAMT = 0; NTOTMON = 0;
428       +                   CACCTAMT = AMT; CTOTMON = MONAMT;
429       +         END;
430       + END;
431       + ELSE DO;
432       +           IF BAADJCD = 'New' THEN DO;
433       +                     NACCTAMT + AMT; NTOTMON + MONAMT;
434       +                     CACCTAMT + 0; CTOTMON + 0;
435       +           END;
                                                                 The SAS System

436       +           IF BAADJCD = 'Continuation' THEN DO;
437       +                     NACCTAMT + 0; NTOTMON + 0;
438       +                     CACCTAMT + AMT; CTOTMON + MONAMT;
439       +           END;
440       + END;
441       + IF LAST.grant_id THEN OUTPUT;

NOTE: There were 550 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 534 observations and 35 variables.
NOTE: Compressing data set WORK.GLSCOA15 decreased size by 71.43 percent. 
      Compressed is 22 pages; un-compressed would require 77 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

442       + proc sort; by grant_id;
443       +

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

444       + data glscoa16; set glscoa15; by grant_id;
445       + if (NACCTAMT = 0 and NTOTMON = 0 and CACCTAMT = 0 and CTOTMON = 0) then delete;

NOTE: There were 534 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA16 has 528 observations and 35 variables.
NOTE: Compressing data set WORK.GLSCOA16 decreased size by 72.37 percent. 
      Compressed is 21 pages; un-compressed would require 76 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
                                                                 The SAS System

      

446       + proc sort; by grant_id;
447       +
448       +

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

449       +PROC SQL;
450       +  CREATE TABLE PROJTRAN AS
451       +SELECT PROPOSAL_NBR     AS PROPNBR
452       +      ,TRX_NBR          AS TRXNBR
453       +      ,TRX_TYPE         AS TRXTYPE
454       +      ,TRX_STATUS       AS TRXSTAT
455       +      ,TO_SPA_DATE      AS RELDATE
456       +FROM SPM.PROJ_TRANSACTION
457       + WHERE TRX_STATUS IN ('AC','TE','CO');
NOTE: Compressing data set WORK.PROJTRAN decreased size by 2.05 percent. 
      Compressed is 143 pages; un-compressed would require 146 pages.
NOTE: Table WORK.PROJTRAN created, with 18256 rows and 5 columns.

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

459       +PROC SORT; BY PROPNBR TRXNBR RELDATE;
460       +

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

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

461       +DATA SPS2;
462       + SET PROJTRAN; BY PROPNBR TRXNBR;
463       +    LENGTH MO YY $2.;
464       +    LENGTH YR $4.;
465       +    MO=MONTH(RELDATE);
466       +    YR=YEAR(RELDATE);
467       +    YY=SUBSTR(YR,3,2);
468       +    LENGTH EFFMY $4.;
469       +    EFFMY=YY||MO;
470       +    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).
      465:8   466: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).
      211 at 465:8   211 at 466:8   
NOTE: There were 18256 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.SPS2 has 18256 observations and 9 variables.
NOTE: Compressing data set WORK.SPS2 increased size by 8.24 percent. 
      Compressed is 197 pages; un-compressed would require 182 pages.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

471       +    PROC SORT; BY PROPNBR EFFMY RELDATE;
472       +

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

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

473       + PROC SORT; BY PROPNBR TRXNBR;
474       +

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

475       +PROC SQL;
476       +    CREATE TABLE PISHR AS
477       +    SELECT PROPOSAL_NBR    AS PROPNBR,
478       +           TRX_NBR         AS TRXNBR,
479       +           TASK_NBR        AS TASK,
480       +           Ä¢¹½tv_ID          AS Ä¢¹½tvID,
481       +           INVESTIGATOR_TYPE AS INVTYPE,
482       +           DEPT_CD         AS DEPT,
483       +           PROJECT_SHARE   AS SHARE
484       +    FROM SPM.PROJ_INVESTIGATOR
485       +    WHERE PROJECT_SHARE > 0;
NOTE: Compressing data set WORK.PISHR decreased size by 6.69 percent. 
      Compressed is 837 pages; un-compressed would require 897 pages.
NOTE: Table WORK.PISHR created, with 75272 rows and 7 columns.

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


486       +    PROC SORT; BY PROPNBR TRXNBR TASK;
487       +

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

488       +DATA SPS4;
489       +  MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
490       +

NOTE: There were 18256 observations read from the data set WORK.SPS2.
NOTE: There were 75272 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.SPS4 has 32140 observations and 14 variables.
NOTE: Compressing data set WORK.SPS4 decreased size by 7.30 percent. 
      Compressed is 533 pages; un-compressed would require 575 pages.
NOTE: DATA statement used (Total process time):
      real time           0.06 seconds
      cpu time            0.06 seconds
      

491       +PROC SORT;  BY PROPNBR EFFMY RELDATE;
492       +

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


493       +    PROC SORT; BY PROPNBR TRXNBR;
494       +

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

495       +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
496       +     SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
497       +     SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
498       +     SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
499       +     SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
500       +     SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
501       +     SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
502       +     SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
503       +     SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
504       +     SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
505       +     SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
506       +     SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
507       +     SET SPS4;
508       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 18
509       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 17
510       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
511       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
512       +     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
513       +         ACTDTE = BEG||'07';
514       +         OUTPUT SPSFM1;
515       +         END;
                                                                 The SAS System

516       +     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
517       +         ACTDTE = BEG||'08';
518       +         OUTPUT SPSFM2;
519       +         END;
520       +     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
521       +         ACTDTE = BEG||'09';
522       +         OUTPUT SPSFM3;
523       +         END;
524       +     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
525       +         ACTDTE = BEG||'10';
526       +         OUTPUT SPSFM4;
527       +         END;
528       +     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
529       +         ACTDTE = BEG||'11';
530       +         OUTPUT SPSFM5;
531       +         END;
532       +     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
533       +         ACTDTE = BEG||'12';
534       +         OUTPUT SPSFM6;
535       +         END;
536       +     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
537       +         ACTDTE = END||'01';
538       +         OUTPUT SPSFM7;
539       +         END;
540       +     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
541       +         ACTDTE = END||'02';
542       +         OUTPUT SPSFM8;
543       +         END;
544       +     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
545       +         ACTDTE = END||'03';
546       +         OUTPUT SPSFM9;
547       +         END;
548       +     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
549       +         ACTDTE = END||'04';
550       +         OUTPUT SPSFM10;
551       +         END;
552       +     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
553       +         ACTDTE = END||'05';
554       +         OUTPUT SPSFM11;
555       +         END;
556       +     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
557       +         ACTDTE = END||'06';
558       +         OUTPUT SPSFM12;
559       +         END;
560       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      512:10   512:24   512:37   516:10   516:24   516:37   520:10   520:24   520:37   524:10   524:24   524:37   528:10   528:24   528:37
      532:10   532:24   532:37   536:9    536:26   536:40   540:9    540:26   540:40   544:9    544:26   544:40   548:9    548:26   548:40
      552:9    552:26   552:40   556:9    556:26   556:40   
NOTE: There were 32140 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 31352 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 31504 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 31780 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM4 decreased size by 12.65 percent. 
      Compressed is 497 pages; un-compressed would require 569 pages.
NOTE: The data set WORK.SPSFM5 has 31933 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM5 decreased size by 12.61 percent. 
      Compressed is 499 pages; un-compressed would require 571 pages.
NOTE: The data set WORK.SPSFM6 has 32056 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM6 decreased size by 12.57 percent. 
      Compressed is 501 pages; un-compressed would require 573 pages.
NOTE: The data set WORK.SPSFM7 has 32129 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM7 decreased size by 12.70 percent. 
      Compressed is 502 pages; un-compressed would require 575 pages.
NOTE: The data set WORK.SPSFM8 has 32129 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM8 decreased size by 12.70 percent. 
      Compressed is 502 pages; un-compressed would require 575 pages.
NOTE: The data set WORK.SPSFM9 has 32129 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM9 decreased size by 12.70 percent. 
      Compressed is 502 pages; un-compressed would require 575 pages.
NOTE: The data set WORK.SPSFM10 has 32129 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM10 decreased size by 12.70 percent. 
      Compressed is 502 pages; un-compressed would require 575 pages.
NOTE: The data set WORK.SPSFM11 has 32129 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM11 decreased size by 12.70 percent. 
      Compressed is 502 pages; un-compressed would require 575 pages.
NOTE: The data set WORK.SPSFM12 has 32129 observations and 12 variables.
NOTE: Compressing data set WORK.SPSFM12 decreased size by 12.70 percent. 
      Compressed is 502 pages; un-compressed would require 575 pages.
NOTE: DATA statement used (Total process time):
      real time           0.29 seconds
      cpu time            0.29 seconds
      

                                                                 The SAS System

561       +DATA SPS6;
562       +    SET SPSFM1
563       +        SPSFM2
564       +        SPSFM3
565       +        SPSFM4
566       +        SPSFM5
567       +        SPSFM6
568       +        SPSFM7
569       +        SPSFM8
570       +        SPSFM9
571       +        SPSFM10
572       +        SPSFM11
573       +        SPSFM12;

NOTE: There were 31172 observations read from the data set WORK.SPSFM1.
NOTE: There were 31352 observations read from the data set WORK.SPSFM2.
NOTE: There were 31504 observations read from the data set WORK.SPSFM3.
NOTE: There were 31780 observations read from the data set WORK.SPSFM4.
NOTE: There were 31933 observations read from the data set WORK.SPSFM5.
NOTE: There were 32056 observations read from the data set WORK.SPSFM6.
NOTE: There were 32129 observations read from the data set WORK.SPSFM7.
NOTE: There were 32129 observations read from the data set WORK.SPSFM8.
NOTE: There were 32129 observations read from the data set WORK.SPSFM9.
NOTE: There were 32129 observations read from the data set WORK.SPSFM10.
NOTE: There were 32129 observations read from the data set WORK.SPSFM11.
NOTE: There were 32129 observations read from the data set WORK.SPSFM12.
NOTE: The data set WORK.SPS6 has 382571 observations and 12 variables.
NOTE: Compressing data set WORK.SPS6 decreased size by 12.92 percent. 
      Compressed is 5950 pages; un-compressed would require 6833 pages.
NOTE: DATA statement used (Total process time):
      real time           0.34 seconds
      cpu time            0.34 seconds
      

574       +    PROC SORT; BY PROPNBR ACTDTE TRXNBR EFFMY;
575       +
576       +

                                                                 The SAS System

NOTE: There were 382571 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS6 has 382571 observations and 12 variables.
NOTE: Compressing data set WORK.SPS6 decreased size by 12.85 percent. 
      Compressed is 5955 pages; un-compressed would require 6833 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.35 seconds
      cpu time            0.65 seconds
      

577       +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
578       +  SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
579       +    IF LAST.ACTDTE THEN OUTPUT SPS7X;
580       +

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

581       +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
582       +

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

583       +DATA SPS7;
584       + MERGE SPS7X(IN=A) SPS6(IN=B);
585       + BY PROPNBR ACTDTE TRXNBR;
                                                                 The SAS System

586       + IF A AND B;
587       +

NOTE: There were 93187 observations read from the data set WORK.SPS7X.
NOTE: There were 382571 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7 has 136417 observations and 12 variables.
NOTE: Compressing data set WORK.SPS7 decreased size by 12.97 percent. 
      Compressed is 2121 pages; un-compressed would require 2437 pages.
NOTE: DATA statement used (Total process time):
      real time           0.29 seconds
      cpu time            0.29 seconds
      

588       +PROC SORT DATA = SPS7;  BY Ä¢¹½tvID;
589       +

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

590       +PROC SQL;
591       +  CREATE TABLE DIRFILE AS
592       + SELECT INDIV_NAME     AS PI
593       +       ,Ä¢¹½tv_ID         AS Ä¢¹½tvID
594       + FROM DIR.NAME;
NOTE: Compressing data set WORK.DIRFILE decreased size by 1.52 percent. 
      Compressed is 12735 pages; un-compressed would require 12932 pages.
NOTE: Table WORK.DIRFILE created, with 1189635 rows and 2 columns.

595       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           2.38 seconds
      cpu time            1.38 seconds
                                                                 The SAS System

      

596       +PROC SORT; BY Ä¢¹½tvID;
597       +

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

598       +DATA SPS8(KEEP=PI Ä¢¹½tvID DEPT PROPNBR ACTDTE SHARE TASK INVTYPE);
599       +  MERGE DIRFILE(IN=A) SPS7(IN=B);
600       +  BY Ä¢¹½tvID;
601       +  IF B;
602       +
603       +/*PROC SQL;
604       +CREATE TABLE CODES AS
605       +SELECT CODE_TYPE AS CDTYPE
606       +      ,CODE_VALUE AS CODE
607       +      ,CODE_DESC AS CODENAME
608       +FROM COA.CODES
609       +WHERE CODE_TYPE = 'DA';
610       +
611       +PROC SORT DATA = CODES;
612       +  BY CODE;
613       +
614       +DATA NAMES(KEEP=DPT DPTNAME) COLNAME(KEEP=COLLEGE COLNAME);
615       + SET CODES;
616       +FORMAT COLLEGE DPT $5.;
617       +FORMAT COLNAME DPTNAME $35.;
618       + IF SUBSTR(CODE,4,2) = '  ' THEN DO;
619       +  COLLEGE = CODE;
620       +  COLNAME = CODENAME;
621       +  OUTPUT COLNAME;
                                                                 The SAS System

622       + END;
623       + ELSE DO;
624       +  DPT = CODE;
625       +  DPTNAME = CODENAME;
626       +  OUTPUT NAMES;
627       + END;
628       +
629       +PROC SORT DATA = NAMES;
630       +  BY DPT;
631       +
632       +PROC SORT DATA = SPS8;
633       +  BY DPT;
634       +
635       +DATA SPS9;
636       + MERGE NAMES(IN=A) SPS8(IN=B);
637       + BY DPT;
638       + IF B;
639       +  FORMAT DPTNAME $35.;
640       +  FORMAT COL $3.;
641       +  COL = SUBSTR(DPT,1,3);
642       +  COL1 = COL||'  ';
643       +  FORMAT COLLEGE $5.;
644       +  COLLEGE = COMPRESS(COL1);
645       +
646       +PROC SORT DATA = SPS9;
647       +  BY COLLEGE;
648       +
649       +PROC SORT DATA = COLNAME;
650       +  BY COLLEGE;
651       +
652       +DATA SPS10A;
653       + MERGE COLNAME(IN=A) SPS9(IN=B);
654       + BY COLLEGE;
655       + IF B;
656       +
657       +*DATA TEST; *SET SPS10A; *IF SUBSTR(COLLEGE,1,1) IN('3','9');
658       +
659       +DATA SPS10; SET SPS10A;
                                                                 The SAS System

660       +  IF SUBSTR(COLLEGE,1,1) = '3' THEN DO;
661       +    COLLEGE = '300';
662       +    COLNAME = 'PBRC';
663       +  END;
664       +  IF SUBSTR(COLLEGE,1,1) = '9' THEN DO;
665       +    COLLEGE = '900';
666       +    COLNAME = 'AG CENTER';
667       +  END;*/
668       +

NOTE: There were 1189635 observations read from the data set WORK.DIRFILE.
NOTE: There were 136417 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS8 has 136417 observations and 8 variables.
NOTE: Compressing data set WORK.SPS8 decreased size by 19.32 percent. 
      Compressed is 1090 pages; un-compressed would require 1351 pages.
NOTE: DATA statement used (Total process time):
      real time           0.51 seconds
      cpu time            0.51 seconds
      

669       +  proc sql;
670       +  create table ccdept as
671       +  select code_value1 as dept,
672       +  code_value2 as CC
673       +  from spm.codes
674       +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
      

675       +proc sort; by  dept;
676       +

                                                                 The SAS System

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
      

677       +PROC SORT DATA = SPS8;
678       + BY dept;
679       +

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

680       +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 136417 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 136417 observations and 9 variables.
NOTE: Compressing data set WORK.MRGCC decreased size by 17.72 percent. 
      Compressed is 1221 pages; un-compressed would require 1484 pages.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.14 seconds
      

681       +proc sort; by cc;
682       +

                                                                 The SAS System

NOTE: There were 136417 observations read from the data set WORK.MRGCC.
NOTE: The data set WORK.MRGCC has 136417 observations and 9 variables.
NOTE: Compressing data set WORK.MRGCC decreased size by 17.72 percent. 
      Compressed is 1221 pages; un-compressed would require 1484 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.12 seconds
      cpu time            0.17 seconds
      

683       +proc sql;
684       +create table org as
685       +select org_id as CC,
686       +org_name as Cost_Center,
687       +superior_org as CC_Hier
688       +from wdm.organization
689       +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 1081 rows and 3 columns.

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

690       +proc sort;  BY CC;
691       +

NOTE: There were 1081 observations read from the data set WORK.ORG.
NOTE: The data set WORK.ORG has 1081 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
      

692       +data mrgcc2; merge mrgcc(in=a) org(in=b); by cc; if a;
                                                                 The SAS System


WARNING: Multiple lengths were specified for the BY variable CC by input data sets. This may cause unexpected results.
NOTE: There were 136417 observations read from the data set WORK.MRGCC.
NOTE: There were 1081 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 136417 observations and 11 variables.
NOTE: Compressing data set WORK.MRGCC2 decreased size by 81.28 percent. 
      Compressed is 1344 pages; un-compressed would require 7181 pages.
NOTE: DATA statement used (Total process time):
      real time           0.23 seconds
      cpu time            0.23 seconds
      

693       +proc sort;  BY CC_Hier;
694       +

NOTE: There were 136417 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 136417 observations and 11 variables.
NOTE: Compressing data set WORK.MRGCC2 decreased size by 81.28 percent. 
      Compressed is 1344 pages; un-compressed would require 7181 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.31 seconds
      cpu time            0.48 seconds
      

695       +proc sql;
696       +create table org as
697       +select org_id as CC_Hier,
698       +org_name as Cost_Center_Hierarchy
699       +from wdm.organization
700       +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
      
                                                                 The SAS System


701       +proc sort;  BY CC_Hier;
702       +

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

703       +data mrgcc2; merge mrgcc2(in=a) org(in=b); by CC_Hier; if a;
704       +Cost_Center_Hierarchy = scan(Cost_Center_Hierarchy,-1,'|');

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

705       +proc sort;  BY PROPNBR ACTDTE TASK;
706       +
707       +
708       +/*PROC SORT DATA = SPS10;
709       + BY PROPNBR ACTDTE TASK;*/
710       +

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

      real time           0.40 seconds
      cpu time            0.45 seconds
      

711       +PROC SORT DATA = GLSCOA16;
712       + BY PROPNBR ACTDTE TASK;
713       +

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

714       +PROC SQL;
715       + CREATE TABLE GLSSPS1 AS
716       + SELECT A.*,
717       +        B.PI,
718       +        B.Ä¢¹½tvID,
719       +        B.INVTYPE,
720       +        B.SHARE,
721       +        B.Cost_Center_Hierarchy,
722       +        B.CC,
723       +        B.Cost_Center
724       +FROM GLSCOA16 A,
725       +     mrgcc2  B
726       +WHERE A.PROPNBR = B.PROPNBR AND
727       +      A.ACTDTE  = B.ACTDTE AND
728       +      A.TASK    = B.TASK;
NOTE: Compressing data set WORK.GLSSPS1 decreased size by 76.02 percent. 
      Compressed is 41 pages; un-compressed would require 171 pages.
NOTE: Table WORK.GLSSPS1 created, with 849 rows and 42 columns.

729       +
730       +
                                                                 The SAS System

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

731       +DATA GLSSPS10(KEEP=PROPNBR ACTDTE); SET GLSSPS1; BY PROPNBR ACTDTE;
732       + IF FIRST.ACTDTE THEN OUTPUT;

NOTE: Compression was disabled for data set WORK.GLSSPS10 because compression overhead would increase the size of the data set.
NOTE: There were 849 observations read from the data set WORK.GLSSPS1.
NOTE: The data set WORK.GLSSPS10 has 410 observations and 2 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

733       + proc sort; by propnbr actdte;
734       +

NOTE: There were 410 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSSPS10 has 410 observations and 2 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

735       + proc sort data=glscoa16; by propnbr actdte;

NOTE: Input data set is already sorted, no sorting done.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

736       +DATA GLSCOA10;
737       + MERGE GLSCOA16(IN=A) GLSSPS10(IN=B);
738       + BY PROPNBR ACTDTE;
739       + IF A AND NOT B;
                                                                 The SAS System

740       +

NOTE: There were 528 observations read from the data set WORK.GLSCOA16.
NOTE: There were 410 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSCOA10 has 0 observations and 35 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

741       +DATA GLSSPS;
742       + SET GLSSPS1 GLSCOA10;
743       +
744       +IF SHARE = '.' THEN DO; CÄ¢¹½tvIDTOT = CACCTAMT; NÄ¢¹½tvIDTOT = NACCTAMT;
745       +                        CÄ¢¹½tvIDMON = CTOTMON ; NÄ¢¹½tvIDMON = NTOTMON ;
746       +END;
747       + ELSE DO; CÄ¢¹½tvIDTOT = CACCTAMT * SHARE / 100;
748       +          NÄ¢¹½tvIDTOT = NACCTAMT * SHARE / 100;
749       +          CÄ¢¹½tvIDMON = CTOTMON * SHARE / 100;
750       +          NÄ¢¹½tvIDMON = NTOTMON * SHARE / 100;
751       +END;
752       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      744:12   
NOTE: There were 849 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 849 observations and 46 variables.
NOTE: Compressing data set WORK.GLSSPS decreased size by 76.02 percent. 
      Compressed is 41 pages; un-compressed would require 171 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

753       +PROC SORT DATA = GLSSPS; BY Cost_Center_Hierarchy;
754       +

                                                                 The SAS System

NOTE: There were 849 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS has 849 observations and 46 variables.
NOTE: Compressing data set WORK.GLSSPS decreased size by 76.02 percent. 
      Compressed is 41 pages; un-compressed would require 171 pages.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      

755       +DATA GLSSPS10; SET GLSSPS; BY Cost_Center_Hierarchy;
756       + IF FIRST.Cost_Center_Hierarchy THEN DO;
757       +  NCOLYTD = NÄ¢¹½tvIDTOT;
758       +  NCOLMON = NÄ¢¹½tvIDMON;
759       +  CCOLYTD = CÄ¢¹½tvIDTOT;
760       +  CCOLMON = CÄ¢¹½tvIDMON;
761       + END;
762       + ELSE DO;
763       +  NCOLYTD + NÄ¢¹½tvIDTOT;
764       +  NCOLMON + NÄ¢¹½tvIDMON;
765       +  CCOLYTD + CÄ¢¹½tvIDTOT;
766       +  CCOLMON + CÄ¢¹½tvIDMON;
767       + END;
768       + IF LAST.Cost_Center_Hierarchy THEN DO;
769       +   NCOLYTD = ROUND(NCOLYTD,1.);
770       +   NCOLMON = ROUND(NCOLMON,1.);
771       +   CCOLYTD = ROUND(CCOLYTD,1.);
772       +   CCOLMON = ROUND(CCOLMON,1.);
773       +   OUTPUT;
774       + END;

NOTE: There were 849 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS10 has 26 observations and 50 variables.
NOTE: Compressing data set WORK.GLSSPS10 decreased size by 50.00 percent. 
      Compressed is 3 pages; un-compressed would require 6 pages.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
                                                                 The SAS System


775       + proc sort; by Cost_Center_Hierarchy;
776       +

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

777       +DATA BAD; SET GLSSPS10;
778       + IF Cost_Center_Hierarchy = ' ' THEN OUTPUT;

NOTE: There were 26 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.BAD has 0 observations and 50 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

779       +proc sort; by grant_id;
780       +/*PROC PRINT;
781       +TITLE1 'COULD NOT MERGE WITH SPM';
782       +TITLE2 '  ';
783       +VAR GRANT_ID FUND AWARD_NUMBER TASK_NUMBER	GRANT_EXP_DATE	SPONSOR_ID	SPONSOR_NAME propnbr Ä¢¹½tv_PIID;*/
784       +
785       +
786       +
787       +%global _ODSDEST;
788       +%global _ODSSTYLE;
789       +
790       +%MACRO PRINT;
791       +OPTIONS ORIENTATION=LANDSCAPE;
792       +
793       +%IF (%UPCASE("&_ODSDEST") eq "PHTML")+ (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
                                                                 The SAS System

794       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
795       +data _null_ ;
796       +	rc = stpsrv_header('Content-type','text/html');
797       +run ;
798       +ods listing close;
799       +ods html body=_webout style=default;
800       +%END;
801       +
802       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
803       +data _null_ ;
804       +	rc = stpsrv_header('Content-type','application/pdf') ;
805       +	rc = stpsrv_header('Content-disposition',"attachment; filename=&TME..pdf");
806       +run ;
807       +ods listing close;
808       +ods pdf file=_webout style=FSS;
809       +%END;
810       +
811       +PROC TABULATE DATA = GLSSPS10  FORMAT=COMMA16.;
812       +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
813       +TITLE2 " BY Cost Center Hierarchy ";
814       +TITLE3 " PROCESSED IN &MON &EFFYR  ";
815       + CLASS Cost_Center_Hierarchy;
816       + VAR NCOLMON CCOLMON NCOLYTD CCOLYTD;
817       + TABLE Cost_Center_Hierarchy='  ' ALL='TOTAL',
818       +        (NCOLMON="&HEADER &EFFYR NEW"
819       +        CCOLMON="&HEADER &EFFYR CONT"
820       +        NCOLYTD ="FY &FISCAL YTD NEW"
821       +        CCOLYTD="FY &FISCAL YTD CONT")
822       +        * SUM=' ' /
823       +        BOX='COST CENTER HIERARCHY';
824       +RUN;
825       +/*PROC TABULATE DATA = GLSSPS10  FORMAT=COMMA16.;
826       +TITLE " MONTHLY REPORT OF SPONSORED AGREEMENTS ";
827       +TITLE2 " BY COLLEGE ";
828       +TITLE3 " PROCESSED IN &MON &EFFYR  ";
829       + CLASS COLNAME;
830       + VAR NCOLMON CCOLMON NCOLYTD CCOLYTD;
831       + TABLE COLNAME='  ' ALL='TOTAL',
                                                                 The SAS System

832       +        (NCOLMON="&HEADER &EFFYR NEW"
833       +        CCOLMON="&HEADER &EFFYR CONT"
834       +        NCOLYTD ="FY &FISCAL YTD NEW"
835       +        CCOLYTD="FY &FISCAL YTD CONT")
836       +        * SUM=' ' /
837       +        BOX='COLLEGES';
838       +RUN;*/
839       +
840       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
841       +ods html close;
842       +%END;
843       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
844       +ods pdf close;
845       +%END;
846       +
847       +%END;
848       +%MEND PRINT;
849       +%PRINT;
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF

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

SYMBOLGEN:  Macro variable TME resolves to    33092.732

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

NOTE: Writing ODS PDF output to DISK destination "_WEBOUT", printer "PDF".
SYMBOLGEN:  Macro variable MON resolves to DECEMBER 
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
SYMBOLGEN:  Macro variable HEADER resolves to  DECEMBER
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
SYMBOLGEN:  Macro variable HEADER resolves to  DECEMBER
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
SYMBOLGEN:  Macro variable FISCAL resolves to 2018
SYMBOLGEN:  Macro variable FISCAL resolves to 2018

NOTE: There were 26 observations read from the data set WORK.GLSSPS10.
NOTE: PROCEDURE TABULATE used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
NOTE: ODS PDF printed 2 pages to 1E5F49E8-6F3B-4199-8AAB-09DE5511297F.
850       +
851       +*  Begin EG generated code (do not edit this line);
852       +;*';*";*/;quit;
853       +
854       +*  End EG generated code (do not edit this line);
855       +
NOTE: %INCLUDE (level 1) ending.