Hello I am trying to run a code which givers error particular values of zipcode.
data _null_;
dist=zipcitydistance(36310,36061);
run;
The error in the log is
NOTE: ZIP code value 36310 could not be found in SASHELP.ZIPCODE.
NOTE: Invalid argument to function ZIPCITYDISTANCE('36310','36061') at line 27 column 6.
dist=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 27:6
If I change the order of zipcode in the function taking 36061 first, then the error would be
24
25 GOPTIONS ACCESSIBLE;
26 data _null_;
27 dist=zipcitydistance(36061,36310);
28 run;
NOTE: ZIP code value 36061 could not be found in SASHELP.ZIPCODE.
NOTE: Invalid argument to function ZIPCITYDISTANCE(36061,36310) at line 27 column 6.
dist=. _ERROR_=1 _N_=1
NOTE: Mathematical operations could not be performed at the following places. The results of the operations have been set to
missing values.
Each place is given by: (Number of times) at (Line):(Column).
1 at 27:6
The server has been updated for the latest values of zipcodes. Looks like I missing something. Can anybody help?
... View more