BookmarkSubscribeRSS Feed
hamilton1
Calcite | Level 5

se an array and iterative processing to clean the survey data (located above this HW assignment).  Call your newly cleaned data set "cleansurvey".  Begin by identifying all of the dirty data (please highlight these in your SAS proc freq results.)  The Arrays lesson shows you how to change the 99s to blanks.  You also need to correct all typos.  Run proc freq again on your cleaned data to show that you were successful.  

4 REPLIES 4
ballardw
Super User

What you tried so far?

hamilton1
Calcite | Level 5
I am not sure what to do
DavePrinsloo
Pyrite | Level 9
I suggest you start by writing a data step to change the 99s to blanks. Use the results of the proc freq to see what else you need to change.
Reeza
Super User
Your instructor was kind enough to point you to the relevant resource: The Arrays lesson shows you how to change the 99s to blanks.

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 4 replies
  • 2180 views
  • 1 like
  • 4 in conversation