SAS Log

1                                                                                                                        The SAS System                                                                                             17:17 Thursday, July 6, 2017

NOTE: Copyright (c) 2002-2010 by SAS Institute Inc., Cary, NC, USA. 
NOTE: SAS (r) Proprietary Software 9.3 (TS1M2) 
      Licensed to LOUISIANA STATE UNIV / ITS-ADMIN, Site 70074566.
NOTE: This session is executing on the X64_S08R2  platform.



NOTE: Enhanced analytical products:

SAS/STAT 12.1

NOTE: SAS Initialization used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      
NOTE: The autoexec file, D:\SAS\EnterpriseSAS\Lev1\SASApp\StoredProcessServer\autoexec.sas, was executed at server initialization.

>>> SAS Macro Variables:

 EFFDTE=20170131
 SYSDBMSG=
 SYSDBRC=0
 _APSLIST=_url,_htua,EFFDTE,_client,_htcook,_result,_ODSDEST,_grafloc,_program,_reqmeth,_rmtaddr,_rmthost,_srvname,_srvport,_version,_metauser,_password,_username,_metafolder,_metaperson,_userloc
     ale,_SECUREUSERNAME
 _CLIENT=StoredProcessService 9.3; JVM 1.6.0_30; Windows Server 2008 R2 (amd64) 6.1
 _GRAFLOC=/sasweb/graph
 _HTCOOK=_ga=GA1.2.833841193.1398869373; __unam=7ac2274-151253bf750-b2127a8-1186; JSESSIONID=F409B508A4682C93D6AA30D9FE42DC38; sso-logout-time="Fri Jul 07 2017 00:43:24 GMT-0500 (Central Daylight
      Time)"; LtpaToken=AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc+/8JzfxUYXTO9YDQKGSzODv
 _HTUA=Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.86 Safari/537.36
 _METAFOLDER=/FSS/
 _METAPERSON=FSSGuest
 _METAUSER=FSSGuest@saspw
 _ODSDEST=PDF
 _PASSWORD=XXXXXX
 _PROGRAM=/FSS/FUNDCOL2
 _REPLAY="&_URL?_sessionid=CDC4C51C-EA1F-48F5-ABDD-E454F40D5F18&_program=replay&_entry=&_TMPCAT.."
 _REQMETH=POST
 _RESULT=STREAM
 _RMTADDR=130.39.75.8
 _RMTHOST=130.39.75.8
 _SECUREUSERNAME=FSSGuest
 _SRVNAME=sasdreporting.lsu.edu
 _SRVPORT=8443
 _TMPCAT=APSWORK.TCAT0015
 _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 _ga=GA1.2.833841193.1398869373; __unam=7ac2274-151253bf750-b2127a8-1186; 
            JSESSIONID=F409B508A4682C93D6AA30D9FE42DC38; sso-logout-time="Fri Jul 07 2017 00:43:24 GMT-0500 (Central Daylight Time)"; 
            LtpaToken=AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc+/8JzfxUYXTO9YDQKGSzODv
SYMBOLGEN:  Some characters in the above value which were subject to macro quoting have been unquoted for printing.

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

SYMBOLGEN:  Macro variable VALUE resolves to AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc%2B/8JzfxUYXTO9YDQKGSzODv
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=AAECAzU5NUVBRUMwNTk1RjFGN0NrdHdlZWRAbHN1LmVkdfMcc%2B/8JzfxUYXTO9YDQKGSzODv,
      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.00 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 20170131
