When you use PROC GEOCODE with the STREET geocoding method, processing of the procedure might stop and produce either of the following errors:
The SAS system also might stop responding, which forces you to perform a manual termination.
This problem can occur when an address contains any of the following characters, or multiples of that character, as the street name:
.
-
#
/
To circumvent the problem, pre-process the address data set using the following code to remove these characters as the street name. Then reference the NEWADDRESS variable in the PROC GEOCODE ADDRESSVAR= option.
/* Here is a geocoding address data set named ADDRESS */
data address;
set address;
/* Create a new address variable named NEWADDRESS by
keeping only alphabetical characters, digits, and spaces
from the original ADDRESS variable */
newaddress=compress(address,,'kads');
/* The NEWADDRESS variable will be referenced in the PROC GEOCODE
ADDRESSVAR= option */
run;