search

NeighborhoodInfoDC / Vital

Vital statistics (births & deaths)
0 stars 0 forks source link

Add missing formats and clean up geocoding #15

Open rpitingolo opened 6 years ago

rpitingolo commented 6 years ago

From Peter: I did note that a number of the categorical variables do not have formats assigned, which means they won't be documented in the metadata. I'm OK with skipping that for now, in the interest of moving ahead, but would you please make a new issue that would include adding those formats, as well as further clean up of the geocoding. Thanks.

ptatian commented 5 years ago

@rpitingolo SAS upgrade to 9.4 (TS1M5) has solved problem with Proc Geocode (ERROR: Too many WHERE clause resets.) in Prog\Births_geocode.sas.

In testing the program, this warning/error now appears because proc mapimport references a local shapefile that is actually on L:. 

WARNING: Physical file does not exist, D:\DCData\Libraries\Vital\Maps\OLD\School_Attendance_Zones_Elementary__Old.shp.
ERROR: Unable to open DATAFILE.

Shapefile reference should be changed from D: to L:.

You should ask the Help Desk for an upgrade to the latest SAS release so that work on this issue can continue.