52        +  EFFDTEX = INPUT(PUT(EFFDTE,8.),$8.);
53        +  FORMAT EFFYR $4.;
54        +  EFFYR = SUBSTR(EFFDTEX,1,4);
55        +  EFFMN = SUBSTR(EFFDTEX,5,2);
56        +  IF EFFMN < 7 THEN FISCAL = EFFYR;
57        +   ELSE FISCAL = EFFYR + 1;
58        +     FYEARX = COMPRESS("'"||TRIM(FISCAL)||"'");
59        +     FYRX = "'"||SUBSTR(FYEARX,4,2)||"'";
60        +     PDATE = COMPRESS(EFFYR) || COMPRESS(EFFMN);
61        +/*PFILE = "'ACGR14.PROD.PDF(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 = 01 THEN MON = 'JANUARY  ';
74        +IF EFFMN = 02 THEN MON = 'FEBRUARY ';
75        +IF EFFMN = 03 THEN MON = 'MARCH    ';
76        +IF EFFMN = 04 THEN MON = 'APRIL    ';
77        +IF EFFMN = 05 THEN MON = 'MAY      ';
78        +IF EFFMN = 06 THEN MON = 'JUNE     ';
79        +IF EFFMN = 07 THEN MON = 'JULY     ';
80        +IF EFFMN = 08 THEN MON = 'AUGUST   ';
81        +IF EFFMN = 09 THEN MON = 'SEPTEMBER';
82        +IF EFFMN = 10 THEN MON = 'OCTOBER  ';
83        +IF EFFMN = 11 THEN MON = 'NOVEMBER ';
84        +IF EFFMN = 12 THEN MON = 'DECEMBER ';
85        + CALL SYMPUT('MON',MON);
86        +
87        +BEGFY=FISCAL-1;
88        +BEGFX = INPUT(PUT(BEGFY,4.),$4.);
89        +FISX = INPUT(PUT(FISCAL,4.),$4.);
90        +FORMAT BEGYR ENDYR $2.;
91        +BEGYR = SUBSTR(BEGFX,3,2);
92        +ENDYR = SUBSTR(FISX,3,2);
93        +CALL SYMPUT('BEGYR',BEGYR);
94        +CALL SYMPUT('ENDYR',ENDYR);
95        +
96        +     IF EFFMN = 01 THEN HEADER = '  JANUARY';
97        +ELSE IF EFFMN = 02 THEN HEADER = ' FEBRUARY';
98        +ELSE IF EFFMN = 03 THEN HEADER = '    MARCH';
99        +ELSE IF EFFMN = 04 THEN HEADER = '    APRIL';
100       +ELSE IF EFFMN = 05 THEN HEADER = '      MAY';
101       +ELSE IF EFFMN = 06 THEN HEADER = '     JUNE';
102       +ELSE IF EFFMN = 07 THEN HEADER = '     JULY';
103       +ELSE IF EFFMN = 08 THEN HEADER = '   AUGUST';
104       +ELSE IF EFFMN = 09 THEN HEADER = 'SEPTEMBER';
105       +ELSE IF EFFMN = 10 THEN HEADER = '  OCTOBER';
106       +ELSE IF EFFMN = 11 THEN HEADER = ' NOVEMBER';
                                                                 The SAS System

107       +ELSE IF EFFMN = 12 THEN HEADER = ' DECEMBER';
108       +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    74:4    75:4    76:4    77:4    78:4    79:4    80:4    81:4    82:4    83:4    84:4    87:7    96:9    97:9
      98:9    99:9    100:9   101:9   102:9   103:9   104:9   105:9   106:9   107:9   
NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      57:24   71:20   
NOTE: The data set WORK.DATE has 1 observations and 16 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

109       +proc sort; by effmn;
110       +
111       +/*LIBNAME COA DB2 AUTHID=COA SSID=DB2;
112       +LIBNAME SPM DB2 AUTHID=SPM SSID=DB2;
113       +LIBNAME DIR DB2 AUTHID=DIR SSID=DB2;*/
114       +
115       +/ LEGACY COA INFORMATION ****
116       +PROC SQL;
117       + CREATE TABLE COAFILE AS
118       + SELECT P_I_Ä¢¹½tv_ID          AS PIID
119       +       ,ACCT_CODE           AS ACCT
120       +       ,AGENCY_CD           AS AGENCY
121       +       ,GRANT_EXPIRE_DATE   AS EXPIRE
122       +       ,PROPOSAL_NBR        AS PROPNBR
123       +       ,GRANT_NAME          AS STITLE
124       +       ,TOTAL_AWARD_AMT     AS TOTAWARD
125       +       ,CO_P_I_Ä¢¹½tv_ID       AS COPIID
126       +       ,INTERNAL_COMP_FLAG  AS INTFLAG
127       +       ,TASK_NBR            AS TASK
128       +FROM COA.SPONSORED_PROGRAMS
129       +WHERE SUBSTR(ACCT_CODE,1,1) = '1'
130       +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6') AND PROPOSAL_NBR <> 0
131       +AND AGENCY_CD NOT IN ('A1','C','Z','XF') AND BILL_CYCLE_CD <> 'G'
132       +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
                                                                 The SAS System

133       +'190067') AND FISCAL_YEAR = &FYEAR;
134       +PROC SORT; BY ACCT;*/
135       +

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

136       +PROC SQL;
137       +CREATE TABLE FUND1 AS
138       +SELECT ORG_ID AS GRANT_ID,
139       +FUND
140       +FROM WDM.fin_fdm_DRIVERTAG
141       +WHERE FUND IN ('FD250','FD251','FD252');
NOTE: Table WORK.FUND1 created, with 5580 rows and 2 columns.

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

142       +PROC SORT; BY GRANT_ID;
143       +

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

144       +PROC SQL;
145       +CREATE TABLE GRANT1 AS
146       +SELECT GRANT_ID,
147       +AWARD_NUMBER as award_budg,
                                                                 The SAS System

148       +TO_DATE AS GRANT_EXP_DATE,
149       +sponsor_id,
150       +cont_line_status,
151       +workday_id,
152       +CONT_STATUS,
153       +is_primary
154       +FROM WDM.FIN_AWD_LINE
155       +where company = '10' and cont_status NE ' ';
NOTE: Table WORK.GRANT1 created, with 3013 rows and 8 columns.

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

156       +PROC SORT; BY GRANT_ID;
157       +

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

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

NOTE: There were 5580 observations read from the data set WORK.FUND1.
NOTE: There were 3013 observations read from the data set WORK.GRANT1.
NOTE: The data set WORK.MRG1 has 2710 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

159       +PROC SORT; BY sponsor_id;
160       +

                                                                 The SAS System

NOTE: There were 2710 observations read from the data set WORK.MRG1.
NOTE: The data set WORK.MRG1 has 2710 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

161       +proc sql;
162       +create table SPON as
163       +select sponsor_id,
164       +SPONSOR_NAME,
165       +sponsor_type
166       +from wdm.fin_awd_sponsor;
NOTE: Table WORK.SPON created, with 1536 rows and 3 columns.

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

167       +proc sort; by sponsor_id;
168       +

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

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

NOTE: There were 2710 observations read from the data set WORK.MRG1.
NOTE: There were 1536 observations read from the data set WORK.SPON.
NOTE: The data set WORK.MRGSPON has 2710 observations and 11 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
                                                                 The SAS System

      

170       +PROC SORT; BY award_budg grant_id cont_line_status descending is_primary ;
171       +

NOTE: There were 2710 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.MRGSPON has 2710 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

NOTE: There were 2710 observations read from the data set WORK.MRGSPON.
NOTE: The data set WORK.SETSPON has 2706 observations and 11 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

174       +proc sort; by workday_id;
175       +

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

