Extracting the Postal Codes from Addresses of Hospitals in British Columbia – An Exercise in SAS Text Processing


In my job as a Biostatistical Analyst at the British Columbia (BC) Cancer Agency in Vancouver, I recently needed to get the postal codes for the hospitals in BC.  I found a data table of the hospitals with their addresses, but I needed to extract the postal codes from the addresses.  In this tutorial, I will show you some text processing techniques in SAS that I used to extract the postal codes from that raw data file.

* This blog post contains information licensed under the Open Government License – British Columbia.

Read the rest of this post to get the SAS code for extracting the postal codes and the final spreadsheet that contains the postal codes of the hospitals in British Columbia!

Read more of this post

A New Job at the British Columbia Centre for Excellence in HIV/AIDS

Dear Readers of The Chemical Statistician,

You may have noticed that I have blogged less frequently in the past few months; this has been due to a major change in my career: I recently accepted a new job in the Laboratory Program at the British Columbia Centre for Excellence (BC-CFE) in HIV/AIDS in Vancouver!

Eric Cai - Official Head Shot

A bioinformatician who works in this group recommended me for this position to his supervisors during this past summer.  Having lived in Vancouver before, I have heard a lot about the work that the BC-CFE in HIV/AIDS has done for many years to improve the lives of HIV and AIDS patients and prevent HIV transmission.

Read more of this post