SAS Log

1                                                                                                                        The SAS System                                                                                             16:54 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.01 seconds
      cpu time            0.01 seconds
      
NOTE: The autoexec file, D:\SAS\EnterpriseSAS\Lev1\SASApp\StoredProcessServer\autoexec.sas, was executed at server initialization.

>>> SAS Macro Variables:

 EFFDTE=20161031
 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/FUNDCD2
 _REPLAY="&_URL?_sessionid=5B8D4C6C-6B62-4F4D-877D-AA424E089264&_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.TCAT0006
 _URL=/SASStoredProcess/do
 _USERLOCALE=en_US
 _USERNAME=FSSGuest@saspw
 _VERSION=Version 9.3 (Build 478)

NOTE: %INCLUDE (level 1) file D:\SAS Stored Processes\FSS\FUNDCD2.sas is file D:\SAS Stored Processes\FSS\FUNDCD2.sas.
2         +*  Begin EG generated code (do not edit this line);
3         +*
4         +*  Stored process registered by
5         +*  Enterprise Guide Stored Process Manager V5.1
6         +*
7         +*  ====================================================================
8         +*  Stored process name: FUNDCD2
9         +*  ====================================================================
10        +*
11        +*  Stored process prompt dictionary:
12        +*  ____________________________________
13        +*  _ODSDEST
14        +*       Type: Text
15        +*      Label: _ODSDEST
16        +*       Attr: Visible
17        +*  ____________________________________
18        +*  EFFDTE
19        +*       Type: Text
20        +*      Label: EFFDTE
21        +*       Attr: Visible
22        +*  ____________________________________
23        +*;
24        +
25        +
26        +*ProcessBody;
27        +
28        +%global _ODSDEST
29        +        EFFDTE;
30        +
31        +OPTIONS VALIDVARNAME=ANY;
32        +
33        +%macro ExtendValidMemName;
34        +
35        +%if %sysevalf(&sysver>=9.3) %then options validmemname=extend;
36        +
37        +%mend ExtendValidMemName;
38        +
                                                                                          The SAS System

39        +%ExtendValidMemName;
40        +
41        +*  End EG generated code (do not edit this line);
42        +
43        +OPTIONS MISSING = ' '
44        +     LINESIZE=145 symbolgen;
45        +
46        +  *** ENTER EFFECTIVE DATE ***;
47        +*%LET EFFDTE = 20170228;
48        +%GetÄ¢¹½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.00 seconds
      cpu time            0.00 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).
      48:118   48: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 SAS System

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

**END*USEREND*USER**


SYMBOLGEN:  Macro variable _Ä¢¹½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
49        +
50        +DATA DATE;
51        +  EFFDTE  = "&EFFDTE";
SYMBOLGEN:  Macro variable EFFDTE resolves to 20161031
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        +IF EFFMN = 01 THEN MON = 'JANUARY  ';
73        +IF EFFMN = 02 THEN MON = 'FEBRUARY ';
74        +IF EFFMN = 03 THEN MON = 'MARCH    ';
75        +IF EFFMN = 04 THEN MON = 'APRIL    ';
76        +IF EFFMN = 05 THEN MON = 'MAY      ';
77        +IF EFFMN = 06 THEN MON = 'JUNE     ';
78        +IF EFFMN = 07 THEN MON = 'JULY     ';
79        +IF EFFMN = 08 THEN MON = 'AUGUST   ';
80        +IF EFFMN = 09 THEN MON = 'SEPTEMBER';
81        +IF EFFMN = 10 THEN MON = 'OCTOBER  ';
82        +IF EFFMN = 11 THEN MON = 'NOVEMBER ';
83        +IF EFFMN = 12 THEN MON = 'DECEMBER ';
84        + CALL SYMPUT('MON',MON);
85        +
86        +BEGFY=FISCAL-1;
87        +BEGFX = INPUT(PUT(BEGFY,4.),$4.);
88        +FISX = INPUT(PUT(FISCAL,4.),$4.);
89        +FORMAT BEGYR ENDYR $2.;
90        +BEGYR = SUBSTR(BEGFX,3,2);
91        +ENDYR = SUBSTR(FISX,3,2);
92        +CALL SYMPUT('BEGYR',BEGYR);
93        +CALL SYMPUT('ENDYR',ENDYR);
94        +
95        +     IF EFFMN = 01 THEN HEADER = '  JANUARY';
96        +ELSE IF EFFMN = 02 THEN HEADER = ' FEBRUARY';
97        +ELSE IF EFFMN = 03 THEN HEADER = '    MARCH';
98        +ELSE IF EFFMN = 04 THEN HEADER = '    APRIL';
99        +ELSE IF EFFMN = 05 THEN HEADER = '      MAY';
100       +ELSE IF EFFMN = 06 THEN HEADER = '     JUNE';
101       +ELSE IF EFFMN = 07 THEN HEADER = '     JULY';
102       +ELSE IF EFFMN = 08 THEN HEADER = '   AUGUST';
103       +ELSE IF EFFMN = 09 THEN HEADER = 'SEPTEMBER';
104       +ELSE IF EFFMN = 10 THEN HEADER = '  OCTOBER';
105       +ELSE IF EFFMN = 11 THEN HEADER = ' NOVEMBER';
106       +ELSE IF EFFMN = 12 THEN HEADER = ' DECEMBER';
                                                                 The SAS System