176       +proc sql;
177       +create table task as
178       +select workday_id,
179       +org_id as tasknbr
180       +from WDM.FIN_AWD_LINE_ORG
181       +where substr(org_id,1,2) = 'TA';
                                                                 The SAS System

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

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

182       +proc sort; by workday_id;
183       +

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

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

NOTE: There were 5436 observations read from the data set WORK.TASK.
NOTE: There were 2706 observations read from the data set WORK.SETSPON.
NOTE: The data set WORK.MRGGRNT has 2706 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

186       +proc sort; by award_budg;
187       +

NOTE: There were 2706 observations read from the data set WORK.MRGGRNT.
NOTE: The data set WORK.MRGGRNT has 2706 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

                                                                 The SAS System

188       +PROC SQL;
189       +CREATE TABLE AWARD1 AS
190       +SELECT AWARD_NUMBER as award_budg,
191       +PROPOSAL_ID as propnbr,
192       +AWARD_NAME,
193       +signed_date,
194       +TOTAL_AMOUNT AS AWD_TOTAL,
195       +award_date
196       +FROM WDM.FIN_AWD
197       +WHERE PROPOSAL_ID NE 0 and
198       +award_type not in ('SPN_AWD_Type_Disaster_Relief','SPN_AWD_Type_Pell_SEOG_CWS','SPN_AWD_Type_Federal_Appropriations');
NOTE: Table WORK.AWARD1 created, with 1707 rows and 6 columns.

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

199       +PROC SORT; BY award_budg;
200       +

NOTE: There were 1707 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.AWARD1 has 1707 observations and 6 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

201       +DATA MRG2; MERGE mrggrnt(IN=A) AWARD1(IN=B); BY award_budg; IF A AND B;
202       +format TASK 2.;
203       +task = substr(taskNBR,3,2);
204       +if task = 0 then task = 1;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      203:8   
NOTE: There were 2706 observations read from the data set WORK.MRGGRNT.
NOTE: There were 1707 observations read from the data set WORK.AWARD1.
NOTE: The data set WORK.MRG2 has 2415 observations and 18 variables.
                                                                 The SAS System

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

205       +PROC SORT; BY award_budg;
206       +
207       +/*PROC SQL;
208       +CREATE TABLE LEADPI AS
209       +SELECT EMPLOYEE_ID AS WD_PIID,
210       +ORG_ID AS GRANT_ID,
211       +ROLE_NAME AS ROLE1
212       +FROM WDM.WORKER_ROLE
213       +WHERE role_name = 'Principal_Investigator';
214       +PROC SORT; BY WD_PIID;
215       +
216       +PROC SQL;
217       +CREATE TABLE Ä¢¹½tvPIID AS
218       +SELECT EMPLOYEE_ID AS WD_PIID,
219       +Ä¢¹½tv_ID AS Ä¢¹½tv_PIID
220       +FROM WDM.KEYS;
221       +PROC SORT; BY WD_PIID;
222       +
223       +DATA MRGPI;
224       +MERGE LEADPI(IN=A) Ä¢¹½tvPIID(IN=B); BY WD_PIID; IF A;
225       +PROC SORT; BY GRANT_ID;
226       +
227       +DATA MRG3; MERGE MRG2(IN=A) MRGPI(IN=B); BY GRANT_ID; IF A;
228       +PROC SORT; BY award_budg;*/
229       +
230       +/*PROC SQL;
231       +CREATE TABLE COPI AS
232       +SELECT EMPLOYEE_ID AS WD_COPIID,
233       +ORG_ID AS GRANT_ID,
234       +ROLE_NAME AS ROLE2
235       +FROM WDM.WORKER_ROLE
236       +WHERE role_name = 'Co-Principal_Investigator';
237       +PROC SORT; BY WD_COPIID;
                                                                 The SAS System

238       +
239       +PROC SQL;
240       +CREATE TABLE Ä¢¹½tvCOPIID AS
241       +SELECT EMPLOYEE_ID AS WD_COPIID,
242       +Ä¢¹½tv_ID AS Ä¢¹½tv_COPIID
243       +FROM WDM.KEYS;
244       +PROC SORT; BY WD_COPIID;
245       +
246       +DATA MRGCOPI;
247       +MERGE COPI(IN=A) Ä¢¹½tvCOPIID(IN=B); BY WD_COPIID; IF A;
248       +PROC SORT; BY GRANT_ID;
249       +
250       +DATA MRG4; MERGE MRG3(IN=A) MRGCOPI(IN=B); BY GRANT_ID; IF A;
251       +PROC SORT; BY award_budg;*/
252       +

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

253       +proc sql;
254       +CREATE TABLE SPEC AS
255       +SELECT AWARD_NUMBER as award_budg,
256       +REF_ID
257       +FROM WDM.FIN_AWD_SPEC_COND
258       +WHERE REF_ID = 'Special_Condition_Type_Internal_Competition';
NOTE: Table WORK.SPEC created, with 36 rows and 2 columns.

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

259       +PROC SORT; BY award_budg;
260       +
                                                                 The SAS System


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

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

NOTE: There were 2415 observations read from the data set WORK.MRG2.
NOTE: There were 36 observations read from the data set WORK.SPEC.
NOTE: The data set WORK.MRG5 has 2415 observations and 19 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

262       +PROC SORT; BY award_budg grant_id;
263       +

NOTE: There were 2415 observations read from the data set WORK.MRG5.
NOTE: The data set WORK.MRG5 has 2415 observations and 19 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

NOTE: There were 2415 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.01 seconds
      cpu time            0.01 seconds
      

                                                                 The SAS System

