Merging excel data sheets in stata.

Good morning I have a project that needs to be done in one day. I have to merge these datasets in STATA. Please when doing the work provide all the do files of all the work you have. That means there needs to be a do file showing that you imported the Excel file to Stata and then converted it. when writing in the do files please do not rename the file name. The file name should match so I can run it on my end. The Unique column is a community board with the letters CB#. Also, make sure all the variables match after the merge there. if there are 100 variables all 100 variables should match so make sure there are no missing variables. I need this assignment done by Saturday morning.

ID
Community Board
201 CB 1
202 CB 2
203 CB 3
204 CB 4
205 CB 5
206 CB 6
207 CB 7
208 CB 8
209 CB 9
210 CB 10
211 CB 11
212 CB 12
Borough
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Bronx
Neighborhoods Overall_PopRace_WhiteRace_Black Race_Asian
Mott Haven and Melrose
96584
1
24
1
Hunts Point and Longwood
55096
1
20
1
Morrisania and Crotona
89172
1
37
1
Highbridge and Concourse
152930
1
31
2
Fordham and University
132558
Heights
1
27
2
Belmont and East Tremont
85206
6
25
1
Kingsbridge Heights 144924
and Bedford
6
18
8
Riverdale and Fieldston
101146
33
12
6
Parkchester and Soundview
182722
2
29
7
Throgs Neck and Co-op
120296
City
29
23
6
Morris Park and Bronxdale
113909
23
21
9
Williamsbridge and Baychester
152732
6
64
3
Race_LatinoRace_OtherAge0to17 Age18to24 Age25to44 Age45to64 Age65plus Ltd_Eng_Prof
lower_95CL
74
1
27
11
28
22
13
29
27.8
77
1
27
10
29
22
12
29
27.8
61
1
28
10
28
23
11
27
25.5
65
1
26
10
29
24
12
37
34.9
69
1
27
10
29
24
10
36
34.3
67
1
28
12
28
21
11
27
25.5
67
1
25
10
30
24
11
37
35.1
48
2
20
8
27
25
20
23
21.6
60
2
24
9
28
25
14
24
22.7
41
2
20
8
25
27
21
13
11.1
45
1
22
8
29
24
17
24
22.5
25
2
23
9
27
26
15
10
9.2
upper_95CLNYC_Comparison
Born_Outside_US
lower_95CLupper_95CLNYC_Comparison
School_Absent
NYC_comparison
On_Time_HS_Grad
30.4 Higher
30
28.3
31.1 Lower
38 Higher
73
30.4 Higher
30
28.3
31.1 Lower
38 Higher
74
28.2 Higher
31
29.8
32.4 Lower
37 Higher
72
38.2 Higher
43
41.1
44.3 Lower
32 Higher
76
37.5 Higher
43
42.1
44.6 Lower
32 Higher
75
28.2 Higher
31
29.8
32.4 Lower
38 Higher
74
39.3 Higher
44
41.7
46 Lower
31 Higher
79
24.9 Same
34
32.2
35.7 Lower
21 Lower
83
25.2 Higher
33
31.1
34.3 Lower
30 Higher
78
14.3 Lower
23
21.1
24 Lower
24 Higher
83
25.3 Same
33
31.9
34.8 Lower
25 Higher
83
11.2 Lower
40
38.3
41.4 Lower
34 Higher
79
NYC_Comparison
Edu_Did_Not_Complete_HS
lower_95CLupper_95CLNYC_Comparison
Edu_HSGrad_Some_College
lower_95CLupper_95CLNYC_Comparison
Lower
37
35.4
38.7 Higher
45
43.6
46.9 Higher
Lower
37
35.4
38.7 Higher
45
43.6
46.9 Higher
Lower
34
32.8
35.4 Higher
46
44.9
47.5 Higher
Lower
33
30.8
34.3 Higher
45
43.5
46.8 Higher
Lower
34
32.8
36 Higher
46
44.2
47.9 Higher
Lower
34
32.8
35.4 Higher
46
44.9
47.5 Higher
Similar
30
28.1
32.4 Higher
47
45.3
49.3 Higher
Similar
18
16.8
19.8 Same
36
34.1
37.5 Same
Lower
27
25.3
28.2 Higher
47
45.1
48.5 Higher
Similar
16
14.1
17.1 Lower
46
44.4
48.6 Higher
Similar
22
20.5
23.1 Higher
44
42.5
46.1 Higher
Similar
20
19
21.6 Higher
48
46.3
49.2 Higher
Edu_College_Degree_And_Higher
lower_95CLupper_95CLNYC_Comparison
Poverty
Unemployment
lower_95CLupper_95CLNYC_Comparison
18
16.6
18.8 Lower
32
12
11
14 Higher
18
16.6
18.8 Lower
32
12
11
14 Higher
20
18.6
20.8 Lower
31
13
12
15 Higher
22
20.8
23.7 Lower
34
10
9
11 Higher
20
18.2
21 Lower
35
12
11
13 Higher
20
18.6
20.8 Lower
31
13
12
15 Higher
22
20.9
23.9 Lower
29
11
10
13 Higher
46
44.2
47.5 Same
19
7
6
8 Similar
26
25.1
27.9 Lower
29
9
8
10 Higher
38
35.7
40.2 Lower
16
7
5
8 Similar
34
32.4
35.5 Lower
20
9
8
10 Higher
32
30.4
33.5 Lower
22
9
8
10 Higher
Rent_Burden
lower_95CLupper_95CLNYC_Comparison
Avertable_Death
Assault_Hosp
lower_95CLupper_95CLNYC_Comparison
58
56
61 Higher
48
186
170
201.4 Higher
58
56
61 Higher
40
151
132.7
170.2 Higher
58
56
61 Higher
52
161
146
176.6 Higher
59
56
62 Higher
41
123
112.5
132.8 Higher
62
59
64 Higher
45
126
114.8
136.9 Higher
58
56
61 Higher
48
152
137
168 Higher
61
57
64 Higher
41
97
87.8
106.2 Higher
52
49
56 Same
32
40
32.8
47.1 Lower
55
53
58 Higher
36
100
91.4
108.2 Higher
46
41
50 Same
32
53
45.3
60.7 Similar
56
53
59 Higher
36
64
55.7
72.7 Similar
59
55
62 Higher
34
82
73.3
89.9 Higher
Jail_Incarceration
Helpful_Neighbor
lower_95CLupper_95CLNYC_Comparison
NYC_Comparison_Pvalues
Homes_No_Defects
Homes_No_Defects_reliability_note
Homes_Roach
510
68
60.3
74.1 Lower
0.007
36
0
46
425
68
60.3
74.1 Lower
0.007
36
0
46
516
66
59.1
71.6 Lower