topic Re: proc geocode features in SAS Programming

proc geocode features

Emma_at_SAS — Thu, 16 Dec 2021 20:48:32 GMT

I have patient data in Canada that has province, city, and the closest intersection and I want to get the postal code for each participant. I could not find any feature in proc geocode to find the postal codes with the information I have. I appreciate your help for this dataset and if you have an advise for data collection in the future (when participants do not like to report their exact address or postal code-My thought was I may ask to get the address for the closest store to their home so I can get an approximation for postal code using proc geocode). I appreciate your help. Thanks

Re: proc geocode features

Reeza — Thu, 16 Dec 2021 21:18:39 GMT

Why do you need postal codes?

If you have the nearest location you could pass that to proc GEOCODE to get the lat/long. You could then compare that to a file that had postal codes to find the nearest postal code. Unfortunately that postal code data is restricted, you need either the PCCF file from StatCan/Canada Post, or a different source (PCTF in Alberta). FYI - this is a data intensive calculation.

Re: proc geocode features

ballardw — Thu, 16 Dec 2021 21:28:04 GMT

I would be tempted to contact any billing or who ever tracks such items as I would expect that side of the system to have postal contact information.