Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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 SASStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started