recode catergorical variables

Nyac122 — Sun, 30 Oct 2022 22:12:30 GMT

i am trying to recode my district variables so i can use proc reg and its not working .

WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed

data flgrads;
input districts $ 1-9 year $ 10-20 percentage;
datalines;
alachua 2016-2017 82.7
alachua 2017-2018 88
alachua 2018-2019 88.5
alachua 2019-2020 90.4
alachua 2020-2021 86.6
baker 2016-2017 81
baker 2017-2018 75.5
baker 2018-2019 78.8
baker 2019-2020 84.5
baker 2020-2021 85.7
bay 2016-2017 78.0
bay 2017-2018 81.1
bay 2018-2019 82.5
bay 2019-2020 88.5
bay 2020-2021 90.2
bradford 2016-2017 78.9
bradford 2017-2018 89
bradford 2018-2019 87.7
bradford 2019-2020 98.2
bradford 2020-2021 85
brevard 2016-2017 85.9
brevard 2017-2018 88.1
brevard 2018-2019 88.3
brevard 2019-2020 90.3
brevard 2020-2021 90.6
broward 2016-2017 81
broward 2017-2018 84.3
broward 2018-2019 86.2
broward 2019-2020 89.4
broward 2020-2021 89.1
calhoun 2016-2017 80.9
calhoun 2017-2018 86.9
calhoun 2018-2019 87.9
calhoun 2019-2020 89.9
calhoun 2020-2021 93.1
Charlotte 2016-2017 81.0
Charlotte 2017-2018 87.6
Charlotte 2018-2019 86.4
Charlotte 2019-2020 90.4
Charlotte 2020-2021 90.9
Citrus 2016-2017 78.9
Citrus 2017-2018 84.1
Citrus 2018-2019 86.0
Citrus 2019-2020 87.1
Citrus 2020-2021 88.1
Clay 2016-2017 88.4
Clay 2017-2018 91.1
Clay 2018-2019 91.9
Clay 2019-2020 93.4
Clay 2020-2021 92.7
Collier 2016-2017 88.2
Collier 2017-2018 91.9
Collier 2018-2019 91.9
Collier 2019-2020 92.2
Collier 2020-2021 92.7
Columbia 2016-2017 70.7
Columbia 2017-2018 88.4
Columbia 2018-2019 92.4
Columbia 2019-2020 95.4
Columbia 2020-2021 95.6
MiamiDade 2016-2017 80.7
MiamiDade 2017-2018 85.4
MiamiDade 2018-2019 85.6
MiamiDade 2019-2020 89.6
MiamiDade 2020-2021 90.1
DeSoto 2016-2017 63.8
DeSoto 2017-2018 60.9
DeSoto 2018-2019 71.3
DeSoto 2019-2020 84.6
DeSoto 2020-2021 82
Dixie 2016-2017 89.5
Dixie 2017-2018 96.9
Dixie 2018-2019 90.6
Dixie 2019-2020 89.8
Dixie 2020-2021 84
Duval 2016-2017 80.8
Duval 2017-2018 85.1
Duval 2018-2019 86.5
Duval 2019-2020 90.2
Duval 2020-2021 89.6
;
proc print;
run;
data flgrads2;
set flgrads;
Alachua= (district= 0);
Baker= (districts= 1);
Bay = (districts= 2);
Bradford= (districts= 3);
Brevard= (districts= 4);
Broward= (districts= 5);
Calhoun= (districts= 6);
Charlotte= (districts= 7);
Citrus= (districts= 8);
Clay= (districts= 9);
Collier= (districts= 10);
Columbia= (districts= 11);
MiamiDade= (districts= 12);
DeSoto= (districts= 13);
Dixie= (districts= 14);
Duval= (districts= 15);
run;

Nyac122 Tracker

recode catergorical variables