Hello,

My current dataset for each county has _ID _CX _CY variables except for few counties. My main dataset is repeated cross section which I merged with us census county .shp data to collect those particular variables to merge on basis of county code.

However, when I'm using the following code this gives me error :

Code:
spmap hispanic using clean_cps42, id(_ID) clm(custom) clb(0(10)100) fcolor(ln_wage)
File clean_cps42.dta is not a valid basemap dataset
r(198);
This error means _X is required and is a numeric variable that contains the x-coordinate of the nodes of the base map polygons. _Yis required and is a numeric variable that contains the y-coordinate of the nodes of the base map polygons. I have the data for _X and _Y too for each county but that data has no indicator for what county the _X and _Y are for.


I'm giving the sample of data below

Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input float(hispanic ln_incwage) double county int _ID double(_CX _CY)
0  9.685331 1117 26 -86.66066541307332 33.26427760112504
0 10.567463 1117 26 -86.66066541307332 33.26427760112504
0         . 1117 26 -86.66066541307332 33.26427760112504
0         . 1117 26 -86.66066541307332 33.26427760112504
1  10.52901 1117 26 -86.66066541307332 33.26427760112504
1  9.424644 1117 26 -86.66066541307332 33.26427760112504
0 10.304108 1117 26 -86.66066541307332 33.26427760112504
0         . 1117 26 -86.66066541307332 33.26427760112504
0 10.276154 1117 26 -86.66066541307332 33.26427760112504
0 10.723927 10001 964 -75.5684223159937 39.08616892823275
1  10.34377 10001 964 -75.5684223159937 39.08616892823275
1  10.27648 10001 964 -75.5684223159937 39.08616892823275
0   9.64782 10001 964 -75.5684223159937 39.08616892823275
1         . 10001 964 -75.5684223159937 39.08616892823275
0    10.272 10001 964 -75.5684223159937 39.08616892823275
0 10.596635 10001 964 -75.5684223159937 39.08616892823275
0 10.213102 20045 1655 -95.29259106013197 38.88466799093866
0         . 20045 1655 -95.29259106013197 38.88466799093866
0 9.3805895 20045 1655 -95.29259106013197 38.88466799093866
1  8.582082 20045 1655 -95.29259106013197 38.88466799093866
1  8.718009 20045 1655 -95.29259106013197 38.88466799093866
0   9.17295 20045 1655 -95.29259106013197 38.88466799093866
0 10.309952 20045 1655 -95.29259106013197 38.88466799093866
0 10.435761 20045 1655 -95.29259106013197 38.88466799093866
end
This is the data sample where I have _X and _Y variables for each county :

[CODE]
Code:
* Example generated by -dataex-. For more info, type help dataex
clear
input int _ID double(_X _Y) strL rec_header int shape_order
1                 .                  . "\0\0    H\0\0\0q�::�KV�F��0uB@�Ƽ�84V��]g�B@\0\0\0&\0\0\0\0\0\0"   1
1 587169.7468999204 3945805.7978895735 ""                                                       2
1 587291.9675300308  3946568.234408276 ""                                                       3
1 587542.8784654966 3947603.7875347678 ""                                                       4
1 587832.8755765569 3948311.3494306263 ""                                                       5
1 588118.9787921472  3949009.554303093 ""                                                       6
1 588202.9791910454 3949144.0540915113 ""                                                       7
1 590315.3146308373  3951371.276341358 ""                                                      13
11 879967.3559019613  4055356.812745668 ""                                                       2
11  880042.864661612   4055511.04531594 ""                                                       3
11 880245.7724900984 4055760.3633284476 ""                                                       4
11  880236.764172873   4056023.65252873 ""                                                       5
11 879995.4719701133  4056286.471413132 ""                                                       6
11 879875.9803839253 4056604.4261883516 ""                                                       7
11 879928.1582158755  4056908.336943128 ""                                                       8
11  880115.876620123 4057172.5198362162 ""                                                       9
11 880170.0840602495 4057438.7541812984 ""                                                      10
11 880152.9314452348  4057580.624827211 ""                                                      11
26 836727.6865639449 3553379.6383021716 ""                                                      96
26 836594.8959286615 3554860.6200469546 ""                                                      97
26 836591.7283392546  3554941.186571909 ""                                                      98
26 836585.3291683497 3555008.8684600256 ""                                                      99
26 836567.0404264085 3555233.6770346966 ""                                                     100
end
Can I merge the data where I have _X and _Y variable with the data where I have county, _ID, _CX and _CY variables ?? The data with county, _ID, _CX and _CY variables is my master data