Please help me below question.

[alj388]

Hello,

I am doing a project, with a table of over 20000 obs, SSN is the PK, variables including zip, city, and state. I found zip column is all correct zip code, but 3000 related states are missing, and 4 cities are missing, please write a code to fill the missing values according to the zip code.

Many thanks. 

[PeterClemmensen]

Plenty of material on the subject with a simple Google search

Check out the ZIPSTATE and ZIPCITY Functions

Also see the Sashelp.Zipcode data set

[alj388]

Hello

I need help with writing a macro code to fill all 3000+ missing values, not only instructions.

thanks