Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Home
- /
- Programming
- /
- SAS Studio
- /
- Re: Merging Error
Options
- RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 12-04-2016 11:37 PM
(3709 views)
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?
1 ACCEPTED SOLUTION
Accepted Solutions
Garnet | Level 18
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
8 REPLIES 8
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Can you post the full log that includes the submitted code.
If the code code isn't relevant please exclude it.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
Super User
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Are you doing a many to many merge?
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Garnet | Level 18
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
PROC Star
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Obsidian | Level 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Thank you for the explanation! Shmuel's solution worked.
SAS Innovate 2025: Register Now
Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
Register now!
SAS Enterprise Guide vs. SAS Studio
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.
SAS Training: Just a Click Away
Ready to level-up your skills? Choose your own adventure.
Discussion stats
-
8 replies
-
12-04-2016 11:37 PM
-
3710 views
-
3 likes
-
4 in conversation
-
