PROC REPORT- a better way to display data

1 By David-Erick Lafontant, report - A better WAY TO display DATA1 Outline ProcReport & ProcPrint Why ProcReport What else can proc report do? Examples Examples And More Examples2 Example DatadataCars;set ;run;428 obs15 variables 3 ProcReport & ProcPrint Procedures which allows one to display dataprocprintdata=cars (obs=5);var make model weight;run;procreportdata =cars(obs=5) nowd;columnmake model weight;run;4 Advantages of Knowing ProcReport Jobs Saves Time Reduces Coding Bypass many procedures Awesome display ITS JUST FUN! Resume 1 Name: Eddard StarkSkills: R Packes, C++, JAVA,SAS, Microsoft Word, Power Point,I have 25 Doctorate degreesI can work 23 hours a day $1/per hourResume 2 Name: Daenerys TargaryenSkills: PROC REPORT5 ProcReport ProcReport can do a lot more. ProcReport Combines: ProcPrint ProcSort ProcMeans ProcFreq ProcTabulate6 What else can ProcReport do?

2 Group a variable by its Values Transpose a variable (from long format to wide format) Summary Statistics Indentations Skip or add sentences before or after each group. Improvements to display (Colors, Highlighting) Basically can do lots of things normally done using =cars(obs=50) nowd ;columnMake Model MSRP Cylinders MPG_City;defineMake / display ;run;procreportdata =cars(obs=50) nowd ;columnMake Model MSRP Cylinders MPG_City;defineMake / Group;run;12 Transpose a variable procreportdata =cars(obs=50) nowd ;columnMake Model Origin MSRP MPG_City;defineMake / Group;defineModel / Group;defineOrigin / across;run;13 Transpose and group variablesprocreportdata =cars(obs=50) nowd ;columnMake Model origin, (MSRP MPG_City);defineMake / Group;defineModel / display ;defineorigin / across;run; 14 Skip a line or add a text after each groupprocreportdata =cars(obs=50) nowdout=haha;columnMake Model origin, (MSRP MPG_City);defineMake / Group;defineModel / display .

3 Defineorigin / across;ComputeafterMake;Line" Next Car";endcomp;run;Can put Either beforeor after15procreportdata=cars(obs=50) nowdout=haha;columnMake Model origin, (MSRP MPG_City);defineMake / Groupnoprint;defineModel / display ;defineorigin / across;ComputebeforeMake;Line@5 Make $50.;endcomp;run;Use a variable instead of a text16 Datacars2;setcars;by make;if +1; elseline + 0;run;procreportdata=cars2(obs=50) nowdout=haha;columnLine Make Model origin, (MSRP MPG_City);defineLine / groupnoprint;defineMake / Group; defineModel / display ;defineorigin / across;Computebeforea;lengthText $50;if Line = 1thentext = "This Car is Asian";elseif Line = 2thenText = "This Car is European ";elseIf Line = 3thenText = "I Love this car but I cannot afford it";elsetext = "If Oprah was here, each of us would get one";Line@1 Text $50.

4 ;endcomp;run;Add a Different Line after each groupData Step To create a variable called line which has a different value for each Make Create a variable called Text and allow a length of 50 Create a text for each group17procreportdata=cars2(obs=50) nowdout=haha;columnMake Model origin, (MSRP MPG_City);defineMake / Group; defineModel / display ;defineorigin / across;ComputebeforeMake;lengthText $50;if Make = "Acura"thentext = "This Car is Asian";elseif Make = "Audi"thenText = "This Car is European ";elseIf Make = "BMW"thenText = "I Love this car but I cannot afford it";elsetext = "If Oprah was here, each of us would get one";Line@1 Text $50.;endcomp;run;If possible bypass datastep1819procreportdata=cars(obs=50) nowdout=haha;columnMake Model origin, (MSRP MPG_City);defineMake / Group;defineModel / display ;defineorigin / across;breakafterMake / summarize ;run;Add Summary After display (sum) 20 summarize (sum) procreportdata=cars nowd;columnMake Origin,(MSRP MPG_City);defineMake / group;defineOrigin / across;run;procreportdata=cars nowd;columnMake Origin,(MSRP MPG_City);defineMake / group;defineOrigin / across;definemsrp/ sum;defineMPG_City/ sum;run;21 summarize (other statistics) procreportdata=cars nowd;columnMake Origin, (MSRP MPG_City);defineMake / group;defineOrigin / across;definemsrp/ median;defineMPG_City/ Mean;run.

