Question: Is this the correct way to solve the exercise? Exercise 2 . For the data set in file 'Exam_Ex2.xls', produce a report identical to the

Is this the correct way to solve the exercise?

Exercise 2. For the data set in file 'Exam_Ex2.xls', produce a report identical to the one stored in file 'Report_Ex2.pdf'.

data Hw2Ex2;

input state_name$ 1-20 state_abbrev$ 21-26 postal_abbrev$ 28-29 area_sq_mi 30-37 Population 38-47 ;

cards;

AlabamaAla.AL52,4234,040,587

AlaskaAlaskaAK656,424550,043

ArizonaAriz. AZ114,0063,665,228

ArkansasArk.AR53,1822,350,725

CaliforniaCalif.CA163,70729,769,021

ColoradoColo. CO104,1003,294,394

Connecticut Conn. CT5,544 3,287,116

DelawareDel.DE2,489 666,168

District of ColumbiaD.C.DC68606,900

FloridaFla.FL65,75612,937,926

GeorgiaGa.GA59,4416,478,216

HawaiiHawaiiHI10,9321,108,229

Idaho Idaho ID83,5741,006,749

IllinoisIll.IL57,91811,430,602

IndianaInd.IN36,4205,544,159

IowaIowaIA56,2762,776,755

KansasKans. KS82,2822,477,574

KentuckyKy.KY40,4113,685,296

LouisianaLa.LA51,8434,219,973

Maine Maine ME35,3871,227,928

MarylandMd.MD12,4074,781,468

MassachusettsMass. MA10,5556,016,425

MichiganMich. MI96,7059,295,297

MinnesotaMinn. MN86,9434,375,099

Mississippi Miss. MS48,4342,573,216

MissouriMo.MO69,7095,117,073

MontanaMont. MT147,046799,065

NebraskaNebr. NE77,3581,578,385

NevadaNev.NV110,5671,201,833

New HampshireN.H.NH9,351 1,109,252

New JerseyN.J.NJ8,722 7,730,188

New MexicoN.Mex.NM121,5981,515,069

New YorkN.Y.NY54,47117,990,455

North CarolinaN.C.NC53,8216,628,637

North DakotaN.Dak.ND70,704638,800

OhioOhioOH44,82810,847,115

OklahomaOkla. OK69,9033,145,585

OregonOreg. OR98,3862,842,321

PennsylvaniaPa.PA46,05811,881,643

Rhode IslandR.I.RI1,545 1,003,464

South CarolinaS.C.SC32,0083,468,703

South DakotaS.Dak.SD77,121696,004

TennesseeTenn. TN42,1464,877,185

Texas Tex.TX268,60116,986,510

UtahUtahUT84,9041,722,850

VermontVt.VT9,615 562,758

VirginiaVa.VA42,7776,187,358

WashingtonWash. WA71,3024,866,692

West VirginiaW.Va. WV24,2311,793,477

WisconsinWis.WI65,4994,891,769

WyomingWyo.WY97,818453,588

options pagesize=60 nodate nonumber linesize=100 ; title;

proc report data=Hw2Ex2 nowd headline headskip;

define State_Name/ width=20 'State Name';

define State_Abbrev/ spacing=7 width=7 'State Abbrev.';

define Postal_Abbrev/ spacing=10 width=7 'Postal Abbrev.';

define Area_Sq_Mi/ spacing=10 width=7 'Area (Sq Mi)' format=comma7.0; define Population/ spacing=10 width=10 format=comma10.0;

run;

StatePostalArea

State NameAbbrev.Abbrev.(Sq Mi)Population

AlabamaAla.AL52,4234,040,587

AlaskaAlaskaAK656,424550,043

ArizonaAriz.AZ114,0063,665,228

ArkansasArk.AR53,1822,350,725

CaliforniaCalif.CA163,70729,769,021

ColoradoColo.CO104,1003,294,394

ConnecticutConn.CT5,5443,287,116

DelawareDel.DE2,489666,168

District of ColumbiaD.C.DC68606,900

FloridaFla.FL65,75612,937,926

GeorgiaGa.GA59,4416,478,216

HawaiiHawaiiHI10,9321,108,229

IdahoIdahoID83,5741,006,749

IllinoisIll.IL 57,91811,430,602

IndianaInd.IN36,4205,544,159

IowaIowaIA56,2762,776,755

KansasKans.KS82,2822,477,574

KentuckyKy.KY40,4113,685,296

LouisianaLa.LA51,8434,219,973

MaineMaineME35,3871,227,928

MarylandMd.MD12,4074,781,468

MassachusettsMass.MA 10,5556,016,425

MichiganMich.MI96,7059,295,297

MinnesotaMinn.MN86,9434,375,099

MississippiMiss.MS48,4342,573,216

MissouriMo.MO69,7095,117,073

MontanaMont.MT147,046799,065

NebraskaNebr.NE77,3581,578,385

NevadaNev.NV110,5671,201,833

New HampshireN.H.NH9,3511,109,252

New JerseyN.J.NJ8,7227,730,188

New MexicoN.Mex.NM121,5981,515,069

New YorkN.Y.NY54,47117,990,455

North CarolinaN.C.NC53,8216,628,637

North DakotaN.Dak.ND70,704638,800

OhioOhioOH44,82810,847,115

OklahomaOkla.OK69,9033,145,585

OregonOreg.OR98,3862,842,321

PennsylvaniaPa.PA46,05811,881,643

Rhode IslandR.I.RI1,5451,003,464

South CarolinaS.C.SC32,0083,468,703

South DakotaS.Dak.SD77,121696,004

TennesseeTenn.TN42,1464,877,185

TexasTex.TX268,60116,986,510

UtahUtahUT84,9041,722,850

VermontVt.VT9,615562,758

VirginiaVa.VA42,7776,187,358

WashingtonWash.WA71,3024,866,692

West VirginiaW.Va.WV24,2311,793,477

WisconsinWis.WI65,4994,891,769

WyomingWyo.WY97,818453,588

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