266       +proc sort; by award_budg grant_id;
267       +
268       +
269       +
270       +/*PROC SQL;
271       + CREATE TABLE SPAFILE AS
272       + SELECT ACCT_CODE       AS ACCT
273       +       ,BEGIN_DATE      AS BEGIN
274       +       ,INIT_TIMESTAMP  AS IADD
275       +       ,LONG_TITLE      AS LONG
276       +FROM COA.ACCOUNTS
277       +WHERE CAMPUS_CD = '1' AND ACCT_TYPE = 'S'
278       +AND SUBSTR(ACCT_CODE,6,1) IN ('3','4','5','6')
279       +AND SUBSTR(ACCT_CODE,1,7) NOT IN ('1801054','1814054','190047','190057',
280       +'190067') AND FISCAL_YEAR = &FYEAR;
281       +
282       +PROC SORT; BY ACCT;
283       +
284       +DATA COAS;
285       +  MERGE COAFILE(IN=A) SPAFILE(IN=B);
286       +  BY ACCT;
287       +  IF A AND B;
288       +
289       +PROC SORT DATA = COAS;  BY ACCT;
290       +
291       +DATA COA1(KEEP=STITLE LONG ACCT AGENCY EXPIRE BEGIN ADDTE TOTAWARD
292       +          PIID COPIID PROPNBR INTFLAG TASK);
293       + SET COAS;
294       +  FORMAT STITLE $60.;
295       +  FORMAT ADATE YYMMDDN8.;
296       +  ADATE = DATEPART(IADD);
297       +  FORMAT BEGIN YYMMDDN8.;
298       +  FORMAT EXPIRE YYMMDDN8.;
299       +  AYR = YEAR(ADATE);
300       +  AMTH= MONTH(ADATE);
301       +    MONA = INPUT(PUT(AMTH,Z2.),$2.);
302       +    YEARA = INPUT(PUT(AYR,4.),$4.);
303       +  ADDTE = YEARA||MONA;
                                                                 The SAS System

304       +  *IF BEGIN <= &DATE;*/
305       +

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
      

306       +PROC SQL;
307       +CREATE TABLE BUDG AS
308       +SELECT grant_id,
309       +grant_name,
310       +ledger_account,
311       +budget_revenue as AMT,
312       +budget_obj,
313       +award_name,
314       +award_report_code as BAADJCD,
315       +budget_amendment_date,
316       +budget_date_from
317       +from workday.award_budget
318       +where ledger_account in ('4200:Federal Grants and Contracts Revenue','4210:State and Local Grants and Contracts Revenue',
319       +'4220:Non-governmental Grants and Contracts Revenue','4230:Grants and Contracts Revenue') and budget_amendment_status not in
319      !+('Canceled','Draft','Denied')
320       +and company_code = 'Ä¢¹½tvAM' and
321       +award_report_code in ('New','Continuation') ;
NOTE: Table WORK.BUDG created, with 868 rows and 9 columns.

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

322       +proc sort; by grant_id;
323       +

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

NOTE: The data set WORK.BUDG has 868 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

324       +data set1; set budg; by grant_id;
325       +format BUDGET_DATE1 yymmddn.;
326       +budget_date1 = budget_amendment_date;
327       +award_budg = scan(budget_obj,1,":");

NOTE: There were 868 observations read from the data set WORK.BUDG.
NOTE: The data set WORK.SET1 has 868 observations and 11 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

328       +proc sort; by award_budg grant_id;
329       +

NOTE: There were 868 observations read from the data set WORK.SET1.
NOTE: The data set WORK.SET1 has 868 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

330       +data MARGE; merge mrg5(in=a) set1(in=b); by award_budg grant_id; if a and b;
331       +format budget_date yymmddn.;
332       +if budget_date1 = ' ' then budget_date = signed_date; else budget_date = budget_date1;
333       +if budget_date = ' ' then delete;

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      332:19   333:18   
WARNING: Multiple lengths were specified for the BY variable award_budg by input data sets. This may cause unexpected results.
NOTE: There were 2415 observations read from the data set WORK.MRG5.
NOTE: There were 868 observations read from the data set WORK.SET1.
                                                                 The SAS System

NOTE: The data set WORK.MARGE has 867 observations and 28 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

334       +proc sort; by grant_id budget_date;
335       +

NOTE: There were 867 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE has 867 observations and 28 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

336       +data marge1; set marge; by grant_id budget_date;
337       +effdte = INPUT(PUT(budget_date,yymmddn.),8.);
338       +*if effdte <= 20160930 then output;

NOTE: There were 867 observations read from the data set WORK.MARGE.
NOTE: The data set WORK.MARGE1 has 867 observations and 29 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

