1 The SAS System 11:35 Monday, September 28, 2015 1 ;*';*";*/;quit;run; 2 OPTIONS PAGENO=MIN; 3 %LET _CLIENTTASKLABEL='Program - Copy - Copy'; 4 %LET _CLIENTPROJECTPATH=Userpath\FY2016_FY2022_1.2.egp'; 5 %LET _CLIENTPROJECTNAME='FY2016_FY2022_1.2.egp'; 6 %LET _SASPROGRAMFILE=; 7 8 ODS _ALL_ CLOSE; 9 OPTIONS DEV=ACTIVEX; 10 GOPTIONS XPIXELS=0 YPIXELS=0; 11 FILENAME EGSR TEMP; 12 ODS tagsets.sasreport13(ID=EGSR) FILE=EGSR 13 STYLE=HtmlBlue 14 STYLESHEET=(URL="file:///C:/Program%20Files/SASHome9.4/SASEnterpriseGuide/7.1/Styles/HtmlBlue.css") 15 NOGTITLE 16 NOGFOOTNOTE 17 GPATH=&sasworklocation SYMBOLGEN: Macro variable SASWORKLOCATION resolves to "Userpath\Prc2/" 18 ENCODING=UTF8 19 options(rolap="on") 20 ; NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR 21 22 GOPTIONS ACCESSIBLE; 23 *Start macro loop - takes two parameters, the first year of the dataset to be created and the last year; 24 /*Options Mprint Symbolgen;*/ 25 26 27 28 29 %macro loop(year_start, year_end); 30 31 32 *loop over years; 33 34 35 36 DATA SchoolAidFY&year_start.; 37 Set work.SchoolAidFY&prev_year.; 38 39 %do year=&year_start %to &year_end; 40 *create macro variable for previous years; 41 %let prev_year=%eval(&year_start-1); 42 43 /*DATA SchoolAidFY&year_start.;*/ 44 /*Set work.forecastinputs;*/ 45 46 47 48 49 * COST PER PUPIL AMOUNTS; 50 L201_FY&year_start.= L203_FY&prev_year.; 51 L202_FY&year_start.= Round(SCPP*SPG_FY&year_start.,1); 52 L203_FY&year_start.= Sum(L201_FY&year_start.,L202_FY&year_start.); 53 L204_FY&year_start.= L206_FY&prev_year.; 54 L205_FY&year_start.= Round(TS_SCPP*SPG_FY&year_start.,0.01); 55 L206_FY&year_start.= Sum(L204_FY&year_start.,L205_FY&year_start.); 2 The SAS System 11:35 Monday, September 28, 2015 56 L207_FY&year_start.= L209_FY&prev_year.; 57 L208_FY&year_start.= Round(PD_SCPP*SPG_FY&year_start.,0.01); 58 L209_FY&year_start.= Sum(L207_FY&year_start.,L208_FY&year_start.); 59 L210_FY&year_start.= L212_FY&prev_year.; 60 L211_FY&year_start.= Round(EI_SCPP*SPG_FY&year_start.,0.01); 61 L212_FY&year_start.= Sum(L210_FY&year_start.,L211_FY&year_start.); 62 L213_FY&year_start.= L215_FY&prev_year.; 63 L214_FY&year_start.= Round(TL_SCPP*SPG_FY&year_start.,0.01); 64 L215_FY&year_start.= Sum(L213_FY&year_start.,L214_FY&year_start.); 65 66 Run; 67 68 69 %end; 70 *end of do loop; 71 72 %mend; 73 *end of macro; 74 75 76 %loop(year_start=17, year_end=22); MPRINT(LOOP): *loop over years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 22: LINE and COLUMN cannot be determined. NOTE 242-205: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 22-322: Syntax error, expecting one of the following: a name, a quoted string, (, -, :, ;, CUROBS, END, INDSNAME, KEY, KEYRESET, KEYS, NOBS, OPEN, POINT, _DATA_, _LAST_, _NULL_. 200: LINE and COLUMN cannot be determined. NOTE: NOSPOOL is on. Rerunning with OPTION SPOOL might allow recovery of the LINE and COLUMN where the error has occurred. ERROR 200-322: The symbol is not recognized and will be ignored. MPRINT(LOOP): DATA SchoolAidFY17; WARNING: Apparent symbolic reference PREV_YEAR not resolved. MPRINT(LOOP): Set work.SchoolAidFY&prev_year.; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_END resolves to 22 MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): * COST PER PUPIL AMOUNTS; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L201_FY17= L203_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L202_FY17= Round(SCPP*SPG_FY17,1); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L203_FY17= Sum(L201_FY17,L202_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L204_FY17= L206_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L205_FY17= Round(TS_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L206_FY17= Sum(L204_FY17,L205_FY17); 3 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY17= L209_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L208_FY17= Round(PD_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L209_FY17= Sum(L207_FY17,L208_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L210_FY17= L212_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L211_FY17= Round(EI_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L212_FY17= Sum(L210_FY17,L211_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L213_FY17= L215_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L214_FY17= Round(TL_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L215_FY17= Sum(L213_FY17,L214_FY17); MPRINT(LOOP): Run; NOTE: The SAS System stopped processing this step because of errors. WARNING: The data set WORK.SCHOOLAIDFY17 may be incomplete. When this step was stopped there were 0 observations and 26 variables. WARNING: Data set WORK.SCHOOLAIDFY17 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): * COST PER PUPIL AMOUNTS; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the macro variable "YEAR_START". 76 L201_FY17 _________ 180 MPRINT(LOOP): L201_FY17= L203_FY16; ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L202_FY17 _________ 180 4 The SAS System 11:35 Monday, September 28, 2015 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L202_FY17= Round(SCPP*SPG_FY17,1); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L203_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L203_FY17= Sum(L201_FY17,L202_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L204_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L204_FY17= L206_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L205_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L205_FY17= Round(TS_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L206_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L206_FY17= Sum(L204_FY17,L205_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L207_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY17= L209_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 5 The SAS System 11:35 Monday, September 28, 2015 NOTE: Line generated by the macro variable "YEAR_START". 76 L208_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L208_FY17= Round(PD_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L209_FY17 _________ 180 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L209_FY17= Sum(L207_FY17,L208_FY17); ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L210_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L210_FY17= L212_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L211_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L211_FY17= Round(EI_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L212_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L212_FY17= Sum(L210_FY17,L211_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L213_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 6 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L213_FY17= L215_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L214_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L214_FY17= Round(TL_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L215_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L215_FY17= Sum(L213_FY17,L214_FY17); MPRINT(LOOP): Run; MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): * COST PER PUPIL AMOUNTS; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the macro variable "YEAR_START". 76 L201_FY17 _________ 180 MPRINT(LOOP): L201_FY17= L203_FY16; ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L202_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L202_FY17= Round(SCPP*SPG_FY17,1); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L203_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L203_FY17= Sum(L201_FY17,L202_FY17); 7 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L204_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L204_FY17= L206_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L205_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L205_FY17= Round(TS_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L206_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L206_FY17= Sum(L204_FY17,L205_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L207_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY17= L209_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L208_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L208_FY17= Round(PD_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L209_FY17 _________ 180 8 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L209_FY17= Sum(L207_FY17,L208_FY17); ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L210_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L210_FY17= L212_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L211_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L211_FY17= Round(EI_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L212_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L212_FY17= Sum(L210_FY17,L211_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L213_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L213_FY17= L215_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L214_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L214_FY17= Round(TL_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 9 The SAS System 11:35 Monday, September 28, 2015 76 L215_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L215_FY17= Sum(L213_FY17,L214_FY17); MPRINT(LOOP): Run; MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): * COST PER PUPIL AMOUNTS; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the macro variable "YEAR_START". 76 L201_FY17 _________ 180 MPRINT(LOOP): L201_FY17= L203_FY16; ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L202_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L202_FY17= Round(SCPP*SPG_FY17,1); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L203_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L203_FY17= Sum(L201_FY17,L202_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L204_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L204_FY17= L206_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L205_FY17 _________ 10 The SAS System 11:35 Monday, September 28, 2015 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L205_FY17= Round(TS_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L206_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L206_FY17= Sum(L204_FY17,L205_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L207_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY17= L209_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L208_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L208_FY17= Round(PD_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L209_FY17 _________ 180 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L209_FY17= Sum(L207_FY17,L208_FY17); ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L210_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L210_FY17= L212_FY16; 11 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L211_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L211_FY17= Round(EI_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L212_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L212_FY17= Sum(L210_FY17,L211_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L213_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L213_FY17= L215_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L214_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L214_FY17= Round(TL_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L215_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L215_FY17= Sum(L213_FY17,L214_FY17); MPRINT(LOOP): Run; MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): * COST PER PUPIL AMOUNTS; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 12 The SAS System 11:35 Monday, September 28, 2015 NOTE: Line generated by the macro variable "YEAR_START". 76 L201_FY17 _________ 180 MPRINT(LOOP): L201_FY17= L203_FY16; ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L202_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L202_FY17= Round(SCPP*SPG_FY17,1); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L203_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L203_FY17= Sum(L201_FY17,L202_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L204_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L204_FY17= L206_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L205_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L205_FY17= Round(TS_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L206_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 13 The SAS System 11:35 Monday, September 28, 2015 MPRINT(LOOP): L206_FY17= Sum(L204_FY17,L205_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L207_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY17= L209_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L208_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L208_FY17= Round(PD_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L209_FY17 _________ 180 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L209_FY17= Sum(L207_FY17,L208_FY17); ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L210_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L210_FY17= L212_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L211_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L211_FY17= Round(EI_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L212_FY17 _________ 180 14 The SAS System 11:35 Monday, September 28, 2015 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L212_FY17= Sum(L210_FY17,L211_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L213_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L213_FY17= L215_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L214_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L214_FY17= Round(TL_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L215_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L215_FY17= Sum(L213_FY17,L214_FY17); MPRINT(LOOP): Run; MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): * COST PER PUPIL AMOUNTS; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the macro variable "YEAR_START". 76 L201_FY17 _________ 180 MPRINT(LOOP): L201_FY17= L203_FY16; ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L202_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. 15 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L202_FY17= Round(SCPP*SPG_FY17,1); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L203_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L203_FY17= Sum(L201_FY17,L202_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L204_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L204_FY17= L206_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L205_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L205_FY17= Round(TS_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L206_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L206_FY17= Sum(L204_FY17,L205_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L207_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY17= L209_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L208_FY17 16 The SAS System 11:35 Monday, September 28, 2015 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L208_FY17= Round(PD_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L209_FY17 _________ 180 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L209_FY17= Sum(L207_FY17,L208_FY17); ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L210_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L210_FY17= L212_FY16; SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L211_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L211_FY17= Round(EI_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L212_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L212_FY17= Sum(L210_FY17,L211_FY17); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L213_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L213_FY17= L215_FY16; 17 The SAS System 11:35 Monday, September 28, 2015 SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L214_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L214_FY17= Round(TL_SCPP*SPG_FY17,0.01); SYMBOLGEN: Macro variable YEAR_START resolves to 17 NOTE: Line generated by the macro variable "YEAR_START". 76 L215_FY17 _________ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 MPRINT(LOOP): L215_FY17= Sum(L213_FY17,L214_FY17); MPRINT(LOOP): Run; MPRINT(LOOP): *end of do loop; 77 78 79 GOPTIONS NOACCESSIBLE; 80 %LET _CLIENTTASKLABEL=; 81 %LET _CLIENTPROJECTPATH=; 82 %LET _CLIENTPROJECTNAME=; 83 %LET _SASPROGRAMFILE=; 84 85 ;*';*";*/;quit;run; 86 ODS _ALL_ CLOSE; 87 88 89 QUIT; RUN; 90