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
Get step-by-step solutions from verified subject matter experts