107       +CALL SYMPUT('HEADER',HEADER);

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      56:6    57:18   72:4    73:4    74:4    75:4    76:4    77:4    78:4    79:4    80:4    81:4    82:4    83:4    86:7    95:9    96:9
      97:9    98:9    99:9    100:9   101:9   102:9   103:9   104:9   105:9   106: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
      

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

133       +PROC SORT; BY ACCT;*/
134       +

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
      

135       +PROC SQL;
136       +CREATE TABLE FUND1 AS
137       +SELECT ORG_ID AS GRANT_ID,
138       +FUND
139       +FROM WDM.fin_fdm_DRIVERTAG
140       +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.00 seconds
      

141       +PROC SORT; BY GRANT_ID;
142       +

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

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

148       +sponsor_id,
149       +cont_line_status,
150       +workday_id,
151       +CONT_STATUS,
152       +is_primary
153       +FROM WDM.FIN_AWD_LINE
154       +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
      

155       +PROC SORT; BY GRANT_ID;
156       +

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
      

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

158       +PROC SORT; BY sponsor_id;
159       +

NOTE: There were 2710 observations read from the data set WORK.MRG1.
                                                                 The SAS System

NOTE: The data set WORK.MRG1 has 2710 observations and 9 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

160       +proc sql;
161       +create table SPON as
162       +select sponsor_id,
163       +SPONSOR_NAME,
164       +sponsor_type
165       +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.00 seconds
      

166       +proc sort; by sponsor_id;
167       +

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
      

168       +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.01 seconds
      cpu time            0.01 seconds
      
                                                                 The SAS System


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

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

171       +data setspon; set mrgspon; BY award_budg grant_id cont_line_status descending is_primary ;
172       +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
      

173       +proc sort; by workday_id;
174       +

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
      

175       +proc sql;
176       +create table task as
177       +select workday_id,
178       +org_id as tasknbr
179       +from WDM.FIN_AWD_LINE_ORG
180       +where substr(org_id,1,2) = 'TA';
NOTE: Table WORK.TASK created, with 5436 rows and 2 columns.
                                                                 The SAS System


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

181       +proc sort; by workday_id;
182       +

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
      

183       +data mrggrnt; merge task(in=a) setspon(in=b); by workday_id;
184       +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
      

185       +proc sort; by award_budg;
186       +

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
      

187       +PROC SQL;
                                                                 The SAS System

188       +CREATE TABLE AWARD1 AS
189       +SELECT AWARD_NUMBER as award_budg,
190       +PROPOSAL_ID as propnbr,
191       +AWARD_NAME,
192       +signed_date,
193       +TOTAL_AMOUNT AS AWD_TOTAL,
194       +award_date
195       +FROM WDM.FIN_AWD
196       +WHERE PROPOSAL_ID NE 0 and
197       +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
      

198       +PROC SORT; BY award_budg;
199       +

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

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

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      202: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.
NOTE: DATA statement used (Total process time):
                                                                 The SAS System

      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

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

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

252       +proc sql;
253       +CREATE TABLE SPEC AS
254       +SELECT AWARD_NUMBER as award_budg,
255       +REF_ID
256       +FROM WDM.FIN_AWD_SPEC_COND
257       +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.00 seconds
      cpu time            0.00 seconds
      

258       +PROC SORT; BY award_budg;
259       +

                                                                 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
      

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

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 20 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 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 20 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 20 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 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 20 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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.09 seconds
      cpu time            0.09 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.00 seconds
      cpu time            0.00 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.01 seconds
      cpu time            0.01 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.00 seconds
      cpu time            0.00 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 29 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 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 29 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 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 30 variables.
NOTE: DATA statement used (Total process time):
      real time           0.01 seconds
      cpu time            0.01 seconds
      

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

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

388       +
389       +PROC SORT DATA = GLSCOA;  BY FY ACCT ENTRY;*/
390       +

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

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

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

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

411       +PROC SORT DATA = budg1; BY ACTDTE grant_id;
412       +

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

413       +DATA GLSCOA15; SET budg1;
414       + BY ACTDTE grant_id;
415       + IF FIRST.grant_id THEN DO;
416       +        IF BAADJCD = 'New' THEN DO; NAMT = MONAMT; CAMT = 0; END;
417       +        IF BAADJCD = 'Continuation' THEN DO; NAMT = 0; CAMT = MONAMT; END;
418       +  END;
419       +  ELSE DO;
420       +         IF BAADJCD = 'New' THEN DO; NAMT + MONAMT; CAMT + 0; END;
421       +         IF BAADJCD = 'Continuation' THEN DO; NAMT + 0; CAMT + MONAMT; END;
422       + END;
423       + IF LAST.grant_id THEN OUTPUT;
424       +
425       +

NOTE: There were 100 observations read from the data set WORK.BUDG1.
NOTE: The data set WORK.GLSCOA15 has 99 observations and 36 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

                                                                 The SAS System

