Hi Reeza,    I tried it again and it actually worked! Thank you! ... View more

Thank you, Kurt! I didn't catch that mistake before.  ... View more

Thank you for the explanation! Shmuel's solution worked.  ... View more

Hi Shmuel!   Thank you so much for your help! I went through all of my code and inputted the length command into each of my merges and was able to solve the problem.    Amy ... View more

I'm not sure what you mean by a many to many merge.    But I'm merging several data sets to make TotalFunding and several data sets to make LCFF. Then I'm trying to merge them together. ... View more

Hi Reeza!   Here is the log:   1 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 55 56 /*Total Funding*/ 57 58 PROC IMPORT OUT= FundP106 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2006.xlsx" 59 DBMS=xlsx REPLACE; 60 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. CharterFundType -> VAR5 NOTE: Variable Name Change. DistrictType -> District__Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. California High School Exit Exam -> California_High_School_Exit_Exam NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change. Basic Aid "Choice"/Court-Ordered -> VAR19 NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education -> Gifted_and_Talented_Education NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education -> Adult_Education NOTE: Variable Name Change. Special Education AB 602 -> Special_Education_AB_602 NOTE: Variable Name Change. Special Education Infants 0-2 -> Special_Education_Infants_0_2 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter School Advance Payme -> New_Charter_School_Advance_Payme NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PYAmountCharterOverpaid -> VAR30 NOTE: Variable Name Change. PY Recomputations and Adjustment -> PY_Recomputations_and_Adjustment NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1659 observations and 33 variables. NOTE: WORK.FUNDP106 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 2.19 seconds cpu time 0.50 seconds 61 62 PROC SORT Data = FundP106; 63 By District; 64 RUN; NOTE: There were 1659 observations read from the data set WORK.FUNDP106. NOTE: The data set WORK.FUNDP106 has 1659 observations and 33 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 65 66 DATA FundP106; 67 Set FundP106 (drop = District_Code); 68 RUN; NOTE: There were 1659 observations read from the data set WORK.FUNDP106. NOTE: The data set WORK.FUNDP106 has 1659 observations and 32 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.01 seconds 69 70 PROC IMPORT OUT= FundP206 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2006.xlsx" 71 DBMS=xlsx REPLACE; 72 GETNAMES=yes;RUN; NOTE: Variable Name Change. CountyCode -> County__Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. CharterFundType -> VAR5 NOTE: Variable Name Change. DistrictType -> District__Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. California High School Exit Exam -> California_High_School_Exit_Exam NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change. Basic Aid "Choice"/Court-Ordered -> VAR19 NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education -> Gifted_and_Talented_Education NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education -> Adult_Education NOTE: Variable Name Change. Special EducationAB 602 -> Special_Education__AB_602 NOTE: Variable Name Change. Special Education Infants 0-2 -> Special_Education_Infants_0_2 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter School Advance Payme -> New_Charter_School_Advance_Payme NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PYAmountCharterOverpaid -> VAR30 NOTE: Variable Name Change. PY Recomputations and Adjustment -> PY_Recomputations_and_Adjustment NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1659 observations and 33 variables. NOTE: WORK.FUNDP206 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.95 seconds cpu time 0.59 seconds 73 74 PROC SORT Data = FundP206; 75 By District; 76 RUN; NOTE: There were 1659 observations read from the data set WORK.FUNDP206. NOTE: The data set WORK.FUNDP206 has 1659 observations and 33 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 77 78 DATA FundP206; 79 Set FundP206 (drop = District_Code); 80 RUN; NOTE: There were 1659 observations read from the data set WORK.FUNDP206. NOTE: The data set WORK.FUNDP206 has 1659 observations and 32 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 81 82 DATA TotalFund06 (KEEP = District TotalFundP1 TotalFundP2); 83 MERGE FundP106 FundP206; 84 WARNING: Multiple lengths were specified for the variable Charter_Number by input data set(s). This can cause truncation of data. WARNING: Multiple lengths were specified for the variable District by input data set(s). This can cause truncation of data. NOTE: There were 1659 observations read from the data set WORK.FUNDP106. NOTE: There were 1659 observations read from the data set WORK.FUNDP206. NOTE: The data set WORK.TOTALFUND06 has 1659 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 85 DATA TotalFund06; 86 Set TotalFund06; 87 TotalFund = TotalFundP1 + TotalFundP2; 88 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). 5 at 87:26 NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: The data set WORK.TOTALFUND06 has 1659 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 89 DATA TotalFund06 (DROP= TotalFundP1 TotalFundP2); 90 Set TotalFund06; 91 Year = 2006; 92 NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: The data set WORK.TOTALFUND06 has 1659 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 93 PROC SORT Data = TotalFund06; 94 By District; 95 RUN; NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: The data set WORK.TOTALFUND06 has 1659 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 96 97 PROC IMPORT OUT= FundP107 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2007.xlsx" 98 DBMS=xlsx REPLACE; 99 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. California High School Exit Exam -> California_High_School_Exit_Exam NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(6350/63 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR19 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(6390-8311) -> VAR24 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR26 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR27 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter School Advance Payme -> New_Charter_School_Advance_Payme NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. PY Recomputations and Adjustment -> PY_Recomputations_and_Adjustment NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1739 observations and 35 variables. NOTE: WORK.FUNDP107 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.27 seconds cpu time 0.55 seconds 100 101 PROC SORT Data = FundP107; 102 By District; 103 RUN; NOTE: There were 1739 observations read from the data set WORK.FUNDP107. NOTE: The data set WORK.FUNDP107 has 1739 observations and 35 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 104 105 DATA FundP107; 106 Set FundP107 (drop = District_Code); 107 RUN; NOTE: There were 1739 observations read from the data set WORK.FUNDP107. NOTE: The data set WORK.FUNDP107 has 1739 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.09 seconds cpu time 0.09 seconds 108 109 PROC IMPORT OUT= FundP207 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2007.xlsx" 110 DBMS=xlsx REPLACE; 111 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. California High School Exit Exam -> California_High_School_Exit_Exam NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(6350/63 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR19 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(6390-8311) -> VAR24 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR26 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR27 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter School Advance Payme -> New_Charter_School_Advance_Payme NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. PY Recomputations and Adjustment -> PY_Recomputations_and_Adjustment NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1738 observations and 35 variables. NOTE: WORK.FUNDP207 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.05 seconds cpu time 0.55 seconds 112 113 PROC SORT Data = FundP207; 114 By District; 115 RUN; NOTE: There were 1738 observations read from the data set WORK.FUNDP207. NOTE: The data set WORK.FUNDP207 has 1738 observations and 35 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 116 117 DATA FundP207; 118 Set FundP207 (drop = District_Code); 119 RUN; NOTE: There were 1738 observations read from the data set WORK.FUNDP207. NOTE: The data set WORK.FUNDP207 has 1738 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 120 121 DATA TotalFund07 (KEEP = District TotalFundP1 TotalFundP2); 122 MERGE FundP107 FundP207; 123 WARNING: Multiple lengths were specified for the variable District by input data set(s). This can cause truncation of data. NOTE: There were 1739 observations read from the data set WORK.FUNDP107. NOTE: There were 1738 observations read from the data set WORK.FUNDP207. NOTE: The data set WORK.TOTALFUND07 has 1739 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 124 DATA TotalFund07; 125 Set TotalFund07; 126 TotalFund = TotalFundP1 + TotalFundP2; 127 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). 6 at 126:26 NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: The data set WORK.TOTALFUND07 has 1739 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 128 DATA TotalFund07 (DROP= TotalFundP1 TotalFundP2); 129 Set TotalFund07; 130 Year = 2007; 131 NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: The data set WORK.TOTALFUND07 has 1739 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 132 PROC SORT Data = TotalFund07; 133 By District; 134 RUN; NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: The data set WORK.TOTALFUND07 has 1739 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 135 136 PROC IMPORT OUT= FundP108 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2008.xlsx" 137 DBMS=xlsx REPLACE; 138 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. California High School Exit Exam -> California_High_School_Exit_Exam NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(6350/63 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR19 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(6390-8311) -> VAR24 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR26 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR27 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter School Advance Payme -> New_Charter_School_Advance_Payme NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. PY Recomputations and Adjustment -> PY_Recomputations_and_Adjustment NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1815 observations and 35 variables. NOTE: WORK.FUNDP108 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.14 seconds cpu time 0.53 seconds 139 140 PROC SORT Data = FundP108; 141 By District; 142 RUN; NOTE: There were 1815 observations read from the data set WORK.FUNDP108. NOTE: The data set WORK.FUNDP108 has 1815 observations and 35 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 143 144 DATA FundP108; 145 Set FundP108 (drop = District_Code); 146 RUN; NOTE: There were 1815 observations read from the data set WORK.FUNDP108. NOTE: The data set WORK.FUNDP108 has 1815 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 147 148 PROC IMPORT OUT= FundP208 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2008.xlsx" 149 DBMS=xlsx REPLACE; 150 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. California High School Exit Exam -> California_High_School_Exit_Exam NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR19 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR24 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR26 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR27 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter School Advance Payme -> New_Charter_School_Advance_Payme NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. PY Recomputations and Adjustment -> PY_Recomputations_and_Adjustment NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1815 observations and 35 variables. NOTE: WORK.FUNDP208 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.19 seconds cpu time 0.48 seconds 151 152 PROC SORT Data = FundP208; 153 By District; 154 RUN; NOTE: There were 1815 observations read from the data set WORK.FUNDP208. NOTE: The data set WORK.FUNDP208 has 1815 observations and 35 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 155 156 DATA FundP208; 157 Set FundP208 (drop = District_Code); 158 RUN; NOTE: There were 1815 observations read from the data set WORK.FUNDP208. NOTE: The data set WORK.FUNDP208 has 1815 observations and 34 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 159 160 DATA TotalFund08 (KEEP = District TotalFundP1 TotalFundP2); 161 MERGE FundP108 FundP208; 162 NOTE: There were 1815 observations read from the data set WORK.FUNDP108. NOTE: There were 1815 observations read from the data set WORK.FUNDP208. NOTE: The data set WORK.TOTALFUND08 has 1815 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 163 DATA TotalFund08; 164 Set TotalFund08; 165 TotalFund = TotalFundP1 + TotalFundP2; 166 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). 9 at 165:26 NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: The data set WORK.TOTALFUND08 has 1815 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 167 DATA TotalFund08 (DROP= TotalFundP1 TotalFundP2); 168 Set TotalFund08; 169 Year = 2008; 170 NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: The data set WORK.TOTALFUND08 has 1815 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.04 seconds 171 PROC SORT Data = TotalFund08; 172 By District; 173 RUN; NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: The data set WORK.TOTALFUND08 has 1815 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 174 175 PROC IMPORT OUT= FundP109 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2009.xlsx" 176 DBMS=xlsx REPLACE; 177 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR25 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR27 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR28 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter and New Grade Level -> New_Charter_and_New_Grade_Level NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Recomputations and Adjustments -> Recomputations_and_Adjustments NOTE: Variable Name Change. Per - ADA Reduction -> Per___ADA_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1849 observations and 37 variables. NOTE: WORK.FUNDP109 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.25 seconds cpu time 0.54 seconds 178 179 PROC SORT Data = FundP109; 180 By District; 181 RUN; NOTE: There were 1849 observations read from the data set WORK.FUNDP109. NOTE: The data set WORK.FUNDP109 has 1849 observations and 37 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 182 183 DATA FundP109; 184 Set FundP109 (drop = District_Code); 185 RUN; NOTE: There were 1849 observations read from the data set WORK.FUNDP109. NOTE: The data set WORK.FUNDP109 has 1849 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.02 seconds 186 187 PROC IMPORT OUT= FundP209 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2009.xlsx" 188 DBMS=xlsx REPLACE; 189 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR25 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR27 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR28 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter and New Grade Level -> New_Charter_and_New_Grade_Level NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Recomputations and Adjustments -> Recomputations_and_Adjustments NOTE: Variable Name Change. Per - ADA Reduction -> Per___ADA_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1862 observations and 37 variables. NOTE: WORK.FUNDP209 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.31 seconds cpu time 0.57 seconds 190 191 PROC SORT Data = FundP209; 192 By District; 193 RUN; NOTE: There were 1862 observations read from the data set WORK.FUNDP209. NOTE: The data set WORK.FUNDP209 has 1862 observations and 37 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 194 195 DATA FundP209; 196 Set FundP209 (drop = District_Code); 197 RUN; NOTE: There were 1862 observations read from the data set WORK.FUNDP209. NOTE: The data set WORK.FUNDP209 has 1862 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 198 199 DATA TotalFund09 (KEEP = District TotalFundP1 TotalFundP2); 200 MERGE FundP109 FundP209; 201 WARNING: Multiple lengths were specified for the variable District by input data set(s). This can cause truncation of data. NOTE: There were 1849 observations read from the data set WORK.FUNDP109. NOTE: There were 1862 observations read from the data set WORK.FUNDP209. NOTE: The data set WORK.TOTALFUND09 has 1862 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 202 DATA TotalFund09; 203 Set TotalFund09; 204 TotalFund = TotalFundP1 + TotalFundP2; 205 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). 25 at 204:26 NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: The data set WORK.TOTALFUND09 has 1862 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 206 DATA TotalFund09 (DROP= TotalFundP1 TotalFundP2); 207 Set TotalFund09; 208 Year = 2009; 209 NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: The data set WORK.TOTALFUND09 has 1862 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 210 PROC SORT Data = TotalFund09; 211 By District; 212 RUN; NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: The data set WORK.TOTALFUND09 has 1862 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 213 214 PROC IMPORT OUT= FundP110 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2010.xlsx" 215 DBMS=xlsx REPLACE; 216 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR25 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR27 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR28 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter and New Grade Level -> New_Charter_and_New_Grade_Level NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Recomputations and Adjustments -> Recomputations_and_Adjustments NOTE: Variable Name Change. Per - ADA Reduction -> Per___ADA_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1948 observations and 37 variables. NOTE: WORK.FUNDP110 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.78 seconds cpu time 0.52 seconds 217 218 PROC SORT Data = FundP110; 219 By District; 220 RUN; NOTE: There were 1948 observations read from the data set WORK.FUNDP110. NOTE: The data set WORK.FUNDP110 has 1948 observations and 37 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 221 222 DATA FundP110; 223 Set FundP110 (drop = District_Code); 224 RUN; NOTE: There were 1948 observations read from the data set WORK.FUNDP110. NOTE: The data set WORK.FUNDP110 has 1948 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 225 226 PROC IMPORT OUT= FundP210 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2010.xlsx" 227 DBMS=xlsx REPLACE; 228 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR25 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR27 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR28 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter and New Grade Level -> New_Charter_and_New_Grade_Level NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Recomputations and Adjustments -> Recomputations_and_Adjustments NOTE: Variable Name Change. Per - ADA Reduction -> Per___ADA_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 1950 observations and 37 variables. NOTE: WORK.FUNDP210 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.72 seconds cpu time 0.56 seconds 229 230 PROC SORT Data = FundP210; 231 By District; 232 RUN; NOTE: There were 1950 observations read from the data set WORK.FUNDP210. NOTE: The data set WORK.FUNDP210 has 1950 observations and 37 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 233 234 DATA FundP210; 235 Set FundP210 (drop = District_Code); 236 RUN; NOTE: There were 1950 observations read from the data set WORK.FUNDP210. NOTE: The data set WORK.FUNDP210 has 1950 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.12 seconds cpu time 0.01 seconds 237 238 DATA TotalFund10 (KEEP = District TotalFundP1 TotalFundP2); 239 MERGE FundP110 FundP210; 240 NOTE: There were 1948 observations read from the data set WORK.FUNDP110. NOTE: There were 1950 observations read from the data set WORK.FUNDP210. NOTE: The data set WORK.TOTALFUND10 has 1950 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 241 DATA TotalFund10; 242 Set TotalFund10; 243 TotalFund = TotalFundP1 + TotalFundP2; 244 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). 8 at 243:26 NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: The data set WORK.TOTALFUND10 has 1950 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 245 DATA TotalFund10 (DROP= TotalFundP1 TotalFundP2); 246 Set TotalFund10; 247 Year = 2010; 248 NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: The data set WORK.TOTALFUND10 has 1950 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 249 PROC SORT Data = TotalFund10; 250 By District; 251 RUN; NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: The data set WORK.TOTALFUND10 has 1950 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 252 253 PROC IMPORT OUT= FundP111 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2011.xlsx" 254 DBMS=xlsx REPLACE; 255 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR25 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR27 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR28 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter and New Grade Level -> New_Charter_and_New_Grade_Level NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Recomputations and Adjustments -> Recomputations_and_Adjustments NOTE: Variable Name Change. Basic Aid Reduction -> Basic_Aid_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 2041 observations and 37 variables. NOTE: WORK.FUNDP111 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.27 seconds cpu time 0.64 seconds 256 257 PROC SORT Data = FundP111; 258 By District; 259 RUN; NOTE: There were 2041 observations read from the data set WORK.FUNDP111. NOTE: The data set WORK.FUNDP111 has 2041 observations and 37 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 260 261 DATA FundP111; 262 Set FundP111 (drop = District_Code); 263 RUN; NOTE: There were 2041 observations read from the data set WORK.FUNDP111. NOTE: The data set WORK.FUNDP111 has 2041 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 264 265 PROC IMPORT OUT= FundP211 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2011.xlsx" 266 DBMS=xlsx REPLACE; 267 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Total -> County_Office_of_Education_Total NOTE: Variable Name Change. School District Total Revenue Li -> School_District_Total_Revenue_Li NOTE: Variable Name Change. Local Funded Charter School Gene -> Local_Funded_Charter_School_Gene NOTE: Variable Name Change. Direct Funded Charter School Gen -> Direct_Funded_Charter_School_Gen NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship Funding(0000-83 -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Court-Ordered Voluntary Pupil Tr -> Court_Ordered_Voluntary_Pupil_Tr NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education Pr -> Gifted_and_Talented_Education_Pr NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR25 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR27 NOTE: Variable Name Change. Special Education Infants 0–2 -> VAR28 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New Charter and New Grade Level -> New_Charter_and_New_Grade_Level NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and Prior Year Recom -> Adjustments_and_Prior_Year_Recom NOTE: Variable Name Change. Basic Aid Reduction -> Basic_Aid_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 2034 observations and 37 variables. NOTE: WORK.FUNDP211 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.81 seconds cpu time 0.68 seconds 268 269 PROC SORT Data = FundP211; 270 By District; 271 RUN; NOTE: There were 2034 observations read from the data set WORK.FUNDP211. NOTE: The data set WORK.FUNDP211 has 2034 observations and 37 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 272 273 DATA FundP211; 274 Set FundP211 (drop = District_Code); 275 RUN; NOTE: There were 2034 observations read from the data set WORK.FUNDP211. NOTE: The data set WORK.FUNDP211 has 2034 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 276 277 DATA TotalFund11 (KEEP = District TotalFundP1 TotalFundP2); 278 MERGE FundP111 FundP211; 279 NOTE: There were 2041 observations read from the data set WORK.FUNDP111. NOTE: There were 2034 observations read from the data set WORK.FUNDP211. NOTE: The data set WORK.TOTALFUND11 has 2041 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 280 DATA TotalFund11; 281 Set TotalFund11; 282 TotalFund = TotalFundP1 + TotalFundP2; 283 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). 14 at 282:26 NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: The data set WORK.TOTALFUND11 has 2041 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 284 DATA TotalFund11 (DROP= TotalFundP1 TotalFundP2); 285 Set TotalFund11; 286 Year = 2011; 287 NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: The data set WORK.TOTALFUND11 has 2041 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 288 PROC SORT Data = TotalFund11; 289 By District; 290 RUN; NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: The data set WORK.TOTALFUND11 has 2041 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 291 292 PROC IMPORT OUT= FundP112 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2012.xlsx" 293 DBMS=xlsx REPLACE; 294 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Reven -> County_Office_of_Education_Reven NOTE: Variable Name Change. School District Revenue Limit St -> School_District_Revenue_Limit_St NOTE: Variable Name Change. Charter School General Purpose E -> Charter_School_General_Purpose_E NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Charter School In-Lieu of Econom -> Charter_School_In_Lieu_of_Econom NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship(0000-8311) -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Basic Aid Court-Ordered Voluntar -> Basic_Aid_Court_Ordered_Voluntar NOTE: Variable Name Change. Basic Aid Open Enrollment -> Basic_Aid_Open_Enrollment NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education( -> VAR24 NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR26 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR28 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR29 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change... New or Expanding Charter Advance Payments Categorical Block Grant(0000-8590) -> New_or_Expanding_Charter_Advanc1 NOTE: Variable Name Change. New Charter Advance Payments In- -> New_Charter_Advance_Payments_In_ NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and Prior Year Recom -> Adjustments_and_Prior_Year_Recom NOTE: Variable Name Change. Basic Aid Reduction -> Basic_Aid_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: The import data set has 2107 observations and 42 variables. NOTE: WORK.FUNDP112 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.34 seconds cpu time 0.80 seconds 295 296 PROC SORT Data = FundP112; 297 By District; 298 RUN; NOTE: There were 2107 observations read from the data set WORK.FUNDP112. NOTE: The data set WORK.FUNDP112 has 2107 observations and 42 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 299 300 DATA FundP112; 301 Set FundP112 (drop = District_Code); 302 RUN; NOTE: There were 2107 observations read from the data set WORK.FUNDP112. NOTE: The data set WORK.FUNDP112 has 2107 observations and 41 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 303 304 PROC IMPORT OUT= FundP212 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2012.xlsx" 305 DBMS=xlsx REPLACE; 306 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education Reven -> County_Office_of_Education_Reven NOTE: Variable Name Change. School District Revenue LimitN -> School_District_Revenue_Limit__N NOTE: Variable Name Change. Charter School General Purpose E -> Charter_School_General_Purpose_E NOTE: Variable Name Change. Charter School Categorical Block -> Charter_School_Categorical_Block NOTE: Variable Name Change. Charter School In-Lieu of Econom -> Charter_School_In_Lieu_of_Econom NOTE: Variable Name Change. Core Academic Program (Supplemen -> Core_Academic_Program__Supplemen NOTE: Variable Name Change. Remedial Program (Supplemental I -> Remedial_Program__Supplemental_I NOTE: Variable Name Change. Retained and Recommended for Ret -> Retained_and_Recommended_for_Ret NOTE: Variable Name Change. Low STAR Score and at Risk of Re -> Low_STAR_Score_and_at_Risk_of_Re NOTE: Variable Name Change. Apprenticeship(0000-8311) -> VAR17 NOTE: Variable Name Change. Community Day School Additional -> Community_Day_School_Additional NOTE: Variable Name Change... Community Day School Additional Funding for Mandatory Expelled Pupils(2430-8311) -> Community_Day_School_Additional1 NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR20 NOTE: Variable Name Change. Basic Aid Court-Ordered Voluntar -> Basic_Aid_Court_Ordered_Voluntar NOTE: Variable Name Change. Basic Aid Open Enrollment(0000 -> VAR22 NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Gifted and Talented Education( -> VAR24 NOTE: Variable Name Change. Regional Occupational Center/Pro -> Regional_Occupational_Center_Pro NOTE: Variable Name Change. Adult Education(0000-8590) -> VAR26 NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR28 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR29 NOTE: Variable Name Change. Special Education ROC/P Handicap -> Special_Education_ROC_P_Handicap NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change... New or Expanding Charter Advance Payments Categorical Block Grant(0000-8590) -> New_or_Expanding_Charter_Advanc1 NOTE: Variable Name Change. New Charter Advance Payments In- -> New_Charter_Advance_Payments_In_ NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and Prior Year Recom -> Adjustments_and_Prior_Year_Recom NOTE: Variable Name Change. Basic Aid Reduction -> Basic_Aid_Reduction NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of Net Revenue Limit or Ch -> Total_of_Net_Revenue_Limit_or_Ch NOTE: The import data set has 2117 observations and 43 variables. NOTE: WORK.FUNDP212 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.63 seconds cpu time 0.65 seconds 307 308 PROC SORT Data = FundP212; 309 By District; 310 RUN; NOTE: There were 2117 observations read from the data set WORK.FUNDP212. NOTE: The data set WORK.FUNDP212 has 2117 observations and 43 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 311 312 DATA FundP212; 313 Set FundP212 (drop = District_Code); 314 RUN; NOTE: There were 2117 observations read from the data set WORK.FUNDP212. NOTE: The data set WORK.FUNDP212 has 2117 observations and 42 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 315 316 DATA TotalFund12 (KEEP = District TotalFundP1 TotalFundP2); 317 MERGE FundP112 FundP212; 318 NOTE: There were 2107 observations read from the data set WORK.FUNDP112. NOTE: There were 2117 observations read from the data set WORK.FUNDP212. NOTE: The data set WORK.TOTALFUND12 has 2117 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 319 DATA TotalFund12; 320 Set TotalFund12; 321 TotalFund = TotalFundP1 + TotalFundP2; 322 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). 26 at 321:26 NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: The data set WORK.TOTALFUND12 has 2117 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 323 DATA TotalFund12 (DROP= TotalFundP1 TotalFundP2); 324 Set TotalFund12; 325 Year = 2012; 326 NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: The data set WORK.TOTALFUND12 has 2117 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.02 seconds 327 PROC SORT Data = TotalFund12; 328 By District; 329 RUN; NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: The data set WORK.TOTALFUND12 has 2117 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 330 331 PROC IMPORT OUT= FundP113 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2013.xlsx" 332 DBMS=xlsx REPLACE; 333 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. 2012-13 Adjusted County Office o -> _2012_13_Adjusted_County_Office NOTE: Variable Name Change. 2012-13 Adjusted School District -> _2012_13_Adjusted_School_Distric NOTE: Variable Name Change. 2012-13 Adjusted Charter School -> _2012_13_Adjusted_Charter_School NOTE: Variable Name Change. Basic Aid "Choice"(0000-8011) -> VAR11 NOTE: Variable Name Change. Basic Aid Court-Ordered Voluntar -> Basic_Aid_Court_Ordered_Voluntar NOTE: Variable Name Change. Basic Aid Open Enrollment(0000 -> VAR13 NOTE: Variable Name Change. Basic Aid Supplement Charter Sch -> Basic_Aid_Supplement_Charter_Sch NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special EducationAB 602(6500 -> VAR16 NOTE: Variable Name Change. Special Education Infants 0-2( -> VAR17 NOTE: Variable Name Change. Total County Office Funds Transf -> Total_County_Office_Funds_Transf NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change... New or Expanding Charter Advance Payments Categorical Block Grant(0000-8011) -> New_or_Expanding_Charter_Advanc1 NOTE: Variable Name Change. New Charter Advance Payments In- -> New_Charter_Advance_Payments_In_ NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and Prior Year Recom -> Adjustments_and_Prior_Year_Recom NOTE: Variable Name Change. 2012-13 Adjusted Local Control F -> _2012_13_Adjusted_Local_Control NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of Net Revenue Limit or Ch -> Total_of_Net_Revenue_Limit_or_Ch NOTE: The import data set has 2187 observations and 30 variables. NOTE: WORK.FUNDP113 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.35 seconds cpu time 0.53 seconds 334 335 PROC SORT Data = FundP113; 336 By District; 337 RUN; NOTE: There were 2187 observations read from the data set WORK.FUNDP113. NOTE: The data set WORK.FUNDP113 has 2187 observations and 30 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 338 339 DATA FundP113; 340 Set FundP113 (drop = District_Code); 341 RUN; NOTE: There were 2187 observations read from the data set WORK.FUNDP113. NOTE: The data set WORK.FUNDP113 has 2187 observations and 29 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.01 seconds 342 343 PROC IMPORT OUT= FundP213 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2013.xlsx" 344 DBMS=xlsx REPLACE; 345 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education LCFF -> County_Office_of_Education_LCFF NOTE: Variable Name Change. School District LCFF State Aid -> School_District_LCFF_State_Aid NOTE: Variable Name Change. Charter School LCFF State Aid -> Charter_School_LCFF_State_Aid NOTE: Variable Name Change. School District Basic Aid "Choic -> School_District_Basic_Aid__Choic NOTE: Variable Name Change. School District Basic Aid Court- -> School_District_Basic_Aid_Court_ NOTE: Variable Name Change. School District Basic Aid Open E -> School_District_Basic_Aid_Open_E NOTE: Variable Name Change. School District Basic Aid Supple -> School_District_Basic_Aid_Supple NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special Education AB 602 (65 -> VAR16 NOTE: Variable Name Change. Special Education Infants 0-2 -> VAR17 NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and PY Recomputation -> Adjustments_and_PY_Recomputation NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of LCFF State Aid and EPA -> Total_of_LCFF_State_Aid_and_EPA NOTE: The import data set has 2187 observations and 26 variables. NOTE: WORK.FUNDP213 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.40 seconds cpu time 0.41 seconds 346 347 PROC SORT Data = FundP213; 348 By District; 349 RUN; NOTE: There were 2187 observations read from the data set WORK.FUNDP213. NOTE: The data set WORK.FUNDP213 has 2187 observations and 26 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 350 351 DATA FundP213; 352 Set FundP213 (drop = District_Code); 353 RUN; NOTE: There were 2187 observations read from the data set WORK.FUNDP213. NOTE: The data set WORK.FUNDP213 has 2187 observations and 25 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 354 355 DATA TotalFund13 (KEEP = District TotalFundP1 TotalFundP2); 356 MERGE FundP113 FundP213; 357 NOTE: There were 2187 observations read from the data set WORK.FUNDP113. NOTE: There were 2187 observations read from the data set WORK.FUNDP213. NOTE: The data set WORK.TOTALFUND13 has 2187 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 358 DATA TotalFund13; 359 Set TotalFund13; 360 TotalFund = TotalFundP1 + TotalFundP2; 361 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). 6 at 360:26 NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: The data set WORK.TOTALFUND13 has 2187 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 362 DATA TotalFund13 (DROP= TotalFundP1 TotalFundP2); 363 Set TotalFund13; 364 Year = 2013; 365 NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: The data set WORK.TOTALFUND13 has 2187 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 366 PROC SORT Data = TotalFund13; 367 By District; 368 RUN; NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: The data set WORK.TOTALFUND13 has 2187 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 369 370 PROC IMPORT OUT= FundP114 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2014.xlsx" 371 DBMS=xlsx REPLACE; 372 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education LCFF -> County_Office_of_Education_LCFF NOTE: Variable Name Change. School District LCFF State Aid -> School_District_LCFF_State_Aid NOTE: Variable Name Change. Charter School LCFF State Aid -> Charter_School_LCFF_State_Aid NOTE: Variable Name Change. School District Basic Aid "Choic -> School_District_Basic_Aid__Choic NOTE: Variable Name Change. School District Basic Aid Court- -> School_District_Basic_Aid_Court_ NOTE: Variable Name Change. School District Basic Aid Open E -> School_District_Basic_Aid_Open_E NOTE: Variable Name Change. School District Basic Aid Supple -> School_District_Basic_Aid_Supple NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special Education AB 602 (65 -> VAR16 NOTE: Variable Name Change. Special Education Infants 0-2 -> VAR17 NOTE: Variable Name Change. Transfer of Funds for County Ser -> Transfer_of_Funds_for_County_Ser NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and PY Recomputation -> Adjustments_and_PY_Recomputation NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of LCFF State Aid and EPA -> Total_of_LCFF_State_Aid_and_EPA NOTE: The import data set has 2218 observations and 27 variables. NOTE: WORK.FUNDP114 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 1.04 seconds cpu time 0.51 seconds 373 374 PROC SORT Data = FundP114; 375 By District; 376 RUN; NOTE: There were 2218 observations read from the data set WORK.FUNDP114. NOTE: The data set WORK.FUNDP114 has 2218 observations and 27 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 377 378 DATA FundP114; 379 Set FundP114 (drop = District_Code); 380 RUN; NOTE: There were 2218 observations read from the data set WORK.FUNDP114. NOTE: The data set WORK.FUNDP114 has 2218 observations and 26 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 381 382 PROC IMPORT OUT= FundP214 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2014.xlsx" 383 DBMS=xlsx REPLACE; 384 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education LCFF -> County_Office_of_Education_LCFF NOTE: Variable Name Change. School District LCFF State Aid -> School_District_LCFF_State_Aid NOTE: Variable Name Change. Charter School LCFF State Aid -> Charter_School_LCFF_State_Aid NOTE: Variable Name Change. School District Basic Aid "Choic -> School_District_Basic_Aid__Choic NOTE: Variable Name Change. School District Basic Aid Court- -> School_District_Basic_Aid_Court_ NOTE: Variable Name Change. School District Basic Aid Open E -> School_District_Basic_Aid_Open_E NOTE: Variable Name Change. School District Basic Aid Supple -> School_District_Basic_Aid_Supple NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special Education AB 602 (65 -> VAR16 NOTE: Variable Name Change. Special Education Infants 0-2 -> VAR17 NOTE: Variable Name Change. Transfer of Funds for County Ser -> Transfer_of_Funds_for_County_Ser NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and PY Recomputation -> Adjustments_and_PY_Recomputation NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of LCFF State Aid and EPA -> Total_of_LCFF_State_Aid_and_EPA NOTE: The import data set has 2220 observations and 27 variables. NOTE: WORK.FUNDP214 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.69 seconds cpu time 0.60 seconds 385 386 PROC SORT Data = FundP214; 387 By District; 388 RUN; NOTE: There were 2220 observations read from the data set WORK.FUNDP214. NOTE: The data set WORK.FUNDP214 has 2220 observations and 27 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 389 390 DATA FundP214; 391 Set FundP214 (drop = District_Code); 392 RUN; NOTE: There were 2220 observations read from the data set WORK.FUNDP214. NOTE: The data set WORK.FUNDP214 has 2220 observations and 26 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 393 394 DATA TotalFund14 (KEEP = District TotalFundP1 TotalFundP2); 395 MERGE FundP114 FundP214; 396 NOTE: There were 2218 observations read from the data set WORK.FUNDP114. NOTE: There were 2220 observations read from the data set WORK.FUNDP214. NOTE: The data set WORK.TOTALFUND14 has 2220 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 397 DATA TotalFund14; 398 Set TotalFund14; 399 TotalFund = TotalFundP1 + TotalFundP2; 400 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). 10 at 399:26 NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: The data set WORK.TOTALFUND14 has 2220 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 401 DATA TotalFund14 (DROP= TotalFundP1 TotalFundP2); 402 Set TotalFund14; 403 Year = 2014; 404 NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: The data set WORK.TOTALFUND14 has 2220 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 405 PROC SORT Data = TotalFund14; 406 By District; 407 RUN; NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: The data set WORK.TOTALFUND14 has 2220 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 408 409 PROC IMPORT OUT= FundP115 DATAFILE= "/folders/myfolders/Data/Apportionment/P1 2015.xlsx" 410 DBMS=xlsx REPLACE; 411 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education LCFF -> County_Office_of_Education_LCFF NOTE: Variable Name Change. School District LCFF State Aid -> School_District_LCFF_State_Aid NOTE: Variable Name Change. Charter School LCFF State Aid -> Charter_School_LCFF_State_Aid NOTE: Variable Name Change. School District Basic Aid "Choic -> School_District_Basic_Aid__Choic NOTE: Variable Name Change. School District Basic Aid Court- -> School_District_Basic_Aid_Court_ NOTE: Variable Name Change. School District Basic Aid Open E -> School_District_Basic_Aid_Open_E NOTE: Variable Name Change. School District Basic Aid Supple -> School_District_Basic_Aid_Supple NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special Education AB 602 (65 -> VAR16 NOTE: Variable Name Change. Special Education Infants 0-2 -> VAR17 NOTE: Variable Name Change. Transfer of Funds for County Ser -> Transfer_of_Funds_for_County_Ser NOTE: Variable Name Change. County Office of Education Other -> County_Office_of_Education_Other NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and PY Recomputation -> Adjustments_and_PY_Recomputation NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of LCFF State Aid and EPA -> Total_of_LCFF_State_Aid_and_EPA NOTE: The import data set has 2233 observations and 28 variables. NOTE: WORK.FUNDP115 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.93 seconds cpu time 0.53 seconds 412 413 PROC SORT Data = FundP115; 414 By District; 415 RUN; NOTE: There were 2233 observations read from the data set WORK.FUNDP115. NOTE: The data set WORK.FUNDP115 has 2233 observations and 28 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 416 417 DATA FundP115; 418 Set FundP115 (drop = District_Code); 419 RUN; NOTE: There were 2233 observations read from the data set WORK.FUNDP115. NOTE: The data set WORK.FUNDP115 has 2233 observations and 27 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 420 421 PROC IMPORT OUT= FundP215 DATAFILE= "/folders/myfolders/Data/Apportionment/P2 2015.xlsx" 422 DBMS=xlsx REPLACE; 423 GETNAMES=yes;RUN; NOTE: Variable Name Change. County Code -> County_Code NOTE: Variable Name Change. District Code -> District_Code NOTE: Variable Name Change. School Code -> School_Code NOTE: Variable Name Change. Charter Number -> Charter_Number NOTE: Variable Name Change. Charter Fund Type -> Charter_Fund_Type NOTE: Variable Name Change. District Type -> District_Type NOTE: Variable Name Change. County Office of Education LCFF -> County_Office_of_Education_LCFF NOTE: Variable Name Change. School District LCFF State Aid -> School_District_LCFF_State_Aid NOTE: Variable Name Change. Charter School LCFF State Aid -> Charter_School_LCFF_State_Aid NOTE: Variable Name Change. School District Basic Aid "Choic -> School_District_Basic_Aid__Choic NOTE: Variable Name Change. School District Basic Aid Court- -> School_District_Basic_Aid_Court_ NOTE: Variable Name Change. School District Basic Aid Open E -> School_District_Basic_Aid_Open_E NOTE: Variable Name Change. School District Basic Aid Supple -> School_District_Basic_Aid_Supple NOTE: Variable Name Change. Adults in Correctional Facilitie -> Adults_in_Correctional_Facilitie NOTE: Variable Name Change. Special Education AB 602 (65 -> VAR16 NOTE: Variable Name Change. Special Education Infants 0-2 -> VAR17 NOTE: Variable Name Change. Transfer of Funds for County Ser -> Transfer_of_Funds_for_County_Ser NOTE: Variable Name Change. County Office of Education Other -> County_Office_of_Education_Other NOTE: Variable Name Change. New or Expanding Charter Advance -> New_or_Expanding_Charter_Advance NOTE: Variable Name Change. School District Advance Payments -> School_District_Advance_Payments NOTE: Variable Name Change. Amount Charter Overpaid -> Amount_Charter_Overpaid NOTE: Variable Name Change. PY Amount Charter Overpaid -> PY_Amount_Charter_Overpaid NOTE: Variable Name Change. Adjustments and PY Recomputation -> Adjustments_and_PY_Recomputation NOTE: Variable Name Change. Payment Type -> Payment_Type NOTE: Variable Name Change. Education Protection Account (EP -> Education_Protection_Account__EP NOTE: Variable Name Change. Total of LCFF State Aid and EPA -> Total_of_LCFF_State_Aid_and_EPA NOTE: The import data set has 2250 observations and 28 variables. NOTE: WORK.FUNDP215 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.83 seconds cpu time 0.52 seconds 424 425 PROC SORT Data = FundP215; 426 By District; 427 RUN; NOTE: There were 2250 observations read from the data set WORK.FUNDP215. NOTE: The data set WORK.FUNDP215 has 2250 observations and 28 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 428 429 DATA FundP215; 430 Set FundP215 (drop = District_Code); 431 RUN; NOTE: There were 2250 observations read from the data set WORK.FUNDP215. NOTE: The data set WORK.FUNDP215 has 2250 observations and 27 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 432 433 DATA TotalFund15 (KEEP = District TotalFundP1 TotalFundP2); 434 MERGE FundP115 FundP215; 435 NOTE: There were 2233 observations read from the data set WORK.FUNDP115. NOTE: There were 2250 observations read from the data set WORK.FUNDP215. NOTE: The data set WORK.TOTALFUND15 has 2250 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 436 DATA TotalFund15; 437 Set TotalFund15; 438 TotalFund = TotalFundP1 + TotalFundP2; 439 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). 25 at 438:26 NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUND15 has 2250 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 440 DATA TotalFund15 (DROP= TotalFundP1 TotalFundP2); 441 Set TotalFund15; 442 Year = 2015; 443 NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUND15 has 2250 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 444 PROC SORT Data = TotalFund15; 445 By District; 446 RUN; NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUND15 has 2250 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.00 seconds 447 448 /*Total Funding UCD*/ 449 450 DATA TotalFundingUCD; 451 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 451 ! TotalFund15; 452 By District Year; 453 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCD has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.08 seconds 454 DATA TotalFundingUCD; 455 Set TotalFundingUCD; 456 University = "UCD"; 457 458 /*Total Funding UCB*/ 459 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCD. NOTE: The data set WORK.TOTALFUNDINGUCD has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.04 seconds 460 DATA TotalFundingUCB; 461 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 461 ! TotalFund15; 462 By District Year; 463 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCB has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.06 seconds 464 DATA TotalFundingUCB; 465 Set TotalFundingUCB; 466 University = "UCB"; 467 468 /*Total Funding UCI*/ 469 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCB. NOTE: The data set WORK.TOTALFUNDINGUCB has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 470 DATA TotalFundingUCI; 471 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 471 ! TotalFund15; 472 By District Year; 473 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCI has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.06 seconds 474 DATA TotalFundingUCI; 475 Set TotalFundingUCI; 476 University = "UCI"; 477 478 /*Total Funding UCLA*/ 479 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCI. NOTE: The data set WORK.TOTALFUNDINGUCI has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 480 DATA TotalFundingUCLA; 481 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 481 ! TotalFund15; 482 By District Year; 483 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCLA has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.05 seconds 484 DATA TotalFundingUCLA; 485 Set TotalFundingUCLA; 486 University = "UCLA"; 487 488 /*Total Funding UCR*/ 489 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCLA. NOTE: The data set WORK.TOTALFUNDINGUCLA has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.03 seconds 490 DATA TotalFundingUCR; 491 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 491 ! TotalFund15; 492 By District Year; 493 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCR has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.04 seconds cpu time 0.05 seconds 494 DATA TotalFundingUCR; 495 Set TotalFundingUCR; 496 University = "UCR"; 497 498 /*Total Funding UCSD*/ 499 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCR. NOTE: The data set WORK.TOTALFUNDINGUCR has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 500 DATA TotalFundingUCSD; 501 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 501 ! TotalFund15; 502 By District Year; 503 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCSD has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 504 DATA TotalFundingUCSD; 505 Set TotalFundingUCSD; 506 University = "UCSD"; 507 508 /*Total Funding UCSB*/ 509 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCSD. NOTE: The data set WORK.TOTALFUNDINGUCSD has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 510 DATA TotalFundingUCSB; 511 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 511 ! TotalFund15; 512 By District Year; 513 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCSB has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.05 seconds 514 DATA TotalFundingUCSB; 515 Set TotalFundingUCSB; 516 University = "UCSB"; 517 518 /*Total Funding UCSC*/ 519 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCSB. NOTE: The data set WORK.TOTALFUNDINGUCSB has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 520 DATA TotalFundingUCSC; 521 MERGE TotalFund06 TotalFund07 TotalFund08 TotalFund09 TotalFund10 TotalFund11 TotalFund12 TotalFund13 TotalFund14 521 ! TotalFund15; 522 By District Year; 523 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. NOTE: There were 1659 observations read from the data set WORK.TOTALFUND06. NOTE: There were 1739 observations read from the data set WORK.TOTALFUND07. NOTE: There were 1815 observations read from the data set WORK.TOTALFUND08. NOTE: There were 1862 observations read from the data set WORK.TOTALFUND09. NOTE: There were 1950 observations read from the data set WORK.TOTALFUND10. NOTE: There were 2041 observations read from the data set WORK.TOTALFUND11. NOTE: There were 2117 observations read from the data set WORK.TOTALFUND12. NOTE: There were 2187 observations read from the data set WORK.TOTALFUND13. NOTE: There were 2220 observations read from the data set WORK.TOTALFUND14. NOTE: There were 2250 observations read from the data set WORK.TOTALFUND15. NOTE: The data set WORK.TOTALFUNDINGUCSC has 19840 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.05 seconds cpu time 0.05 seconds 524 DATA TotalFundingUCSC; 525 Set TotalFundingUCSC; 526 University = "UCSC"; 527 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCSC. NOTE: The data set WORK.TOTALFUNDINGUCSC has 19840 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.03 seconds cpu time 0.03 seconds 528 Data TotalFunding; 529 Length District $100; 530 Merge TotalFundingUCLA TotalFundingUCB TotalFundingUCI TotalFundingUCR TotalFundingUCD TotalFundingUCSD TotalFundingUCSB 530 ! TotalFundingUCSC; 531 BY District Year University; 532 NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCLA. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCB. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCI. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCR. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCD. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCSD. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCSB. NOTE: There were 19840 observations read from the data set WORK.TOTALFUNDINGUCSC. NOTE: The data set WORK.TOTALFUNDING has 158720 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.25 seconds cpu time 0.25 seconds 533 PROC Sort Data = TotalFunding; 534 By District Year University; 535 536 /*LCFF Funding*/ 537 NOTE: There were 158720 observations read from the data set WORK.TOTALFUNDING. NOTE: The data set WORK.TOTALFUNDING has 158720 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.15 seconds cpu time 0.14 seconds 538 PROC IMPORT OUT= LCFF13 DATAFILE= "/folders/myfolders/Data/Transition/2013-14 Transition.xlsx" 539 DBMS=xlsx REPLACE; 540 GETNAMES=yes;RUN; NOTE: Variable Name Change. A-1 -> A_1 NOTE: Variable Name Change. B-1 -> B_1 NOTE: Variable Name Change. B-2 -> B_2 NOTE: Variable Name Change. B-3 -> B_3 NOTE: Variable Name Change. B-4 -> B_4 NOTE: Variable Name Change. B-5 -> B_5 NOTE: Variable Name Change. B-6 -> B_6 NOTE: Variable Name Change. B-7 -> B_7 NOTE: Variable Name Change. B-8 -> B_8 NOTE: Variable Name Change. B-9 -> B_9 NOTE: Variable Name Change. B-10 -> B_10 NOTE: Variable Name Change. B-11 -> B_11 NOTE: Variable Name Change. B-12 -> B_12 NOTE: Variable Name Change. B-13 -> B_13 NOTE: Variable Name Change. C-1 -> C_1 NOTE: Variable Name Change. C-2 -> C_2 NOTE: Variable Name Change. C-3 -> C_3 NOTE: Variable Name Change. D-1 -> D_1 NOTE: Variable Name Change. E-1 -> E_1 NOTE: Variable Name Change. F-1 -> F_1 NOTE: Variable Name Change. F-2 -> F_2 NOTE: Variable Name Change. F-3 -> F_3 NOTE: Variable Name Change. F-4 -> F_4 NOTE: Variable Name Change. F-5 -> F_5 NOTE: Variable Name Change. F-6 -> F_6 NOTE: Variable Name Change. G-1 -> G_1 NOTE: Variable Name Change. G-2 -> G_2 NOTE: Variable Name Change. G-3 -> G_3 NOTE: Variable Name Change. G-4 -> G_4 NOTE: Variable Name Change. G-5 -> G_5 NOTE: Variable Name Change. G-6 -> G_6 NOTE: Variable Name Change. G-7 -> G_7 NOTE: Variable Name Change. G-8 -> G_8 NOTE: Variable Name Change. G-9 -> G_9 NOTE: Variable Name Change. G-10 -> G_10 NOTE: The import data set has 955 observations and 44 variables. NOTE: WORK.LCFF13 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.76 seconds cpu time 0.35 seconds 541 542 DATA LCFF13 (KEEP = District LCFF Year); 543 SET LCFF13; 544 Year = 2013; 545 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: The data set WORK.LCFF13 has 955 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.02 seconds cpu time 0.01 seconds 546 PROC SORT Data = LCFF13; 547 By District; 548 RUN; NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: The data set WORK.LCFF13 has 955 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 3.82 seconds cpu time 0.01 seconds 549 550 PROC IMPORT OUT= LCFF14 DATAFILE= "/folders/myfolders/Data/Transition/2014-15 Transition.xlsx" 551 DBMS=xlsx REPLACE; 552 GETNAMES=yes;RUN; NOTE: Variable Name Change. A-1 -> A_1 NOTE: Variable Name Change. B-1 -> B_1 NOTE: Variable Name Change. B-2 -> B_2 NOTE: Variable Name Change. B-3 -> B_3 NOTE: Variable Name Change. B-4 -> B_4 NOTE: Variable Name Change. B-5 -> B_5 NOTE: Variable Name Change. B-6 -> B_6 NOTE: Variable Name Change. B-7 -> B_7 NOTE: Variable Name Change. B-8 -> B_8 NOTE: Variable Name Change. B-9 -> B_9 NOTE: Variable Name Change. B-10 -> B_10 NOTE: Variable Name Change. B-11 -> B_11 NOTE: Variable Name Change. B-12 -> B_12 NOTE: Variable Name Change. B-13 -> B_13 NOTE: Variable Name Change. C-1 -> C_1 NOTE: Variable Name Change. C-2 -> C_2 NOTE: Variable Name Change. C-3 -> C_3 NOTE: Variable Name Change. D-1 -> D_1 NOTE: Variable Name Change. E-1 -> E_1 NOTE: Variable Name Change. F-1 -> F_1 NOTE: Variable Name Change. F-2 -> F_2 NOTE: Variable Name Change. F-3 -> F_3 NOTE: Variable Name Change. F-4 -> F_4 NOTE: Variable Name Change. F-5 -> F_5 NOTE: Variable Name Change. F-6 -> F_6 NOTE: Variable Name Change. G-1 -> G_1 NOTE: Variable Name Change. G-2 -> G_2 NOTE: Variable Name Change. G-3 -> G_3 NOTE: Variable Name Change. G-4 -> G_4 NOTE: Variable Name Change. G-5 -> G_5 NOTE: Variable Name Change. G-6 -> G_6 NOTE: Variable Name Change. G-7 -> G_7 NOTE: Variable Name Change. G-8 -> G_8 NOTE: Variable Name Change. G-9 -> G_9 NOTE: Variable Name Change. G-10 -> G_10 NOTE: Variable Name Change. H-1 -> H_1 NOTE: The import data set has 953 observations and 44 variables. NOTE: WORK.LCFF14 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.76 seconds cpu time 0.36 seconds 553 554 DATA LCFF14 (KEEP = District LCFF Year); 555 SET LCFF14; 556 Year = 2014; 557 NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: The data set WORK.LCFF14 has 953 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 558 PROC SORT Data = LCFF14; 559 By District; 560 RUN; NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: The data set WORK.LCFF14 has 953 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 561 562 PROC IMPORT OUT= LCFF15 DATAFILE= "/folders/myfolders/Data/Transition/2015-16 Transition.xlsx" 563 DBMS=xlsx REPLACE; 564 GETNAMES=yes;RUN; NOTE: Variable Name Change. A-1 -> A_1 NOTE: Variable Name Change. B-1 -> B_1 NOTE: Variable Name Change. B-2 -> B_2 NOTE: Variable Name Change. B-3 -> B_3 NOTE: Variable Name Change. B-4 -> B_4 NOTE: Variable Name Change. B-5 -> B_5 NOTE: Variable Name Change. B-6 -> B_6 NOTE: Variable Name Change. B-7 -> B_7 NOTE: Variable Name Change. B-8 -> B_8 NOTE: Variable Name Change. B-9 -> B_9 NOTE: Variable Name Change. B-10 -> B_10 NOTE: Variable Name Change. B-11 -> B_11 NOTE: Variable Name Change. B-12 -> B_12 NOTE: Variable Name Change. B-13 -> B_13 NOTE: Variable Name Change. C-1 -> C_1 NOTE: Variable Name Change. C-2 -> C_2 NOTE: Variable Name Change. C-3 -> C_3 NOTE: Variable Name Change. D-1 -> D_1 NOTE: Variable Name Change. E-1 -> E_1 NOTE: Variable Name Change. F-1 -> F_1 NOTE: Variable Name Change. F-2 -> F_2 NOTE: Variable Name Change. F-3 -> F_3 NOTE: Variable Name Change. F-4 -> F_4 NOTE: Variable Name Change. F-5 -> F_5 NOTE: Variable Name Change. F-6 -> F_6 NOTE: Variable Name Change. G-1 -> G_1 NOTE: Variable Name Change. G-2 -> G_2 NOTE: Variable Name Change. G-3 -> G_3 NOTE: Variable Name Change. G-4 -> G_4 NOTE: Variable Name Change. G-5 -> G_5 NOTE: Variable Name Change. G-6 -> G_6 NOTE: Variable Name Change. G-7 -> G_7 NOTE: Variable Name Change. G-8 -> G_8 NOTE: Variable Name Change. G-9 -> G_9 NOTE: Variable Name Change. G-10 -> G_10 NOTE: Variable Name Change. H-1 -> H_1 NOTE: The import data set has 952 observations and 44 variables. NOTE: WORK.LCFF15 data set was successfully created. NOTE: PROCEDURE IMPORT used (Total process time): real time 0.74 seconds cpu time 0.35 seconds 565 566 DATA LCFF15 (KEEP = District LCFF Year); 567 SET LCFF15; 568 Year = 2015; 569 NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFF15 has 952 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 570 PROC SORT Data = LCFF15; 571 By District; 572 RUN; NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFF15 has 952 observations and 3 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 573 574 /*LCFF UCLA*/ 575 576 Data LCFFUCLA; 577 Merge LCFF13 LCFF14 LCFF15; 578 BY District Year; 579 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCLA has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 580 Data LCFFUCLA; 581 Set LCFFUCLA; 582 University = "UCLA"; 583 584 /*LCFF UCB*/ 585 NOTE: There were 2860 observations read from the data set WORK.LCFFUCLA. NOTE: The data set WORK.LCFFUCLA has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 586 Data LCFFUCB; 587 Merge LCFF13 LCFF14 LCFF15; 588 BY District Year; 589 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCB has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 590 Data LCFFUCB; 591 Set LCFFUCB; 592 University = "UCB"; 593 594 /*LCFF UCD*/ 595 NOTE: There were 2860 observations read from the data set WORK.LCFFUCB. NOTE: The data set WORK.LCFFUCB has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 596 Data LCFFUCD; 597 Merge LCFF13 LCFF14 LCFF15; 598 BY District Year; 599 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCD has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 600 Data LCFFUCD; 601 Set LCFFUCD; 602 University = "UCD"; 603 604 /*LCFF UCI*/ 605 NOTE: There were 2860 observations read from the data set WORK.LCFFUCD. NOTE: The data set WORK.LCFFUCD has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 606 Data LCFFUCI; 607 Merge LCFF13 LCFF14 LCFF15; 608 BY District Year; 609 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCI has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 610 Data LCFFUCI; 611 Set LCFFUCI; 612 University = "UCI"; 613 614 /*LCFF UCR*/ 615 NOTE: There were 2860 observations read from the data set WORK.LCFFUCI. NOTE: The data set WORK.LCFFUCI has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 616 Data LCFFUCR; 617 Merge LCFF13 LCFF14 LCFF15; 618 BY District Year; 619 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCR has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 620 Data LCFFUCR; 621 Set LCFFUCR; 622 University = "UCR"; 623 624 /*LCFF UCSD*/ 625 NOTE: There were 2860 observations read from the data set WORK.LCFFUCR. NOTE: The data set WORK.LCFFUCR has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.01 seconds 626 Data LCFFUCSD; 627 Merge LCFF13 LCFF14 LCFF15; 628 BY District Year; 629 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCSD has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 630 Data LCFFUCSD; 631 Set LCFFUCSD; 632 University = "UCSD"; 633 634 /*LCFF UCSB*/ 635 NOTE: There were 2860 observations read from the data set WORK.LCFFUCSD. NOTE: The data set WORK.LCFFUCSD has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.00 seconds cpu time 0.00 seconds 636 Data LCFFUCSB; 637 Merge LCFF13 LCFF14 LCFF15; 638 BY District Year; 639 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCSB has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 640 Data LCFFUCSB; 641 Set LCFFUCSB; 642 University = "UCSB"; 643 644 /*LCFF UCSC*/ 645 NOTE: There were 2860 observations read from the data set WORK.LCFFUCSB. NOTE: The data set WORK.LCFFUCSB has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 646 Data LCFFUCSC; 647 Merge LCFF13 LCFF14 LCFF15; 648 BY District Year; 649 NOTE: There were 955 observations read from the data set WORK.LCFF13. NOTE: There were 953 observations read from the data set WORK.LCFF14. NOTE: There were 952 observations read from the data set WORK.LCFF15. NOTE: The data set WORK.LCFFUCSC has 2860 observations and 3 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.02 seconds 650 Data LCFFUCSC; 651 Set LCFFUCSC; 652 University = "UCSC"; 653 NOTE: There were 2860 observations read from the data set WORK.LCFFUCSC. NOTE: The data set WORK.LCFFUCSC has 2860 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.01 seconds 654 Data LCFF; 655 Merge LCFFUCLA LCFFUCB LCFFUCD LCFFUCI LCFFUCR LCFFUCSD LCFFUCSB LCFFUCSC; 656 BY District Year University; 657 NOTE: There were 2860 observations read from the data set WORK.LCFFUCLA. NOTE: There were 2860 observations read from the data set WORK.LCFFUCB. NOTE: There were 2860 observations read from the data set WORK.LCFFUCD. NOTE: There were 2860 observations read from the data set WORK.LCFFUCI. NOTE: There were 2860 observations read from the data set WORK.LCFFUCR. NOTE: There were 2860 observations read from the data set WORK.LCFFUCSD. NOTE: There were 2860 observations read from the data set WORK.LCFFUCSB. NOTE: There were 2860 observations read from the data set WORK.LCFFUCSC. NOTE: The data set WORK.LCFF has 22880 observations and 4 variables. NOTE: DATA statement used (Total process time): real time 0.07 seconds cpu time 0.07 seconds 658 PROC SORT DATA = LCFF; 659 By District Year University; 660 661 /*Funding*/ NOTE: There were 22880 observations read from the data set WORK.LCFF. NOTE: The data set WORK.LCFF has 22880 observations and 4 variables. NOTE: PROCEDURE SORT used (Total process time): real time 0.02 seconds cpu time 0.02 seconds 662 Data TotalFunding; 663 Set TotalFunding; 664 If Year < 2013 THEN LCFF = 0; 665 NOTE: There were 158720 observations read from the data set WORK.TOTALFUNDING. NOTE: The data set WORK.TOTALFUNDING has 158720 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.06 seconds cpu time 0.07 seconds 666 PROC SORT DATA = TotalFunding; 667 By District Year University; 668 NOTE: There were 158720 observations read from the data set WORK.TOTALFUNDING. NOTE: The data set WORK.TOTALFUNDING has 158720 observations and 5 variables. NOTE: PROCEDURE SORT used (Total process time): real time 4.34 seconds cpu time 0.17 seconds 669 Data Funding; 670 Merge LCFF TotalFunding; 671 By District Year University; 672 WARNING: Multiple lengths were specified for the BY variable District by input data sets. This might cause unexpected results. ERROR: BY variables are not properly sorted on data set WORK.TOTALFUNDING. District=Academy of Arts and Sciences Los Angele LCFF=. Year=2015 University=UCSD TotalFund=2178818 FIRST.District=0 LAST.District=0 FIRST.Year=0 LAST.Year=0 FIRST.University=1 LAST.University=1 _ERROR_=1 _N_=1704 NOTE: MERGE statement has more than one data set with repeats of BY values. NOTE: The SAS System stopped processing this step because of errors. NOTE: There were 169 observations read from the data set WORK.LCFF. NOTE: There were 1705 observations read from the data set WORK.TOTALFUNDING. WARNING: The data set WORK.FUNDING may be incomplete. When this step was stopped there were 1703 observations and 5 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 673 Data Funding; 674 Set Funding; 675 Funding = TotalFund - LCFF; 676 677 OPTIONS NONOTES NOSTIMER NOSOURCE NOSYNTAXCHECK; 689 ... View more

Hi Reeza!   Thank you for your help! By using the code you suggested, I was able to limit the output for the first regression to just the parameter estimate; however, when I attempt to run the code including the second regression, the output still prints the graphs. When I put the code in front of both regressions 1 and 2, the output still prints graphs for regression 2. Is there a way to limit output to the parameter estimate for all of my regressions? I have about 80-90 regressions, so I can't print the full report for all of thse. ... View more

Thank you, Reza!   So would my code look like this?    ODS SELECT ParameterEstimates;   proc reg data= Database; TITLE 'Table 1.1 UC Berkeley Total Admission Rates'; model UCBTotalAR = AvgSAT LCFFPerCapita FundPerCapita Year; proc reg data= Database; TITLE 'Table 1.2 UC Berkeley Total Senior Admission Rates'; model UCBSeniorAR = AvgSAT LCFFPerCapita FundPerCapita Year; ... View more