That's What I Like,Bruno Mars, $3$:$26$

Shape of You,Ed Sheeran,$3$:$53$

Something Just Like This,The Chainsmokers & Coldplay,$4$:$07$

Stay,Zedd & Alessia Cara, $3$:$30$

Say You Won't Let Go$,$James Arthur, $3$:$31$

It Ain't Me$,$Kygo x Selena Gomez, $3$:$40$

Despacito,Luis Fonsi & Daddy Yankee Featuring Justin Bieber, $3$:$47$

I$\text{'}$m The One, $"$DJ Khaled Featuring Justin Bieber, Quavo, Chance the Rapper & Lil Wayne",$4$:$48$

Issues,Julia Michaels,$2$:$56$

Humble.,Kendrick Lamar, $2$:$57$

Body Like A Back Road,Sam Hunt, $2$:$45$

Castle On The Hill,Ed Sheeran, $4$:$21$

Scars To Your Beautiful,Alessia Cara, $3$:$50$

Mask Off, Future, $3$:$23$

In Case You Didn't Know, Brett Young, $3$:$44$

Believer, Imagine Dragons, $3$:$23$

Redbone, Childish Gambino,$5$:$26$

Passionfruit, Drake, $3$:$25$

Slide,Calvin Harris Featuring Frank Ocean & Migos, $3$:$50$

If I Told You,Darius Rucker, $3$:$34$

Sign Of The Times,Harry Styles,$4$:$03$

There's Nothing Holdin' Me Back,Shawn Mendes, $3$:$19$

Hurricane, Luke Combs, $3$:$44$

How Not To$,$Dan $+$ Shay, $3$:$13$

Now Or Never,Halsey, $3$:$34$ Baltimore MD $$10\mathrm{.}95$ Brooklyn NY $$12\mathrm{.}99$ Buffalo

NY $$11\mathrm{.}50$ Harlem NY $$12\mathrm{.}50$ Newark NJ

$$11\mathrm{.}50$ Rochester NY $$10\mathrm{.}95$ Stamford CT $$11\mathrm{.}50$

Syracuse NY $$10\mathrm{.}95$ Troy NY $$11\mathrm{.}50$The data set DinosaurBBQ.txt posted on Blackboard contains data on the price of a quarter rack of

ribs at the $9$ different Dinosaur Bar$-$B$-$Que locations. Each observation is made up of the restaurant's

city, state, and price. It is a space delimited file, but more than one observation appears on a single

line.

$($a$)$ Read the data into SAS, making use of informats and double trailing at signs. Print the data set

and report the resulting output.

$($b$)$ Read the data into R$,$ making use of the readLines $(),$ strsplit$(),$ and gsub $()$ functions.

Report the resulting data frame. $($Hint: R actually has a hard time replacing $ with gsub$()$

since it is a special character. Try replacing the character $ instead.$)$

$($c$)$ Export the data frame created in part $($b$)$ to an Excel spreadsheet $(.$xlsx$).$ Upload this spreadsheet

when submitting your work. $($You don't need to provide any output for this part.$)$

The data set Billboard.txt posted on Blackboard consists of the song title, artist, and length of the

top $25$ radio songs for the week of June $17,2017.$ It is a comma delimited file.

$($a$)$ Run the following SAS program $($where path is your respective file path$)$ and report the output:

DATA song;

INFILE 'path$\backslash$Billboard$.$txt$\text{'}$ DLM$=\text{'},\text{'}$;

INPUT Song $ Artist $ SongLength;

RUN$$

PROC PRINT DATA $=$ song;

RUN;

$($b$)$ Alter the program so that the data set stores:

the complete song and artist$($s$)$ names.

song length as numeric data.

Report your output.

$($c$)$ Export the SAS data set in part b to a tab delimited text file. Upload this file when submitting

your work. $($You don't need to provide any output for this part.$)$