426       +PROC SQL;
427       +  CREATE TABLE PROJTRAN AS
428       +SELECT PROPOSAL_NBR     AS PROPNBR
429       +      ,TRX_NBR          AS TRXNBR
430       +      ,TRX_TYPE         AS TRXTYPE
431       +      ,TRX_STATUS       AS TRXSTAT
432       +      ,TO_SPA_DATE      AS RELDATE
433       +FROM SPM.PROJ_TRANSACTION
434       + WHERE TRX_STATUS IN ('AC','TE','CO');
NOTE: Table WORK.PROJTRAN created, with 17727 rows and 5 columns.

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

436       + PROC SORT; BY PROPNBR TRXNBR RELDATE;
437       +

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

438       +DATA SPS2;
439       + SET PROJTRAN; BY PROPNBR TRXNBR;
440       +    LENGTH MO YY $2.;
441       +    LENGTH YR $4.;
442       +    MO=MONTH(RELDATE);
443       +    YR=YEAR(RELDATE);
444       +    YY=SUBSTR(YR,3,2);
445       +    LENGTH EFFMY $4.;
446       +    EFFMY=YY||MO;
447       +    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).
      442:8   443: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 442:8   212 at 443: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
      

448       +    PROC SORT; BY PROPNBR EFFMY RELDATE;
449       +

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
      

450       + PROC SORT; BY PROPNBR TRXNBR;
451       +

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
      

452       +PROC SQL;
453       +    CREATE TABLE PISHR AS
454       +    SELECT PROPOSAL_NBR    AS PROPNBR,
455       +           TRX_NBR         AS TRXNBR,
456       +           TASK_NBR        AS TASK,
457       +           Ä¢¹½tv_ID          AS Ä¢¹½tvID,
                                                                 The SAS System

458       +           INVESTIGATOR_TYPE AS INVTYPE,
459       +           DEPT_CD         AS DPT,
460       +           PROJECT_SHARE   AS SHARE
461       +    FROM SPM.PROJ_INVESTIGATOR
462       +    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.15 seconds
      cpu time            0.09 seconds
      

463       +    PROC SORT; BY PROPNBR TRXNBR TASK;
464       +

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
      

465       +DATA SPS4;
466       +  MERGE SPS2(IN=A) PISHR(IN=B); BY PROPNBR TRXNBR; IF A & B;
467       +

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

468       +PROC SORT;  BY PROPNBR EFFMY RELDATE;
469       +

NOTE: There were 31069 observations read from the data set WORK.SPS4.
                                                                 The SAS System

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
      

470       +    PROC SORT; BY PROPNBR TRXNBR;
471       +

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
      

472       +DATA SPSFM1(DROP= MO YR YY BEGYRX ENDYRX END BEG)
473       +     SPSFM2(DROP= MO YR YY BEGYRX ENDYRX END BEG)
474       +     SPSFM3(DROP= MO YR YY BEGYRX ENDYRX END BEG)
475       +     SPSFM4(DROP= MO YR YY BEGYRX ENDYRX END BEG)
476       +     SPSFM5(DROP= MO YR YY BEGYRX ENDYRX END BEG)
477       +     SPSFM6(DROP= MO YR YY BEGYRX ENDYRX END BEG)
478       +     SPSFM7(DROP= MO YR YY BEGYRX ENDYRX END BEG)
479       +     SPSFM8(DROP= MO YR YY BEGYRX ENDYRX END BEG)
480       +     SPSFM9(DROP= MO YR YY BEGYRX ENDYRX END BEG)
481       +     SPSFM10(DROP= MO YR YY BEGYRX ENDYRX END BEG)
482       +     SPSFM11(DROP= MO YR YY BEGYRX ENDYRX END BEG)
483       +     SPSFM12(DROP= MO YR YY BEGYRX ENDYRX END BEG);
484       +     SET SPS4;
485       +  ENDYRX = &ENDYR;
SYMBOLGEN:  Macro variable ENDYR resolves to 17
486       +  BEGYRX = &BEGYR;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
487       +  END = INPUT(PUT(ENDYRX,Z2.),$2.);
488       +  BEG = INPUT(PUT(BEGYRX,Z2.),$2.);
489       +     IF (YY=&BEGYR AND MO <= 07) OR YY < &BEGYR THEN DO;
SYMBOLGEN:  Macro variable BEGYR resolves to 16
SYMBOLGEN:  Macro variable BEGYR resolves to 16
                                                                 The SAS System

490       +         ACTDTE = BEG||'07';
491       +         OUTPUT SPSFM1;
492       +         END;
493       +     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
494       +         ACTDTE = BEG||'08';
495       +         OUTPUT SPSFM2;
496       +         END;
497       +     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
498       +         ACTDTE = BEG||'09';
499       +         OUTPUT SPSFM3;
500       +         END;
501       +     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
502       +         ACTDTE = BEG||'10';
503       +         OUTPUT SPSFM4;
504       +         END;
505       +     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
506       +         ACTDTE = BEG||'11';
507       +         OUTPUT SPSFM5;
508       +         END;
509       +     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
510       +         ACTDTE = BEG||'12';
511       +         OUTPUT SPSFM6;
512       +         END;
513       +     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
514       +         ACTDTE = END||'01';
515       +         OUTPUT SPSFM7;
                                                                 The SAS System

