Proc Geocode Freezes with Street Level Option 9.4 (TS1M4)

DPP — Thu, 09 Mar 2017 13:21:34 GMT

We've recently installed SAS 9.4.TS1M4. When trying to GEOCODE 4 MM rows of data the proc hangs up. It reached 5% at one point and appears to get increasingly slow between % readouts in the log. Eventually it hangs altogether. We are using StreetLookupData_94-2016 address files and Proc coding log and results are below. If I add obs then things seem to finish relatively fast. I've seen board posting about freeze issues with prior SAS releases; just wondering if this release has the same issues. Any help would be appreciated.

23 proc GEOCODE

24 method=street /* Geocoding method */

25 data=geoData.PAT_ADDRESS (obs=5000) /* Input address data */

26 out=geoData.PAT_ADDRESS_GEO /* Geocoded output data set*/

27 lookupstreet=streetdl.usm /* Tiger 2016 data set */

28 /*attribute_var=(tracte00) /* Added output variables */

29 ;

30 run;

NOTE: Address data set GEODATA.PAT_ADDRESS has 3,891,171 observations.

_________________ Geocoding Progress _____________________

_____ Completed ____ _____________ Time _______________

Percent Obs Current Remaining Completion

0% 0 07:09:20 -- --

100% 5,000 07:12:39 00:00:00 --

_________ Geocoding Summary _____________________________

Address data: GEODATA.PAT_ADDRESS

Output data: GEODATA.PAT_ADDRESS_GEO

STREET lookup data: STREETDL.USM

CITY lookup data: MAPSGFK.USCITY_ALL

ZIP lookup data: SASHELP.ZIPCODE

Geocoding method: Street level

Run date: 09Mar2017

Obs processed: 5,000

Elapsed time: 00:03:19

Obs per minute: 1,505

Street matches: 2,846

ZIP matches: 1,954

City matches: 87

Not matched: 113

Re: Proc Geocode Freezes with Street Level Option 9.4 (TS1M4)

Kurt_Bremser — Thu, 09 Mar 2017 13:54:39 GMT

Given your progress of 1505 obs / min, the whole dataset would need 43 hours.

Either something is seriously wrong with the lookup data, or your SAS machine is massively underpowered for this.

Re: Proc Geocode Freezes with Street Level Option 9.4 (TS1M4)

DPP — Sat, 11 Mar 2017 14:31:00 GMT

Thanks for the response; the machine is an I7 8 core with 32 Gig of RAM; The 2019 Tiger files were downloaded and built using scripts at SAS Maps Online (http://support.sas.com/rnd/datavisualization/mapsonline/html/geocode.html) with no errors. When I run 100 or 5000 or even 50,000 things work. Eventually the thing hangs up. Can't really see any issues with horse power or Tiger files.

topic Proc Geocode Freezes with Street Level Option 9.4 (TS1M4) in SAS Procedures

Proc Geocode Freezes with Street Level Option 9.4 (TS1M4)

Re: Proc Geocode Freezes with Street Level Option 9.4 (TS1M4)

Re: Proc Geocode Freezes with Street Level Option 9.4 (TS1M4)