topic Re: Please help me below question. in SAS Programming

Please help me below question.

alj388 — Tue, 08 May 2018 17:56:57 GMT

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.

Re: Please help me below question.

PeterClemmensen — Tue, 08 May 2018 18:10:19 GMT

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

Re: Please help me below question.

alj388 — Wed, 09 May 2018 17:51:48 GMT

Hello

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

thanks