5 Other statistics:Mean, Median, StdP90, Min, Max Sum , CV (coefficient of variation), T, PrTAny summary statistics obtainablein needs Procmeans when you can do thisprocreportdata =cars(obs=50) nowd ;Title"MSRP Summary Statistics";columnMake MSRP MSRP= MSRPN MSRP = MSRP meanMSRP =MSRPstdMSRP = MSRPminMSRP = MSRPmax;defineMake / Group;defineMSRP / analysissum noprint"Sum";defineMSRPN / analysisN "N" format=2.;defineMSRP mean/ analysismean"Mean";defineMSRPstd/ analysisstd "Std. Dev.";defineMSRPmin/ analysismin "Min";defineMSRPmax/ analysismax "Max";run;23procreportdata=cars(obs=50) nowd;columnMake origin, (MSRP MSRP=MSRPN MSRP=MSRP meanMSRP=MSRPstd);defineMake / Group;defineorigin / across;defineMSRP / analysissumnoprint"Sum";defineMSRPN / analysisN "N"format=2.;defineMSRP mean/ analysismean"Mean";defineMSRPstd/ analysisstd"Std.

6 Dev.";run;Summary Statistics under a transposed variable24 Highlighting values procformat; valuescoreTwo0< -15= 'lightgreen 20-26= 'lightred'; run;procreportdata =cars nowd ;columnMake Origin, (MSRP MPG_City);defineMake / group;defineOrigin / across;definemsrp/ mean;defineMPG_city/ median;computeMPG_City;calldefine(_col_, 'style',"STYLE=[BACKGROUND=scoretwo.]"); endcomp;run;25procformat; valuescoreTwo0< 'lightgreen'.001< 'lightred'; run;procreportdata=cars(obs=50) nowd;columnMake origin, (MSRP MSRP= MSRPN MSRP = MSRP meanMSRP = MSRPprt);defineMake / Group;defineorigin / across;defineMSRP / analysissum noprint"Sum";defineMSRPN / analysisN "N" format=2.;defineMSRP mean/ analysismean"Mean";defineMSRPprt/ analysisprt format=pvalue."P- value";computeMSRPprt;calldefine(_col_,' style',"STYLE=[BACKGROUND=scoretwo.)]

7 ]") ;endcomp;run;26 Back to Editorial display The following can be targeted both in groups or individually Headers: Denotes all column headers, including spanned headers. Columns: Denotes the cells in all the columns report : Denotes the structural, or underlying, part of the report Lines: Denotes all LINE statements in all COMPUTE blocks Summary: Denotes all of the default summary lines that are produced by a BREAK or an RBREAK statement Each of the above can be edited in: Border Font Background Colors More27procreportdata= Cars(obs=10) nowdstyle( report )=[background=greenstyle (column)=[background=yellow]style(header )=[background=pink];column(" "(Make)) (Type model Origin,(MsRPInvoice));DefineMake /"Make /(1)"grouporder= data ;definemodel /"Model /(3)" display ;defineType /"Type /(2)"group;defineOrigin /"Origin /(4)"across;defineMSRP /"MSRP /(5)" display ;defineINVOICE /"Invoice /(6)";run.

8 28procreportdata= Cars(obs=10) nowdstyle( report )=[background=green cellspacing=10style(column)=[background= yellow]style(header)=[background=pink];c olumn(" "(Make)) (Type model Origin,(MsRPInvoice));DefineMake /"Make /(1)"grouporder= data ;definemodel /"Model /(3)" display ;defineType /"Type /(2)"group;defineOrigin /"Origin /(4)"across;defineMSRP /"MSRP /(5)" display ;defineINVOICE /"Invoice /(6)";run;cellspacing/* the space between table cells, allows background to show */29procreportdata= Cars(obs=10) nowdstyle(header)=[borderstyle=solid just=centerfont_face=Arial font_size=8pt background=white cellpadding=12borderbottomcolor=black ] style( report ) =[borderstyle=solid frame=boxfont_face=Arial font_size=8pt just=left cellpadding=2]style(column)=[borderstyle =solid just=centerfont_face=Arial font_size=8pt background=white borderbottomwidth=1pt bordertopcolor=black].]

9 Edit Groups of Columnsframe = box /* outside borders: void, box, above/below, vsides/hsides, lhs/rhs*/rules = all /* internal borders: none, all, cols, rows, groups */cellpadding= 4pt /* the space between table cell contents and the cell border */background = color_list('bgT' ) /* table background color */30 Edit Individual ColumnsdefineMake /"Make /(1)"grouporder= data style(column)=[cellwidth= just=left] missing;definemodel /"Model /(3)"displaystyle(column)=[cellwidth= just=left] missing;defineType /"Type /(2)"groupstyle(column)=[cellwidth= just=left] missing;defineOrigin /"Origin /(4)"acrossstyle(column)=[cellwidth= ];defineMSRP /"MSRP /(5)"displaystyle(column)=[cellwidth= ];defineINVOICE /"Invoice /(6)"style(column)=[cellwidth= ];31 Questions??32