Question: i need help with using txt(import) to SAS programming. pls explain which codes I need to get outcomes.. Billboard Hot 100.txt is a space delimited

 i need help with using txt(import) to SAS programming. pls explain

i need help with using txt(import) to SAS programming. pls explain which codes I need to get outcomes..

Billboard Hot 100.txt is a space delimited file containing data on the top 25 songs according to the Billboard Hot 100 for the week of February 6. 2021. The included variables are Song (the title of the song), Artist, Rank (for the week), Peak (highest rank on the Billboard Hot 100), and Duration (number of weeks on the Billboard Hot 100). (a) Read the Billboard Hot 100.txt file into SAS using a DATA step including the DSD option in the INFILE statement. Print the data set and report the table. (Note: Some of the song and artist names will not be shown in their entirety - we will learn how to fix this next week.) (b) Read the Billboard Hot 100.txt file into SAS using a DATA step but do not include the DSD option in the INFILE statement. Print the data set and report the table. (c) Examine the Billboard Hot 100.txt file. Notice that many of the songs and artists consist of multiple words. In the file, these instances are surrounded by quotes. Explain why the DSD option must be placed in the INFILE statement of a DATA step when loading this file into SAS. Billboard Hot 100.txt is a space delimited file containing data on the top 25 songs according to the Billboard Hot 100 for the week of February 6. 2021. The included variables are Song (the title of the song), Artist, Rank (for the week), Peak (highest rank on the Billboard Hot 100), and Duration (number of weeks on the Billboard Hot 100). (a) Read the Billboard Hot 100.txt file into SAS using a DATA step including the DSD option in the INFILE statement. Print the data set and report the table. (Note: Some of the song and artist names will not be shown in their entirety - we will learn how to fix this next week.) (b) Read the Billboard Hot 100.txt file into SAS using a DATA step but do not include the DSD option in the INFILE statement. Print the data set and report the table. (c) Examine the Billboard Hot 100.txt file. Notice that many of the songs and artists consist of multiple words. In the file, these instances are surrounded by quotes. Explain why the DSD option must be placed in the INFILE statement of a DATA step when loading this file into SAS

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 Accounting Questions!