516       +         END;
517       +     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
518       +         ACTDTE = END||'02';
519       +         OUTPUT SPSFM8;
520       +         END;
521       +     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
522       +         ACTDTE = END||'03';
523       +         OUTPUT SPSFM9;
524       +         END;
525       +     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
526       +         ACTDTE = END||'04';
527       +         OUTPUT SPSFM10;
528       +         END;
529       +     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
530       +         ACTDTE = END||'05';
531       +         OUTPUT SPSFM11;
532       +         END;
533       +     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
534       +         ACTDTE = END||'06';
535       +         OUTPUT SPSFM12;
536       +         END;
537       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      489:10   489:24   489:37   493:10   493:24   493:37   497:10   497:24   497:37   501:10   501:24   501:37   505:10   505:24   505:37
      509:10   509:24   509:37   513:9    513:26   513:40   517:9    517:26   517:40   521:9    521:26   521:40   525:9    525:26   525:40
      529:9    529:26   529:40   533:9    533:26   533:40   
NOTE: There were 31069 observations read from the data set WORK.SPS4.
                                                                 The SAS System

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
      

538       +DATA SPS6;
539       +    SET SPSFM1
540       +        SPSFM2
541       +        SPSFM3
542       +        SPSFM4
543       +        SPSFM5
544       +        SPSFM6
545       +        SPSFM7
546       +        SPSFM8
547       +        SPSFM9
548       +        SPSFM10
549       +        SPSFM11
550       +        SPSFM12;

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

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
      

551       +    PROC SORT; BY PROPNBR ACTDTE TRXNBR EFFMY;
552       +
553       +

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

554       +DATA SPS7X(KEEP=PROPNBR ACTDTE TRXNBR);
555       +  SET SPS6; BY PROPNBR ACTDTE TRXNBR EFFMY;
556       +    IF LAST.ACTDTE THEN OUTPUT SPS7X;
557       +

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
      

558       +PROC SORT; BY PROPNBR ACTDTE TRXNBR;
559       +

NOTE: There were 88505 observations read from the data set WORK.SPS7X.
                                                                 The SAS System

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
      

560       +DATA SPS7;
561       + MERGE SPS7X(IN=A) SPS6(IN=B);
562       + BY PROPNBR ACTDTE TRXNBR;
563       + IF A AND B;
564       +

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

565       +PROC SORT DATA = SPS7;  BY Ä¢¹½tvID;
566       +

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
      

567       +PROC SQL;
568       +  CREATE TABLE DIRFILE AS
569       + SELECT INDIV_NAME     AS PI
570       +       ,Ä¢¹½tv_ID         AS Ä¢¹½tvID
571       + FROM DIR.NAME;
NOTE: Table WORK.DIRFILE created, with 1159731 rows and 2 columns.

572       +
                                                                 The SAS System

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

573       +PROC SORT; BY Ä¢¹½tvID;
574       +

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

575       +DATA SPS8(KEEP=PI Ä¢¹½tvID DPT PROPNBR ACTDTE SHARE TASK INVTYPE);
576       +  MERGE DIRFILE(IN=A) SPS7(IN=B);
577       +  BY Ä¢¹½tvID;
578       +  IF B;
579       +
580       +/*PROC SQL;
581       +CREATE TABLE CODES AS
582       +SELECT CODE_TYPE AS CDTYPE
583       +      ,CODE_VALUE AS CODE
584       +      ,CODE_DESC AS CODENAME
585       +FROM COA.CODES
586       +WHERE CODE_TYPE = 'DA';
587       +
588       +PROC SORT DATA = CODES;
589       +  BY CODE;
590       +
591       +DATA NAMES(KEEP=DPT DPTNAME) COLNAME(KEEP=COLLEGE COLNAME);
592       + SET CODES;
593       +FORMAT COLLEGE DPT $5.;
594       +FORMAT COLNAME DPTNAME $35.;
595       + IF SUBSTR(CODE,4,2) = '  ' THEN DO;
596       +
597       +  COLLEGE = CODE;
                                                                 The SAS System

598       +  COLNAME = CODENAME;
599       +  OUTPUT COLNAME;
600       + END;
601       + ELSE DO;
602       +  DPT = CODE;
603       +  DPTNAME = CODENAME;
604       +  OUTPUT NAMES;
605       + END;
606       +
607       +PROC SORT DATA = NAMES;
608       +  BY DPT;
609       +
610       +PROC SORT DATA = SPS8;
611       +  BY DPT;
612       +
613       +DATA SPS9;
614       + MERGE NAMES(IN=A) SPS8(IN=B);
615       + BY DPT;
616       + IF B;
617       +  FORMAT DPTNAME $35.;
618       +  FORMAT COL $3.;
619       +  COL = SUBSTR(DPT,1,3);
620       +  COL1 = COL||'  ';
621       +  FORMAT COLLEGE $5.;
622       +  COLLEGE = COMPRESS(COL1);
623       +
624       +PROC SORT DATA = SPS9;
625       +  BY COLLEGE;
626       +
627       +PROC SORT DATA = COLNAME;
628       +  BY COLLEGE;
629       +
630       +DATA SPS10;
631       + MERGE COLNAME(IN=A) SPS9(IN=B);
632       + BY COLLEGE;
633       + IF B;*/
634       +

                                                                 The SAS System

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.25 seconds
      cpu time            0.24 seconds
      

