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.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

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
  • 642 views
  • 0 likes
  • 2 in conversation