I have an issue I can't think through and was hoping for some assistance.
I have a data set wherein I need to create a new variable that contains the Local Government Area (LGA) that clients are residing in. To do this, I am using the postcodes they have provided. So I have written the syntax to recode the postcodes into their respective LGAs (i.e. RECODE Postcode (3690 3691 3692 = 1) and so on up to 12 LGAs), but, there is missing data and postcodes outside of the LGAs I have created. I would like to differentiate between actual missing data (the data set just has the period to represent missing data) and postcodes outside of the LGAs of interest. Is there some more syntax that I can add that will perhaps add 13 "Missing" and 14 "Other"?
I hope that makes some sense.
Thanks for your help.