BookmarkSubscribeRSS Feed
hamilton1
Calcite | Level 5

Use 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.

 

https://blackboard.waketech.edu/bbcswebdav/pid-16104972-dt-content-rid-137570998_1/xid-137570998_1 

2 REPLIES 2
hamilton1
Calcite | Level 5

hamilton1_0-1592758984556.png

this is the survey data 

PaigeMiller
Diamond | Level 26

A couple of things. Your subject needs to be changed to something meaningful that briefly describes your problem. Every question asked here could be described as "SAS", so this is not a meaningful subject line. So please go back and change the subject line on your original post.

 

Next, no one is going to click on your link. It's not safe. Whatever you need us to know that is at that link, copy and paste it into the message as text. Nor is anyone going to look at and use your screen capture, the text is too small. Again, if you want to provide data, paste it into your message as text in the form of working SAS data step code.

 

Last, show us the code you have tried so far, as text. Again, paste it into your message by clicking on the little running man icon.

--
Paige Miller

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 2 replies
  • 526 views
  • 1 like
  • 2 in conversation