635       +  proc sql;
636       +  create table ccdept as
637       +  select code_value1 as dpt,
638       +  code_value2 as CC
639       +  from spm.codes
640       +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
      

641       +proc sort; by  dpt;
642       +

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

643       +PROC SORT DATA = SPS8;
644       + BY dpt;
645       +

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

      real time           0.06 seconds
      cpu time            0.06 seconds
      

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

WARNING: Multiple lengths were specified for the BY variable DPT by input data sets. This may cause unexpected results.
NOTE: There were 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
      

647       +proc sort; by cc;
648       +

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.06 seconds
      cpu time            0.06 seconds
      

649       +proc sql;
650       +create table org as
651       +select org_id as CC,
652       +org_name as Cost_Center,
653       +superior_org as CC_Hier
654       +from wdm.organization
655       +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
      
                                                                 The SAS System


656       +proc sort;  BY CC;
657       +

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
      

658       +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.17 seconds
      cpu time            0.17 seconds
      

659       +proc sort;  BY CC_Hier;
660       +

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

661       +proc sql;
662       +create table org as
663       +select org_id as CC_Hier,
664       +org_name as Cost_Center_Hierarchy
665       +from wdm.organization
666       +where org_type = 'Cost_Center_Hierarchy';
                                                                 The SAS System

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
      

667       +proc sort;  BY CC_Hier;
668       +

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
      

669       +data mrgcc2; merge mrgcc2(in=a) org(in=b); by CC_Hier; if a;
670       +Cost_Center_Hierarchy = scan(Cost_Center_Hierarchy,-1,'|');
671       +Cost_Center = scan(Cost_Center,-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.40 seconds
      cpu time            0.40 seconds
      

672       +proc sort;  BY PROPNBR ACTDTE TASK;
673       +
674       +

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.45 seconds
      cpu time            0.45 seconds
                                                                 The SAS System

      

675       +PROC SORT DATA = GLSCOA15;
676       + BY PROPNBR ACTDTE TASK;
677       +

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

678       +PROC SQL;
679       + CREATE TABLE GLSSPS1 AS
680       + SELECT A.*,
681       +        B.PI,
682       +        B.Ä¢¹½tvID,
683       +        B.INVTYPE,
684       +        B.SHARE,
685       +        B.Cost_Center_Hierarchy,
686       +        B.CC,
687       +        B.Cost_Center
688       +FROM GLSCOA15 A,
689       +     mrgcc2  B
690       +WHERE A.PROPNBR = B.PROPNBR AND
691       +      A.ACTDTE  = B.ACTDTE AND
692       +      A.TASK    = B.TASK;
NOTE: Table WORK.GLSSPS1 created, with 154 rows and 43 columns.

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

695       +DATA GLSSPS10(KEEP=PROPNBR ACTDTE); SET GLSSPS1; BY PROPNBR ACTDTE;
                                                                 The SAS System

696       + IF FIRST.ACTDTE THEN OUTPUT;
697       +

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

698       +DATA GLSCOA10;
699       + MERGE GLSCOA15(IN=A) GLSSPS10(IN=B);
700       + BY PROPNBR ACTDTE;
701       + IF A AND NOT B;
702       +

NOTE: There were 99 observations read from the data set WORK.GLSCOA15.
NOTE: There were 83 observations read from the data set WORK.GLSSPS10.
NOTE: The data set WORK.GLSCOA10 has 0 observations and 36 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

703       +DATA GLSSPS;
704       + SET GLSSPS1 GLSCOA10;
705       +
706       + IF SHARE = '.' THEN DO; Ä¢¹½tvIDNTOT = NAMT; Ä¢¹½tvIDCTOT = CAMT; END;
707       + ELSE DO;
708       + Ä¢¹½tvIDNTOT = NAMT * SHARE / 100; Ä¢¹½tvIDCTOT = CAMT * SHARE / 100;
709       + END;
710       +

NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column).
      706:13   
NOTE: There were 154 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 154 observations and 45 variables.
                                                                 The SAS System

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

711       +PROC SORT; BY PROPNBR ACTDTE grant_id;
712       +

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

713       +PROC SORT DATA = GLSSPS; BY PROPNBR grant_id Ä¢¹½tvID Cost_Center;
714       +

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

