DATA Step, Macro, Functions and more

Please help me below question.

Reply
New Contributor
Posts: 3

Please help me below question.

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. 

PROC Star
Posts: 1,190

Re: Please help me below question.

[ Edited ]

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

New Contributor
Posts: 3

Re: Please help me below question.

Hello

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

thanks

Ask a Question
Discussion stats
  • 2 replies
  • 86 views
  • 0 likes
  • 2 in conversation