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 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 %macro loop(year_start, year_end); 26 27 *loop over years; 28 29 %do year=&year_start %to &year_end; 30 *create macro variable for previous years; 31 %let prev_year=%eval(&year_start-1); 32 33 DATA SchoolAidFY&year_start.; 34 Set work.forecastinputs; 35 36 37 * COST PER PUPIL AMOUNTS; 38 L201_FY&start_year.= L203_FY&prev_year.; 39 L202_FY&start_year.= Round(SCPP*SPG_FY&start_year.,1); 40 L203_FY&start_year.= Sum(L201_FY&start_year.,L202_FY&start_year.); 41 L204_FY&start_year.= L206_FY&prev_year.; 42 L205_FY&start_year.= Round(TS_SCPP*SPG_FY&start_year.,0.01); 43 L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 44 L207_FY&start_year.= L209_FY&prev_year.; 45 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); 46 L209_FY&start_year.= Sum(L207_FY&start_year.,L208_FY&start_year.); 47 L210_FY&start_year.= L212_FY&prev_year.; 48 L211_FY&start_year.= Round(EI_SCPP*SPG_FY&start_year.,0.01); 49 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); 50 L213_FY&start_year.= L215_FY&prev_year.; 51 L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); 52 L215_FY&start_year.= Sum(L213_FY&start_year.,L214_FY&start_year.); 53 54 Run; 55 56 57 %end; 2 The SAS System 11:35 Monday, September 28, 2015 58 *end of do loop; 59 60 %mend; 61 *end of macro; 62 63 %loop(year_start=17, year_end=20); MPRINT(LOOP): *loop over years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_END resolves to 20 MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): DATA SchoolAidFY17; MPRINT(LOOP): Set work.forecastinputs; MPRINT(LOOP): * COST PER PUPIL AMOUNTS; WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 180: 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 180-322: Statement is not valid or it is used out of proper order. 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L201_FY&start_year.= L203_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L202_FY&start_year.= Round(SCPP*SPG_FY&start_year.,1); WARNING: Apparent symbolic reference START_YEAR not resolved. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L203_FY&start_year.= Sum(L201_FY&start_year.,L202_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); _______ 180 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. 3 The SAS System 11:35 Monday, September 28, 2015 NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; _______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L204_FY&start_year.= L206_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L205_FY&start_year.= Round(TS_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY&start_year.= L209_FY16; NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= _______ _______ _______ 180 180 180 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L209_FY&start_year.= Sum(L207_FY&start_year.,L208_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= _______ 180 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L210_FY&start_year.= L212_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L211_FY&start_year.= Round(EI_SCPP*SPG_FY&start_year.,0.01); NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; _______ _______ 180 180 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); 4 The SAS System 11:35 Monday, September 28, 2015 WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L213_FY&start_year.= L215_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L215_FY&start_year.= Sum(L213_FY&start_year.,L214_FY&start_year.); 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 1197 variables. WARNING: Data set WORK.SCHOOLAIDFY17 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): DATA SchoolAidFY17; MPRINT(LOOP): Set work.forecastinputs; MPRINT(LOOP): * COST PER PUPIL AMOUNTS; WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 180: 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 180-322: Statement is not valid or it is used out of proper order. 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L201_FY&start_year.= L203_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L202_FY&start_year.= Round(SCPP*SPG_FY&start_year.,1); 5 The SAS System 11:35 Monday, September 28, 2015 WARNING: Apparent symbolic reference START_YEAR not resolved. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L203_FY&start_year.= Sum(L201_FY&start_year.,L202_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); _______ 180 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; _______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L204_FY&start_year.= L206_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L205_FY&start_year.= Round(TS_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY&start_year.= L209_FY16; NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= _______ _______ _______ 180 180 180 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); 6 The SAS System 11:35 Monday, September 28, 2015 WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L209_FY&start_year.= Sum(L207_FY&start_year.,L208_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= _______ 180 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L210_FY&start_year.= L212_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L211_FY&start_year.= Round(EI_SCPP*SPG_FY&start_year.,0.01); NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; _______ _______ 180 180 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L213_FY&start_year.= L215_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L215_FY&start_year.= Sum(L213_FY&start_year.,L214_FY&start_year.); 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 1197 7 The SAS System 11:35 Monday, September 28, 2015 variables. WARNING: Data set WORK.SCHOOLAIDFY17 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.03 seconds MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): DATA SchoolAidFY17; MPRINT(LOOP): Set work.forecastinputs; MPRINT(LOOP): * COST PER PUPIL AMOUNTS; WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 180: 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 180-322: Statement is not valid or it is used out of proper order. 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L201_FY&start_year.= L203_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L202_FY&start_year.= Round(SCPP*SPG_FY&start_year.,1); WARNING: Apparent symbolic reference START_YEAR not resolved. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L203_FY&start_year.= Sum(L201_FY&start_year.,L202_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); _______ 180 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 8 The SAS System 11:35 Monday, September 28, 2015 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; _______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L204_FY&start_year.= L206_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L205_FY&start_year.= Round(TS_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY&start_year.= L209_FY16; NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= _______ _______ _______ 180 180 180 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L209_FY&start_year.= Sum(L207_FY&start_year.,L208_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= _______ 180 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L210_FY&start_year.= L212_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L211_FY&start_year.= Round(EI_SCPP*SPG_FY&start_year.,0.01); NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; _______ _______ 180 180 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 9 The SAS System 11:35 Monday, September 28, 2015 NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L213_FY&start_year.= L215_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L215_FY&start_year.= Sum(L213_FY&start_year.,L214_FY&start_year.); 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 1197 variables. WARNING: Data set WORK.SCHOOLAIDFY17 was not replaced because this step was stopped. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(LOOP): *create macro variable for previous years; SYMBOLGEN: Macro variable YEAR_START resolves to 17 SYMBOLGEN: Macro variable YEAR_START resolves to 17 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): DATA SchoolAidFY17; MPRINT(LOOP): Set work.forecastinputs; MPRINT(LOOP): * COST PER PUPIL AMOUNTS; WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 180: 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 180-322: Statement is not valid or it is used out of proper order. 180: 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 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L201_FY&start_year.= L203_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L202_FY&start_year.= Round(SCPP*SPG_FY&start_year.,1); WARNING: Apparent symbolic reference START_YEAR not resolved. NOTE: Line generated by the invoked macro "LOOP". 10 The SAS System 11:35 Monday, September 28, 2015 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L203_FY&start_year.= Sum(L201_FY&start_year.,L202_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= _______ 180 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); _______ 180 63 ! L207_FY&start_year.= L209_FY&prev_year.; ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 ,L202_FY&start_year.); L204_FY&start_year.= L206_FY&prev_year.; L205_FY&start_year.= 63 ! Round(TS_SCPP*SPG_FY&start_year.,0.01); L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); 63 ! L207_FY&start_year.= L209_FY&prev_year.; _______ 180 ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L204_FY&start_year.= L206_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L205_FY&start_year.= Round(TS_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L206_FY&start_year.= Sum(L204_FY&start_year.,L205_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 MPRINT(LOOP): L207_FY&start_year.= L209_FY16; NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= _______ _______ _______ 180 180 180 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. 11 The SAS System 11:35 Monday, September 28, 2015 WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L209_FY&start_year.= Sum(L207_FY&start_year.,L208_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L208_FY&start_year.= Round(PD_SCPP*SPG_FY&start_year.,0.01); L209_FY&start_year.= 63 ! Sum(L207_FY&start_year.,L208_FY&start_year.); L210_FY&start_year.= L212_FY&prev_year.; L211_FY&start_year.= _______ 180 63 ! Round(EI_SCPP*SPG_FY&start_year.,0.01); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L210_FY&start_year.= L212_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L211_FY&start_year.= Round(EI_SCPP*SPG_FY&start_year.,0.01); NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; _______ _______ 180 180 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); WARNING: Apparent symbolic reference START_YEAR not resolved. SYMBOLGEN: Macro variable PREV_YEAR resolves to 16 NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. NOTE: Line generated by the invoked macro "LOOP". 63 L212_FY&start_year.= Sum(L210_FY&start_year.,L211_FY&start_year.); L213_FY&start_year.= L215_FY&prev_year.; 63 ! L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); L215_FY&start_year.= _______ 180 63 ! Sum(L213_FY&start_year.,L214_FY&start_year.); ERROR 180-322: Statement is not valid or it is used out of proper order. MPRINT(LOOP): L213_FY&start_year.= L215_FY16; WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L214_FY&start_year.= Round(TL_SCPP*SPG_FY&start_year.,0.01); WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. WARNING: Apparent symbolic reference START_YEAR not resolved. MPRINT(LOOP): L215_FY&start_year.= Sum(L213_FY&start_year.,L214_FY&start_year.); 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 1197 variables. WARNING: Data set WORK.SCHOOLAIDFY17 was not replaced because this step was stopped. 12 The SAS System 11:35 Monday, September 28, 2015 NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds MPRINT(LOOP): *end of do loop; 64 65 66 67 68 GOPTIONS NOACCESSIBLE; 69 %LET _CLIENTTASKLABEL=; 70 %LET _CLIENTPROJECTPATH=; 71 %LET _CLIENTPROJECTNAME=; 72 %LET _SASPROGRAMFILE=; 73 74 ;*';*";*/;quit;run; 75 ODS _ALL_ CLOSE; 76 77 78 QUIT; RUN; 79