715       +DATA GLSSPS10; SET GLSSPS; BY PROPNBR grant_id Ä¢¹½tvID Cost_Center;
716       +format grant_name1 grant_name2 $35.;
717       +grant_name1 = scan(Grant_name,2,"|");
718       +Grant_name2 = scan(grant_name,3,"|");
719       +grant_name = strip(grant_name1)||" | "||strip(grant_name2);
720       + IF FIRST.Cost_Center THEN DO;
721       +  DEPTCAMT = CAMT;
722       +  DEPTNAMT = NAMT;
723       +  Ä¢¹½tvIDNSH = Ä¢¹½tvIDNTOT;
724       +  Ä¢¹½tvIDCSH = Ä¢¹½tvIDCTOT;
725       + END;
726       + ELSE DO;
727       +  DEPTCAMT = CAMT;
                                                                 The SAS System

728       +  DEPTNAMT = NAMT;
729       +  Ä¢¹½tvIDNSH = Ä¢¹½tvIDNTOT;
730       +  Ä¢¹½tvIDCSH = Ä¢¹½tvIDCTOT;
731       + END;
732       + IF LAST.Cost_Center THEN DO;
733       +   Ä¢¹½tvIDNSH = ROUND(Ä¢¹½tvIDNSH,1.);
734       +   Ä¢¹½tvIDCSH = ROUND(Ä¢¹½tvIDCSH,1.);
735       +   IF (Ä¢¹½tvIDNSH = 0 AND Ä¢¹½tvIDCSH = 0) THEN DELETE;
736       +   OUTPUT;
737       + END;
738       +

NOTE: There were 154 observations read from the data set WORK.GLSSPS.
NOTE: The data set WORK.GLSSPS10 has 71 observations and 51 variables.
NOTE: DATA statement used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

739       +PROC SORT; BY Cost_Center_Hierarchy Cost_Center PROPNBR grant_id;
740       +
741       +/*proc sql;
742       +create table test as
743       +select *
744       +from k2_wd.wd_fdm_translation_table;
745       +proc sort; by code_value;
746       +
747       +data test2 (keep=dept cost_center); set test; by code_value;
748       +dept= substr(code_value,1,5);
749       +proc sort; by dept;
750       +
751       +data test3; set test2; by dept;
752       +if last.dept then output;
753       +proc sort; by dept;*/
754       +
755       +

NOTE: There were 71 observations read from the data set WORK.GLSSPS10.
                                                                 The SAS System

NOTE: The data set WORK.GLSSPS10 has 71 observations and 51 variables.
NOTE: PROCEDURE SORT used (Total process time):
      real time           0.00 seconds
      cpu time            0.00 seconds
      

756       +PROC TEMPLATE;
757       + DEFINE STYLE WHITE ;
758       + PARENT=STYLES.PRINTER;
759       + REPLACE COLOR_LIST /
760       +  'LINK' = BLUE
761       +  'BGH' = WHITE
762       +  'FG' = BLACK
763       +  'BG' = WHITE;
764       + END;
NOTE: STYLE 'White' has been saved to: WORK.TEMPLAT
765       + RUN;
NOTE: PROCEDURE TEMPLATE used (Total process time):
      real time           0.03 seconds
      cpu time            0.01 seconds
      

