BookmarkSubscribeRSS Feed
emmaroy
Calcite | Level 5

I am trying to geocode canadian addresses using Proc Geocode. I have downloaded required files (CANADA_M.csv, CANADA_S.csv,  CANADA_P.csv,  GCTYPE_CAN.csv, GCDIRECT_CAN.csv)  and imported them into SAS Viya according to program (ImportCSVfiles.sas).  

I am trying following codes:
 
data testCA;
  length address $64 city $24 state $2;
  infile datalines dlm=',';
  input address city state zip;
cards;
100 New Brighton Dr SE, Calgary, AB, T2Z 4W5
100 Parkmere Ct, Chestermere, AB, T1X 1V5
;

proc geocode debug=4
data = work.testCA
out = work.geocoded
method = street
lookupstreet = lookup.canada_m /* Street lookup data set */
direct = lookup.gcdirect_can /* English/French directions */
type = lookup.gctype_can /* Canadian street types */
addressstatevar = state /* Input data set state name var */
addresscityvar = city  /* Input data set city name var */
ADDRESSVAR = address
nozip;
run;
quit;
I am getting following error:
ERROR: Domain error.
ERROR: Termination due to Floating Point Exception
 
I have SAS version 9.4. Addresses I have used in datafile are taken from the lookup file. 
 
Can you please help me understand why am I getting this error and how to solve it?
1 REPLY 1
SASKiwi
PROC Star

This type of problem is quite serious and is best diagnosed by SAS Tech Support, so I'd suggest you open a track if you haven't done so already.

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
Mastering the WHERE Clause in PROC SQL

SAS' Charu Shankar shares her PROC SQL expertise by showing you how to master the WHERE clause using real winter weather data.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 425 views
  • 0 likes
  • 2 in conversation