339       +proc sort; by grant_id;
340       +
341       +/*
342       +DATA GLSD;
343       +  INFILE GLSD;
344       +  INPUT  @1   FY       $2.
345       +         @3   ENTRY   PD5.
346       +         @10  ACCT       $9.
347       +         @19  TT         $1.
348       +         @20  OBJ      $4.
349       +         @24  SUBOBJ   $1.
                                                                 The SAS System

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

388       +

NOTE: There were 867 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.MARGE1 has 867 observations and 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

389       +DATA BUDG1 (DROP= EMTH ENDYRX BEGYRX END BEG);
390       + SET marge1; by grant_id effdte;
391       +  *BY FY ACCT ENTRY;
392       + *edate = effdte;
393       +  EDATE = INPUT(PUT(effdte,8.),YYMMDD8.);
394       +  EMTH= MONTH(EDATE);
395       +
396       +  IF effdte <= &EFFDTE;
SYMBOLGEN:  Macro variable EFFDTE resolves to 20170131
397       +
398       +  EMNX = INPUT(PUT(EMTH,Z2.),$2.);
399       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 17
400       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
401       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
402       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
403       +  IF EMTH > 6 THEN ACTDTE = BEG||EMNX;
404       +   ELSE ACTDTE = END||EMNX;
405       +
406       +  IF EMNX = &EFFMN THEN MONAMT = AMT;
SYMBOLGEN:  Macro variable EFFMN resolves to 01      
407       +  ELSE MONAMT = 0;
408       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      406:6   
NOTE: There were 867 observations read from the data set WORK.MARGE1.
NOTE: The data set WORK.BUDG1 has 340 observations and 33 variables.
                                                                 The SAS System

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

409       +PROC SORT DATA = budg1; BY ACTDTE grant_id;
410       +

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

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


NOTE: There were 340 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 323 observations and 35 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

434       + proc sort; by grant_id;
435       +

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

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

NOTE: There were 323 observations read from the data set WORK.GLSCOA15.
NOTE: The data set WORK.GLSCOA16 has 321 observations and 35 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

438       + proc sort; by grant_id;
439       +
440       +

NOTE: There were 321 observations read from the data set WORK.GLSCOA16.
NOTE: The data set WORK.GLSCOA16 has 321 observations and 35 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      
                                                                 The SAS System


441       +PROC SQL;
442       +  CREATE TABLE PROJTRAN AS
443       +SELECT PROPOSAL_NBR     AS PROPNBR
444       +      ,TRX_NBR          AS TRXNBR
445       +      ,TRX_TYPE         AS TRXTYPE
446       +      ,TRX_STATUS       AS TRXSTAT
447       +      ,TO_SPA_DATE      AS RELDATE
448       +FROM SPM.PROJ_TRANSACTION
449       + WHERE TRX_STATUS IN ('AC','TE','CO');
NOTE: Table WORK.PROJTRAN created, with 17727 rows and 5 columns.

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

451       +PROC SORT; BY PROPNBR TRXNBR RELDATE;
452       +

NOTE: There were 17727 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.PROJTRAN has 17727 observations and 5 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

453       +DATA SPS2;
454       + SET PROJTRAN; BY PROPNBR TRXNBR;
455       +    LENGTH MO YY $2.;
456       +    LENGTH YR $4.;
457       +    MO=MONTH(RELDATE);
458       +    YR=YEAR(RELDATE);
459       +    YY=SUBSTR(YR,3,2);
460       +    LENGTH EFFMY $4.;
461       +    EFFMY=YY||MO;
462       +    IF SUBSTR(EFFMY,3,1)=' ' THEN SUBSTR(EFFMY,3,1)='0';
                                                                 The SAS System


NOTE: Numeric values have been converted to character values at the places given by: (Line):(Column).
      457:8   458: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 457:8   212 at 458:8   
NOTE: There were 17727 observations read from the data set WORK.PROJTRAN.
NOTE: The data set WORK.SPS2 has 17727 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

463       +    PROC SORT; BY PROPNBR EFFMY RELDATE;
464       +

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

465       + PROC SORT; BY PROPNBR TRXNBR;
466       +

NOTE: There were 17727 observations read from the data set WORK.SPS2.
NOTE: The data set WORK.SPS2 has 17727 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

467       +PROC SQL;
468       +    CREATE TABLE PISHR AS
469       +    SELECT PROPOSAL_NBR    AS PROPNBR,
470       +           TRX_NBR         AS TRXNBR,
471       +           TASK_NBR        AS TASK,
                                                                 The SAS System

472       +           Ä¢¹½tv_ID          AS Ä¢¹½tvID,
473       +           INVESTIGATOR_TYPE AS INVTYPE,
474       +           DEPT_CD         AS DEPT,
475       +           PROJECT_SHARE   AS SHARE
476       +    FROM SPM.PROJ_INVESTIGATOR
477       +    WHERE PROJECT_SHARE > 0;
NOTE: Table WORK.PISHR created, with 72959 rows and 7 columns.

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

478       +    PROC SORT; BY PROPNBR TRXNBR TASK;
479       +

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

480       +DATA SPS4;
481       +  MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
482       +

NOTE: There were 17727 observations read from the data set WORK.SPS2.
NOTE: There were 72959 observations read from the data set WORK.PISHR.
NOTE: The data set WORK.SPS4 has 31069 observations and 14 variables.
NOTE: DATA statement used (Total process time):
      real time           0.03 seconds
      cpu time            0.03 seconds
      

483       +PROC SORT;  BY PROPNBR EFFMY RELDATE;
484       +

                                                                 The SAS System

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

485       +    PROC SORT; BY PROPNBR TRXNBR;
486       +

NOTE: There were 31069 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPS4 has 31069 observations and 14 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

487       +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
488       +     SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
489       +     SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
490       +     SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
491       +     SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
492       +     SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
493       +     SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
494       +     SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
495       +     SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
496       +     SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
497       +     SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
498       +     SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
499       +     SET SPS4;
500       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 17
501       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
502       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
503       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
504       +     IF (YY=&BEGYR AND MO <= 07) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
                                                                 The SAS System

SYMBOLGEN:  Macro variable BEGYR resolves to 16
505       +         ACTDTE = BEG||'07';
506       +         OUTPUT SPSFM1;
507       +         END;
508       +     IF (YY=&BEGYR AND MO <= 08) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable BEGYR resolves to 16
509       +         ACTDTE = BEG||'08';
510       +         OUTPUT SPSFM2;
511       +         END;
512       +     IF (YY=&BEGYR AND MO <= 09) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable BEGYR resolves to 16
513       +         ACTDTE = BEG||'09';
514       +         OUTPUT SPSFM3;
515       +         END;
516       +     IF (YY=&BEGYR AND MO <= 10) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable BEGYR resolves to 16
517       +         ACTDTE = BEG||'10';
518       +         OUTPUT SPSFM4;
519       +         END;
520       +     IF (YY=&BEGYR AND MO <= 11) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable BEGYR resolves to 16
521       +         ACTDTE = BEG||'11';
522       +         OUTPUT SPSFM5;
523       +         END;
524       +     IF (YY=&BEGYR AND MO <= 12) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable BEGYR resolves to 16
525       +         ACTDTE = BEG||'12';
526       +         OUTPUT SPSFM6;
527       +         END;
528       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 1) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable ENDYR resolves to 17
529       +         ACTDTE = END||'01';
                                                                 The SAS System

530       +         OUTPUT SPSFM7;
531       +         END;
532       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 2) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable ENDYR resolves to 17
533       +         ACTDTE = END||'02';
534       +         OUTPUT SPSFM8;
535       +         END;
536       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <= 3) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable ENDYR resolves to 17
537       +         ACTDTE = END||'03';
538       +         OUTPUT SPSFM9;
539       +         END;
540       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=4) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable ENDYR resolves to 17
541       +         ACTDTE = END||'04';
542       +         OUTPUT SPSFM10;
543       +         END;
544       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=5) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable ENDYR resolves to 17
545       +         ACTDTE = END||'05';
546       +         OUTPUT SPSFM11;
547       +         END;
548       +     IF YY <= &BEGYR OR (YY=&ENDYR AND MO <=6) THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable ENDYR resolves to 17
549       +         ACTDTE = END||'06';
550       +         OUTPUT SPSFM12;
551       +         END;
552       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      504:10   504:24   504:37   508:10   508:24   508:37   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:9    528:26   528:40   532:9    532:26   532:40   536:9    536:26   536:40   540:9    540:26   540:40
      544:9    544:26   544:40   548:9    548:26   548:40   
                                                                 The SAS System

NOTE: There were 31069 observations read from the data set WORK.SPS4.
NOTE: The data set WORK.SPSFM1 has 29137 observations and 12 variables.
NOTE: The data set WORK.SPSFM2 has 29293 observations and 12 variables.
NOTE: The data set WORK.SPSFM3 has 29549 observations and 12 variables.
NOTE: The data set WORK.SPSFM4 has 29700 observations and 12 variables.
NOTE: The data set WORK.SPSFM5 has 29806 observations and 12 variables.
NOTE: The data set WORK.SPSFM6 has 29889 observations and 12 variables.
NOTE: The data set WORK.SPSFM7 has 29995 observations and 12 variables.
NOTE: The data set WORK.SPSFM8 has 30231 observations and 12 variables.
NOTE: The data set WORK.SPSFM9 has 30385 observations and 12 variables.
NOTE: The data set WORK.SPSFM10 has 30493 observations and 12 variables.
NOTE: The data set WORK.SPSFM11 has 30655 observations and 12 variables.
NOTE: The data set WORK.SPSFM12 has 31038 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.10 seconds
      cpu time            0.10 seconds
      

553       +DATA SPS6;
554       +    SET SPSFM1
555       +        SPSFM2
556       +        SPSFM3
557       +        SPSFM4
558       +        SPSFM5
559       +        SPSFM6
560       +        SPSFM7
561       +        SPSFM8
562       +        SPSFM9
563       +        SPSFM10
564       +        SPSFM11
565       +        SPSFM12;

NOTE: There were 29137 observations read from the data set WORK.SPSFM1.
NOTE: There were 29293 observations read from the data set WORK.SPSFM2.
NOTE: There were 29549 observations read from the data set WORK.SPSFM3.
NOTE: There were 29700 observations read from the data set WORK.SPSFM4.
NOTE: There were 29806 observations read from the data set WORK.SPSFM5.
NOTE: There were 29889 observations read from the data set WORK.SPSFM6.
                                                                 The SAS System

NOTE: There were 29995 observations read from the data set WORK.SPSFM7.
NOTE: There were 30231 observations read from the data set WORK.SPSFM8.
NOTE: There were 30385 observations read from the data set WORK.SPSFM9.
NOTE: There were 30493 observations read from the data set WORK.SPSFM10.
NOTE: There were 30655 observations read from the data set WORK.SPSFM11.
NOTE: There were 31038 observations read from the data set WORK.SPSFM12.
NOTE: The data set WORK.SPS6 has 360171 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.09 seconds
      cpu time            0.09 seconds
      

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

NOTE: There were 360171 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS6 has 360171 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.09 seconds
      cpu time            0.25 seconds
      

569       +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
570       +  SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
571       +    IF LAST.ACTDTE THEN OUTPUT SPS7X;
572       +

NOTE: There were 360171 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7X has 88505 observations and 3 variables.
NOTE: DATA statement used (Total process time):
      real time           0.07 seconds
      cpu time            0.07 seconds
      

573       +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
574       +

                                                                 The SAS System

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

575       +DATA SPS7;
576       + MERGE SPS7X(IN=A) SPS6(IN=B);
577       + BY PROPNBR ACTDTE TRXNBR;
578       + IF A AND B;
579       +

NOTE: There were 88505 observations read from the data set WORK.SPS7X.
NOTE: There were 360171 observations read from the data set WORK.SPS6.
NOTE: The data set WORK.SPS7 has 129366 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.12 seconds
      cpu time            0.12 seconds
      

580       +PROC SORT DATA = SPS7;  BY Ä¢¹½tvID;
581       +

NOTE: There were 129366 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS7 has 129366 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.06 seconds
      cpu time            0.06 seconds
      

582       +PROC SQL;
583       +  CREATE TABLE DIRFILE AS
584       + SELECT INDIV_NAME     AS PI
585       +       ,Ä¢¹½tv_ID         AS Ä¢¹½tvID
586       + FROM DIR.NAME;
NOTE: Table WORK.DIRFILE created, with 1159731 rows and 2 columns.

                                                                 The SAS System

587       +
NOTE: PROCEDURE SQL used (Total process time):
      real time           1.91 seconds
      cpu time            0.96 seconds
      

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

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

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

612       +  COLNAME = CODENAME;
613       +  OUTPUT COLNAME;
614       + END;
615       + ELSE DO;
616       +  DPT = CODE;
617       +  DPTNAME = CODENAME;
618       +  OUTPUT NAMES;
619       + END;
620       +
621       +PROC SORT DATA = NAMES;
622       +  BY DPT;
623       +
624       +PROC SORT DATA = SPS8;
625       +  BY DPT;
626       +
627       +DATA SPS9;
628       + MERGE NAMES(IN=A) SPS8(IN=B);
629       + BY DPT;
630       + IF B;
631       +  FORMAT DPTNAME $35.;
632       +  FORMAT COL $3.;
633       +  COL = SUBSTR(DPT,1,3);
634       +  COL1 = COL||'  ';
635       +  FORMAT COLLEGE $5.;
636       +  COLLEGE = COMPRESS(COL1);
637       +
638       +PROC SORT DATA = SPS9;
639       +  BY COLLEGE;
640       +
641       +PROC SORT DATA = COLNAME;
642       +  BY COLLEGE;
643       +
644       +DATA SPS10A;
645       + MERGE COLNAME(IN=A) SPS9(IN=B);
646       + BY COLLEGE;
647       + IF B;
648       +
649       +*DATA TEST; *SET SPS10A; *IF SUBSTR(COLLEGE,1,1) IN('3','9');
                                                                 The SAS System

650       +
651       +DATA SPS10; SET SPS10A;
652       +  IF SUBSTR(COLLEGE,1,1) = '3' THEN DO;
653       +    COLLEGE = '300';
654       +    COLNAME = 'PBRC';
655       +  END;
656       +  IF SUBSTR(COLLEGE,1,1) = '9' THEN DO;
657       +    COLLEGE = '900';
658       +    COLNAME = 'AG CENTER';
659       +  END;*/
660       +