766       +
767       +*ODS PDF FILE=&PFILE NOTOC STYLE = WHITE ;
768       +
769       + %global _ODSDEST;
770       +%global _ODSSTYLE;
771       +
772       +%MACRO PRINT;
773       +OPTIONS ORIENTATION=LANDSCAPE;
774       +
775       +%IF (%UPCASE("&_ODSDEST") eq "PHTML")+ (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
776       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
777       +data _null_ ;
778       +	rc = stpsrv_header('Content-type','text/html');
779       +run ;
780       +ods listing close;
781       +ods html body=_webout style=WHITE;
                                                                 The SAS System

782       +%END;
783       +
784       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
785       +data _null_ ;
786       +	rc = stpsrv_header('Content-type','application/pdf') ;
787       +	rc = stpsrv_header('Content-disposition',"attachment; filename=&TME..pdf");
788       +run ;
789       +ods listing close;
790       +ods pdf file=_webout style=WHITE;
791       +%END;
792       +
793       +DATA _NULL_;
794       +    SET GLSSPS10 END=FINAL; BY Cost_Center_Hierarchy Cost_Center PROPNBR grant_id;
795       +    FILE PRINT HEADER=A ; options ls=160 pagesize=50;
796       +    NAM = TRIM(DPTNAME);
797       +      ATTLEN = LENGTH(NAM);
798       +      LEN = ATTLEN - 1 + 10;
799       +      UNDERLNE = REPEAT('_',LEN);
800       +    LONG = TRIM(LONG);
801       +
802       +    IF INTFLAG = 'Y' THEN DO;
803       +     NINTAMT = Ä¢¹½tvIDNSH;
804       +     CINTAMT = Ä¢¹½tvIDCSH;
805       +     NEXTAMT = 0;
806       +     CEXTAMT = 0;
807       +    END;
808       +    ELSE DO;
809       +     NINTAMT = 0;
810       +     CINTAMT = 0;
811       +     NEXTAMT = Ä¢¹½tvIDNSH;
812       +     CEXTAMT = Ä¢¹½tvIDCSH;
813       +    END;
814       +
815       +    GRAND + Ä¢¹½tvIDCSH + Ä¢¹½tvIDNSH;
816       +    CINTTOT + CINTAMT;
817       +    NINTTOT + NINTAMT;
818       +    CEXTTOT + CEXTAMT;
819       +    NEXTTOT + NEXTAMT;
                                                                 The SAS System

820       +
821       +    IF FIRST.Cost_Center_Hierarchy THEN DO;
822       +    COLCINT = CINTAMT;
823       +    COLNINT = NINTAMT;
824       +    COLCEXT = CEXTAMT;
825       +    COLNEXT = NEXTAMT;
826       +
827       +    PUT / @  5  Cost_Center_Hierarchy /;
828       +    END;
829       +
830       +    ELSE DO;
831       +     COLCINT + CINTAMT;
832       +     COLNINT + NINTAMT;
833       +     COLCEXT + CEXTAMT;
834       +     COLNEXT + NEXTAMT;
835       +    END;
836       +
837       +    IF FIRST.Cost_Center THEN DO;
838       +    DPTCINT = CINTAMT;
839       +    DPTNINT = NINTAMT;
840       +    DPTCEXT = CEXTAMT;
841       +    DPTNEXT = NEXTAMT;
842       +     PUT /      @1   CC '- ' Cost_Center //
843       +                @97   '  % '
844       +                @115   'INTERNAL'
845       +                @141  'EXTERNAL'/
846       +                @ 5   'INVESTIGATOR'
847       +                @25   'TITLE'
848       +                @58   'PROPOSAL #'
849       +                @69   'GRANT ID'
850       +                @96   'CREDIT'
851       +                @104  '       NEW         CONT'
852       +                @130  '       NEW         CONT'
853       +     OVERPRINT  @ 5   '___________________'
854       +                @25   '_______________________________'
855       +                @58   '__________'
856       +                @69   '_________'
857       +                @96 '______'
                                                                 The SAS System

858       +                @104  '_______________________'
859       +                @130  '_______________________'        /
860       +                @ 1   INVTYPE $1.
861       +                @ 5   PI $19.
862       +                @25   grant_name $31.
863       +                @57   PROPNBR 11.
864       +                @69   GRANT_ID $25.
865       +                @96   SHARE 6.2
866       +                @104  NINTAMT COMMA11.
867       +                @116 CINTAMT COMMA11.
868       +                @130  NEXTAMT COMMA11.
869       +                @142 CEXTAMT COMMA11./
870       +                @25   LONG   $31./;
871       +     END;
872       +
873       +    ELSE DO;
874       +    DPTCINT + CINTAMT;
875       +    DPTNINT + NINTAMT;
876       +    DPTCEXT + CEXTAMT;
877       +    DPTNEXT + NEXTAMT;
878       +   PUT       @ 1   INVTYPE $1.
879       +             @ 5   PI $19.
880       +             @25   grant_name $31.
881       +             @57   PROPNBR 11.
882       +             @69   GRANT_ID $25.
883       +             @96   SHARE 6.2
884       +             @104  NINTAMT COMMA11.
885       +             @116 CINTAMT COMMA11.
886       +             @130  NEXTAMT COMMA11.
887       +             @142 CEXTAMT COMMA11./
888       +             @25   LONG   $31./;
889       +    END;
890       +
891       +    IF LAST.Cost_Center THEN DO;
892       +    PUT        @1 /
893       +               @84 'TOTAL COST CENTER'
894       +               @104  DPTNINT DOLLAR11.
895       +               @116 DPTCINT DOLLAR11.
                                                                 The SAS System

896       +               @130 DPTNEXT DOLLAR11.
897       +               @142 DPTCEXT DOLLAR11./;
898       +    END;
899       +
900       +    IF LAST.Cost_Center_Hierarchy THEN DO;
901       +    PUT        @1 /
902       +               @84 'TOTAL CC HIERARCHY'
903       +               @104  COLNINT DOLLAR11.
904       +               @116 COLCINT DOLLAR11.
905       +               @130 COLNEXT DOLLAR11.
906       +               @142 COLCEXT DOLLAR11./;
907       +    PUT _PAGE_;
908       +    END;
909       +
910       +    IF FINAL THEN DO;
911       +    PUT        @1 /
912       +               @104 NINTTOT DOLLAR11.
913       +               @116 CINTTOT DOLLAR11.
914       +               @130 NEXTTOT DOLLAR11.
915       +               @142 CEXTTOT DOLLAR11.
916       +               @1 /
917       +               @66 'GRAND TOTAL'
918       +               @78  GRAND DOLLAR16./;
919       +    PUT _PAGE_;
920       +    END;
921       +
922       +RETURN;
923       +A:
924       +PUT            @97   '  % '
925       +               @115   'INTERNAL'
926       +               @141  'EXTERNAL'/
927       +               @ 5   'INVESTIGATOR'
928       +               @25   'TITLE'
929       +               @58   'PROPOSAL #'
930       +                @69   'GRANT ID'
931       +                @96   'CREDIT'
932       +                @104  '       NEW         CONT'
933       +                @130  '       NEW         CONT'
                                                                 The SAS System

934       +     OVERPRINT  @ 5   '___________________'
935       +                @25   '_______________________________'
936       +                @58   '__________'
937       +                @69   '_________'
938       +                @96 '______'
939       +                @104  '_______________________'
940       +                @130  '_______________________'        /;
941       +RETURN;
942       +
943       +TITLE 'MONTHLY REPORT OF SPONSORED AGREEMENTS';
944       +TITLE2 'BY COST CENTER AND CC HIERARCHY';
945       +TITLE3 "PROCESSED IN &MON &EFFYR";
946       +TITLE4 '  ';
947       +RUN;
948       +%IF (%UPCASE("&_ODSDEST") eq "PHTML") %THEN %DO;
949       +ods html close;
950       +%END;
951       +%IF (%UPCASE("&_ODSDEST") eq "PDF") %THEN %DO;
952       +ods pdf close;
953       +%END;
954       +
955       +%END;
956       +%MEND PRINT;
957       +%PRINT;
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable TME resolves to    60880.905

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

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

      real time           0.04 seconds
      cpu time            0.04 seconds
      

SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
SYMBOLGEN:  Macro variable _ODSDEST resolves to PDF
NOTE: ODS PDF printed 19 pages to 687692E1-7472-4F82-8B7C-289862E9B76A.
958       +
959       +*ODS PDF CLOSE;
960       +
961       +/*ODS HTML FILE=&HFILE STYLE=MINIMAL  RS=NONE ;
962       +
963       +DATA _NULL_;
964       +    SET GLSSPS10 END=FINAL; BY COLLEGE DPT PROPNBR ACCT;
965       +    FILE PRINT HEADER=A;
966       +    NAM = TRIM(DPTNAME);
967       +      ATTLEN = LENGTH(NAM);
968       +      LEN = ATTLEN - 1 + 10;
969       +      UNDERLNE = REPEAT('_',LEN);
970       +    LONG = TRIM(LONG);
971       +
972       +    IF INTFLAG = 'Y' THEN DO;
973       +     NINTAMT = Ä¢¹½tvIDNSH;
974       +     CINTAMT = Ä¢¹½tvIDCSH;
975       +     NEXTAMT = 0;
976       +     CEXTAMT = 0;
977       +    END;
978       +    ELSE DO;
979       +     NINTAMT = 0;
980       +     CINTAMT = 0;
981       +     NEXTAMT = Ä¢¹½tvIDNSH;
982       +     CEXTAMT = Ä¢¹½tvIDCSH;
983       +    END;
984       +
985       +    GRAND + Ä¢¹½tvIDCSH + Ä¢¹½tvIDNSH;
986       +    CINTTOT + CINTAMT;
987       +    NINTTOT + NINTAMT;
988       +    CEXTTOT + CEXTAMT;
989       +    NEXTTOT + NEXTAMT;
990       +
991       +    IF FIRST.COLLEGE THEN DO;
992       +    COLCINT = CINTAMT;
993       +    COLNINT = NINTAMT;
994       +    COLCEXT = CEXTAMT;
995       +    COLNEXT = NEXTAMT;
996       +    PUT / @  5  COLLEGE '- ' COLNAME /;
997       +    END;
998       +
                                                                         The SAS System

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

1047      +   PUT         @ 1   INVTYPE $1.
1048      +               @ 5   PI $24.
1049      +               @25   STITLE $35.
1050      +               @57   PROPNBR 11.
1051      +               @69   ACCT $9.
1052      +               @80   SHARE 6.2
1053      +               @88  NINTAMT COMMA11.
1054      +               @100 CINTAMT COMMA11.
1055      +               @114  NEXTAMT COMMA11.
1056      +               @126 CEXTAMT COMMA11./
1057      +               @25   LONG   $31./;
1058      +    END;
1059      +
1060      +    IF LAST.DPT THEN DO;
1061      +    PUT        @1 /
1062      +               @68 'TOTAL DEPARTMENT'
1063      +               @88  DPTNINT DOLLAR11.
1064      +               @100 DPTCINT DOLLAR11.
1065      +               @114 DPTNEXT DOLLAR11.
1066      +               @126 DPTCEXT DOLLAR11./;
1067      +    END;
1068      +
1069      +    IF LAST.COLLEGE THEN DO;
1070      +    PUT        @1 /
1071      +               @75 'TOTAL COLLEGE'
1072      +               @88  COLNINT DOLLAR11.
1073      +               @100 COLCINT DOLLAR11.
1074      +               @114 COLNEXT DOLLAR11.
1075      +               @126 COLCEXT DOLLAR11./;
1076      +    PUT _PAGE_;
1077      +    END;
1078      +
1079      +    IF FINAL THEN DO;
1080      +    PUT        @1 /
1081      +               @88 NINTTOT DOLLAR11.
1082      +               @100 CINTTOT DOLLAR11.
1083      +               @114 NEXTTOT DOLLAR11.
1084      +               @126 CEXTTOT DOLLAR11.
1085      +               @1 /
1086      +               @50 'GRAND TOTAL'
1087      +               @62  GRAND DOLLAR16./;
1088      +    PUT _PAGE_;
1089      +    END;
1090      +
1091      +RETURN;
1092      +A:
1093      +PUT             @81   '  % '
1094      +                @99   'INTERNAL'
                                                                         The SAS System

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