Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Alaskas Permanent Fund Dividend Examining Its Suitability As A Model

Authors: K. Widerquist, M. Howard

2nd Edition

0230112072, 9780230112070

More Books

Students also viewed these Accounting questions

Question

LO5 Explain how to generate effective recruitment advertisements.

Answered: 1 week ago