How to calculate the distance between two 9 digits zip code?

[GraceStehlin98]

Does zipcitydistance(zip1, zip2)    calculate only 5 digit zip code ?

I need to calculate the distance between two 9 digit zipcodes.

when I ran the 9 digits zipcode to calculate the distance, the log shows error "

NOTE: Invalid argument to function ZIPCITYDISTANCE('006460000','010133140') at line 28 column 13."

data _null_;

distance=zipcitydistance('006460000', '010133140');

put   ' distance 8. ' miles';

run;

Can someone share how to calculate the distance between 9 digit zip codes?

Thanks

[andreas_lds · Accepted solution]

The function zipcitydistance uses sashelp.zip (as documented) and that dataset contains only the five digit zip codes. So you need another function and data-source to calculate distances. Proc geocode could be used here, you want to read the documentation.