Question: Given the five lines of data: 1 , , HELLO, 7 2 , 4 , TEXT, 8 9 , , , 6 2 1 ,

Given the five lines of data:
1,,"HELLO",7
2,4,TEXT,8
9,,,6
21,31,SHORT
100,200,"LAST LINE",999
Write a SAS DATA step to read these data, assigning the four data values to the variables X, Y, C and Z. Variable C should be a character variable. (Note that the value of variable C in the last line is nine characters.) The double quotes should be stripped off the text strings and two adjacent commas should be interpreted as containing a missing value. Careful, line four has only three values on it. Remember the INFILE option to handle short lines.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!