NOTE: There were 1159731 observations read from the data set WORK.DIRFILE.
NOTE: There were 129366 observations read from the data set WORK.SPS7.
NOTE: The data set WORK.SPS8 has 129366 observations and 8 variables.
NOTE: DATA statement used (Total process time):
      real time           0.24 seconds
      cpu time            0.24 seconds
      

661       +  proc sql;
662       +  create table ccdept as
663       +  select code_value1 as dept,
664       +  code_value2 as CC
665       +  from spm.codes
666       +where code_type = 'CCDEPT';
NOTE: Table WORK.CCDEPT created, with 2587 rows and 2 columns.

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

667       +proc sort; by  dept;
668       +

NOTE: There were 2587 observations read from the data set WORK.CCDEPT.
NOTE: The data set WORK.CCDEPT has 2587 observations and 2 variables.
                                                                 The SAS System

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

669       +PROC SORT DATA = SPS8;
670       + BY dept;
671       +

NOTE: There were 129366 observations read from the data set WORK.SPS8.
NOTE: The data set WORK.SPS8 has 129366 observations and 8 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

672       +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 129366 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 129366 observations and 9 variables.
NOTE: DATA statement used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

673       +proc sort; by cc;
674       +

NOTE: There were 129366 observations read from the data set WORK.MRGCC.
NOTE: The data set WORK.MRGCC has 129366 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.04 seconds
      cpu time            0.04 seconds
      

