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-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 2 replies
  • 379 views
  • 1 like
  • 2 in conversation