topic Re: Merging Error in SAS Studio

Merging Error

amychau — Mon, 05 Dec 2016 04:37:20 GMT

I'm having a merging error with my data. It tells me that the By variables aren't properly sorted; however, I sort the BY variables correctly right before the merging. Essentially, I'm attempting to merge TotalFunding with LCFF in order to create Funding. Below is my code:

Data TotalFunding;
Merge TotalFundingUCLA TotalFundingUCB TotalFundingUCI TotalFundingUCR TotalFundingUCD TotalFundingUCSD TotalFundingUCSB TotalFundingUCSC;
BY District Year University;

PROC Sort Data = TotalFunding;
By District Year University;

Data LCFF;
Merge LCFFUCLA LCFFUCB LCFFUCD LCFFUCI LCFFUCR LCFFUCSD LCFFUCSB LCFFUCSC;
BY District Year University;

PROC SORT DATA = LCFF;
By District Year University;

/*Funding*/
Data TotalFunding;
Set TotalFunding;
If Year < 2013 THEN LCFF = 0;

PROC SORT DATA = TotalFunding;
By District Year University;

Data Funding;

Merge LCFF TotalFunding;

By District Year University;

Here is the error message:

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.

Do you think it might be due to the fact that multiple lengths were specified for the variable District?

Re: Merging Error

Reeza — Mon, 05 Dec 2016 05:37:56 GMT

Can you post the full log that includes the submitted code.

If the code code isn't relevant please exclude it.

Re: Merging Error

Shmuel — Mon, 05 Dec 2016 06:12:36 GMT

To overcome the "multiple lengths" warning assign a maximum length to the district, before merging the inputs:

Data TotalFunding;
length district $100;  /* assuming 100 is long enough */
Merge TotalFundingUCLA TotalFundingUCB TotalFundingUCI TotalFundingUCR 
      TotalFundingUCD TotalFundingUCSD TotalFundingUCSB TotalFundingUCSC;
BY District Year University;
run;

I hope that will eliminate the other message:

NOTE: MERGE statement has more than one data set with repeats of BY values.

if the message still repeats change the merge into proc sql - join - code.

If you need more help add the begining:

options source;

and post the log within the code inside.

Re: Merging Error

amychau — Mon, 05 Dec 2016 07:05:01 GMT

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

Re: Merging Error

Reeza — Mon, 05 Dec 2016 07:08:11 GMT

Are you doing a many to many merge?

Re: Merging Error

Astounding — Mon, 05 Dec 2016 07:08:15 GMT

On a side note, adding a BY statement in a DATA step will not sort the data. But it will give you an error message if the data set is out of order.

Back to your question ...

Eliminating the warning about "Multiple lengths were found ..." can usually solve this problem. Here is an example.

Data set 1 contains DISTRICT and YEAR:

Washington 1973

Data set 2 contains DISTRICT and YEAR:

Washington 1973

Washington 1974

Washington University 1973

Now when you MERGE DATASET1 DATASET2, DISTRICT receives a shorter length based on the values in DATASET1. So you are now merging this version of DATASET2:

Washington 1973

Washington 1974

Washington 1973

That's where you get the error message about the data not being in order. Running PROC SORT first will not help. You need to establish the longer length for DISTRICT. As was suggested, the LENGTH statement is a good way to do that.

Re: Merging Error

amychau — Mon, 05 Dec 2016 07:17:38 GMT

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.

Re: Merging Error

amychau — Mon, 05 Dec 2016 07:44:45 GMT

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

Re: Merging Error

amychau — Mon, 05 Dec 2016 07:46:28 GMT

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