proc-report(style)

1、1“Table1”inScientificManuscripts;UsingPROCREPORTandtheODSSystemCarterSevick,DoDCenterforDeploymentHealthResearch,SanDiego,CAABSTRACTTheabilitytocombinethepowerandflexibilityofPROCREPORTandtheOutputDeliverySystem(ODS)hasrevolutionizedsummaryreportingandtablecreation.However,themajorityofresourcesavailableapproachthesubjectpredominantlyfromabusinessperspective.Researchersinpublichealthtendtoemphasizecategoricaldataovercontinuousandhaveadifferentaestheticwhenitcomestooveralllookanddesigncreatingth。

2、eneedforasubtlydifferentskillsetandapproach.ThispaperwilltakethereaderthroughtheprocessofcreatingasummarytablefromrawdataandpresentingtheresultsinRTFformat.Summarizeddatawillincludeabinaryexposurestratifiedbydemographicinformation,andinadditiontofrequencies,univariateanalyseswillalsobepresented.Itshouldbeemphasizedthatthispaperisnotadiscussionofastudy,butratheradiscussionofdatapresentation.ItwillbeassumedthatthereaderhasbeginningorintermediateexperiencewithSAS®.INTRODUCTIONFormanydataanalyststhe。

3、productionofsummarytablesisatimeconsumingprocessthatisoftenaccomplishedbyexportingSASprocedureresultstosomethirdpartywordprocessingorspreadsheetsoftwarewheretheactualbuildingofthetabletakesplace.Thisisamanualprocessthatwillneedtoberepeatedinitsentiretyiftheaudience(suchasaclientorsupervisor)desiresachangeinthecontent.Partofthebeautyofprogrammingisthatcodemaybereused,whilemouseclicksmaynot,andifthecreationofasummarytableisdoneviaprogrammingthensmalltweakingofcodemaybeallthatisnecessarytosatisfyde。

4、mandsforchanges.ThispaperwilltakethereaderthroughtheprocessofcreatingasummarytablefromrawdataandpresentingtheresultsinRTFformat.THEDATAForthistutorialadatasetwasgeneratedtosimulatewhatananalystinthefieldofpublichealthmightencounter.Thecodeforthisdatasetisincludedintheappendix.Belowisapartiallistingofthesedata.Figure1.AlookatthedataObsgenderregionexposure11302020312040105010611170108030901010110Eachrowdescribesanindividualbirth.Thethreevariablescomposingthedatasetinclude:thechild’sgender,theregio。

5、nofbirth,andabinaryexposurevariable.Theformatsthatdescribethelevelsofthesevariablesareincludedintheappendix.THEGOALFromthesedatawewouldliketoproduceatypeoftabletypicallyseeninthebeginningofscientificmanuscripts.“Table1”,asweliketocallit,providestheaudiencewithsummarydescriptionsofvariablestobestudiedinananalysis.“Table1’s”varyfromstudytostudymostlydependingonvariabletype,analysesusedandpersonalpreferences.But,theoverallmessageofthetableisconsistentlythesame.Thegoalofthispaperwillbetoproduceatabl。

6、ethatsummarizesthecountsoftotalbirthsandexposedbirthsstratifiedbygenderandregion.AdditionallywewouldliketodisplaytheresultsofaChi-squaretestforassociationbetweenexposurestatusandour2twocharacteristics.Table1(below)showstheendresultthatwewillbestrivingfor.Thistableshallbeproduced,asanRTFdocument,completelythroughprogrammingwithoutcuttingandpasting,orothersuchmanualword-processingactivities.Table1:CharacteristicsofSubjectsVariableAllbirthsn(n=2,000)Numberexposedn(%)(n=420)p-value1GenderofinfantFem。

7、ale1,002204(20.4)0.4809Male998216(21.6)RegionofbirthMid-Lands1,090214(19.6)0.0036High-Lands45381(17.9)Low-Lands21558(27.0)Other-lands14342(29.4)Unknown9925(25.3)1Chi-squaretestforassociationTHEPATHTheprocessthatwewillfollowwillcomeintwosteps.Instepone,asummarydatasetwillbecreatedthatcontainsalloftheinformationthatneedstobedisplayed.SteptwoconsistsofemployingPROCREPORTandtheOutputDeliverySystem(ODS)tocreatethestructureofthetableandexportitintoanRTFdocument.Thesubjectmatterofsteponewillbetreatedin。

8、briefwithonlythemoreunusualaspectsoftheprogramfullyexplained.SUMMARIZINGTHEDATAHowyougoaboutcreatingasummarydatasetisyourbusiness,buthoweveryoudoitaimtoendupwithvariablesthatmirrorthecolumnsthatyouwanttodisplayinyourtable.Uponinspection,Table1(above)canbebrokendownintothefollowingfivecolumnsofinformation:•Column1:Thiscolumnstateswhichvariableisbeingsummarizedinthecurrentrow.•Column2:Indicateswhichlevelofthevariableisbeingsummarizedinthecurrentrow.•Column3:Countsofbirthswhichfallintoeachlevelofea。

9、chvariable.•Column4:Acountofexposedbirthsineachlevelfollowedbythepercentageofbirthswithinthatlevel.•Column5:TheresultsofaChi-squaretestforassociationbetweenexposureandthevariablesummarizedinthatrow.Thefollowingprogramwillcreateadatasetcontainingfivevariablesdescribingthesefivecolumns.ForthefirststepPROCMEANSwillbecalledupontocreatethebasicsummarytobuildon.procmeansdata=DemoDatanoprintnsummean;classgenderregion;varexposure;ways1;outputout=PreTablen=sum=mean=/autoname;run;TheCLASSstatementinPROCME。

10、ANSiswhereyouplaceyourclassvariablesoverwhichyouwanttostratifyyouranalysisvariable.WhenmorethanonevariableisspecifiedintheCLASSstatementthestratificationoftheanalysisvariablewillbemadeoverallpossiblecrossingsoftheclassvariables.ThisbehaviorcanbemodifiedusingtheWAYSstatement.ThisstatementtellsPROCMEANShowmanyclassvariablestocombinetostratifyyouranalysisvariable.Sinceweonlywantoneclassvariableatatimea“1”isspecified.3Figure2displaystheresultfromtheabovecode.Figure2.ResultsfromPROCMEANSObsgenderregio。