675       +proc sql;
                                                                 The SAS System

676       +create table org as
677       +select org_id as CC,
678       +org_name as Cost_Center,
679       +superior_org as CC_Hier
680       +from wdm.organization
681       +where org_type = 'Cost_Center';
NOTE: Table WORK.ORG created, with 1056 rows and 3 columns.

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

682       +proc sort;  BY CC;
683       +

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

684       +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 129366 observations read from the data set WORK.MRGCC.
NOTE: There were 1056 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 129366 observations and 11 variables.
NOTE: DATA statement used (Total process time):
      real time           0.14 seconds
      cpu time            0.14 seconds
      

685       +proc sort;  BY CC_Hier;
686       +

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

NOTE: The data set WORK.MRGCC2 has 129366 observations and 11 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.32 seconds
      cpu time            0.32 seconds
      

687       +proc sql;
688       +create table org as
689       +select org_id as CC_Hier,
690       +org_name as Cost_Center_Hierarchy
691       +from wdm.organization
692       +where org_type = 'Cost_Center_Hierarchy';
NOTE: Table WORK.ORG created, with 148 rows and 2 columns.

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

693       +proc sort;  BY CC_Hier;
694       +

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

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

NOTE: There were 129366 observations read from the data set WORK.MRGCC2.
NOTE: There were 148 observations read from the data set WORK.ORG.
NOTE: The data set WORK.MRGCC2 has 129366 observations and 12 variables.
NOTE: DATA statement used (Total process time):
      real time           0.34 seconds
      cpu time            0.34 seconds
                                                                 The SAS System

      

697       +proc sort;  BY PROPNBR ACTDTE TASK;
698       +
699       +
700       +/*PROC SORT DATA = SPS10;
701       + BY PROPNBR ACTDTE TASK;*/
702       +

