Hello, I downloaded census data files with zip code coordinates. the files are tl_2013_us_zcta510.dbf, tl_2013_us_zcta510.shx, and tl_2013_us_zcta510.shp from the census data site. the census site location is http://www.census.gov/cgi-bin/geo/shapefiles2013/layers.cgi I am trying to create a gmap by zip code. I can do it just fine by county and state, but not by city or zip code. When I try and do it by zip code using the census data the black border lines are filling in much of the map making it useless. What gives? Below are the basics of my process, I tried attaching a screenshot of the map but the forum won't let me. Thanks, I appreciate all help and comments. /* importing the census data for zip code coordinates*/ proc mapimport datafile="/folder/proj/&dir/&user/Notes/&prj/Data/tl_2013_us_zcta510.shp" out=zipdata; run; /*importing a file containing a list of all florida zip codes */ Data FL_Zips; infile "/folder/proj/&dir/&user/Notes/&prj/Data/FL_Zips.csv" dlm=',' dsd firstobs=3; input Zipcode : $5.; format zipcode $5. ; run; /* filter so the map data set only contains florida zips */ proc sql; create table zipdata2 as select distinct t1.ZCTA5CE10 as Census_Zip, t1.X, t1.Y from zipdata t1 left join FL_Zips t2 on (t1.ZCTA5CE10=t2.Zipcode) where t2.zipcode is not missing order by Census_Zip;quit; /* attempting to create the map that outlines the zip codes in Florida. This creates a map where the border of Florida is accurate, but the interior of the map is mostly the black border filling in all over the place */ proc gmap=zipdata2 map=zipdata2; census_zip; choro census_zip; run; quit;
... View more