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
... View more