NOTE: There were 129366 observations read from the data set WORK.MRGCC2.
NOTE: The data set WORK.MRGCC2 has 129366 observations and 12 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.43 seconds
      cpu time            0.43 seconds
      

703       +PROC SORT DATA = GLSCOA16;
704       + BY PROPNBR ACTDTE TASK;
705       +

NOTE: There were 321 observations read from the data set WORK.GLSCOA16.
NOTE: The data set WORK.GLSCOA16 has 321 observations and 35 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

706       +PROC SQL;
707       + CREATE TABLE GLSSPS1 AS
708       + SELECT A.*,
709       +        B.PI,
710       +        B.Ä¢¹½tvID,
711       +        B.INVTYPE,
712       +        B.SHARE,
713       +        B.Cost_Center_Hierarchy,
714       +        B.CC,
715       +        B.Cost_Center
716       +FROM GLSCOA16 A,
                                                                 The SAS System

717       +     mrgcc2  B
718       +WHERE A.PROPNBR = B.PROPNBR AND
719       +      A.ACTDTE  = B.ACTDTE AND
720       +      A.TASK    = B.TASK;
NOTE: Table WORK.GLSSPS1 created, with 545 rows and 42 columns.

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

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

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

725       + proc sort; by propnbr actdte;
726       +

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

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

      cpu time            0.00 seconds
      

728       +DATA GLSCOA10;
729       + MERGE GLSCOA16(IN=A) GLSSPS10(IN=B);
730       + BY PROPNBR ACTDTE;
731       + IF A AND NOT B;
732       +

NOTE: There were 321 observations read from the data set WORK.GLSCOA16.
NOTE: There were 260 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
      

733       +DATA GLSSPS;
734       + SET GLSSPS1 GLSCOA10;
735       +
736       +IF SHARE = '.' THEN DO; CÄ¢¹½tvIDTOT = CACCTAMT; NÄ¢¹½tvIDTOT = NACCTAMT;
737       +                        CÄ¢¹½tvIDMON = CTOTMON ; NÄ¢¹½tvIDMON = NTOTMON ;
738       +END;
739       + ELSE DO; CÄ¢¹½tvIDTOT = CACCTAMT * SHARE / 100;
740       +          NÄ¢¹½tvIDTOT = NACCTAMT * SHARE / 100;
741       +          CÄ¢¹½tvIDMON = CTOTMON * SHARE / 100;
742       +          NÄ¢¹½tvIDMON = NTOTMON * SHARE / 100;
743       +END;
744       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      736:12   
NOTE: There were 545 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 545 observations and 46 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
                                                                 The SAS System

      

745       +PROC SORT DATA = GLSSPS; BY Cost_Center_Hierarchy;
746       +

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

747       +DATA GLSSPS10; SET GLSSPS; BY Cost_Center_Hierarchy;
748       + IF FIRST.Cost_Center_Hierarchy THEN DO;
749       +  NCOLYTD = NÄ¢¹½tvIDTOT;
750       +  NCOLMON = NÄ¢¹½tvIDMON;
751       +  CCOLYTD = CÄ¢¹½tvIDTOT;
752       +  CCOLMON = CÄ¢¹½tvIDMON;
753       + END;
754       + ELSE DO;
755       +  NCOLYTD + NÄ¢¹½tvIDTOT;
756       +  NCOLMON + NÄ¢¹½tvIDMON;
757       +  CCOLYTD + CÄ¢¹½tvIDTOT;
758       +  CCOLMON + CÄ¢¹½tvIDMON;
759       + END;
760       + IF LAST.Cost_Center_Hierarchy THEN DO;
761       +   NCOLYTD = ROUND(NCOLYTD,1.);
762       +   NCOLMON = ROUND(NCOLMON,1.);
763       +   CCOLYTD = ROUND(CCOLYTD,1.);
764       +   CCOLMON = ROUND(CCOLMON,1.);
765       +   OUTPUT;
766       + END;

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

      

767       + proc sort; by Cost_Center_Hierarchy;
768       +

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: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

769       +DATA BAD; SET GLSSPS10;
770       + 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
      

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

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

825       +        CCOLMON="&HEADER &EFFYR CONT"
826       +        NCOLYTD ="FY &FISCAL YTD NEW"
827       +        CCOLYTD="FY &FISCAL YTD CONT")
828       +        * SUM=' ' /
829       +        BOX='COLLEGES';
830       +RUN;*/
831       +
832       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
833       +ods html close;
834       +%END;
835       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
836       +ods pdf close;
837       +%END;
838       +
839       +%END;
840       +%MEND PRINT;
841       +%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.00 seconds
      cpu time            0.00 seconds
      

SYMBOLGEN:  Macro variable TME resolves to    62252.622

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

WARNING: Style FSS not found; Printer style will be used instead.
NOTE: Writing ODS PDF output to DISK destination "_WEBOUT", printer "PDF".
                                                                 The SAS System

SYMBOLGEN:  Macro variable MON resolves to JANUARY  
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
SYMBOLGEN:  Macro variable HEADER resolves to   JANUARY
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
SYMBOLGEN:  Macro variable HEADER resolves to   JANUARY
SYMBOLGEN:  Macro variable EFFYR resolves to 2017
SYMBOLGEN:  Macro variable FISCAL resolves to 2017
SYMBOLGEN:  Macro variable FISCAL resolves to 2017

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 CF53E2E2-E769-4DB0-B263-2A810A6525E0.
842       +
843       +*  Begin EG generated code (do not edit this line);
844       +;*';*";*/;quit;
845       +
846       +*  End EG generated code (do not edit this line);
847       +
NOTE: %INCLUDE (level 1) ending.