Download Free Medical Cleveland Clinic SAS Macros PowerPoint Presentation

Cleveland Clinic SAS Macros PowerPoint Presentation

DOWNLOAD MEDICAL POWERPOINT PRESENTATION

About This Presentation

Description : These are defalut macros to help and design better graphs in SAS systems.

Tags : SAS

Published on : Jan 31, 2020 | Views : 3319 | Downloads : 15

Shareable Url :

Embed Code :

Comment

Transcript

Slide 1-

SAS Graphical Macros February 17, 2016 Rocio Lopez
Slide 2-

Overview Color utility macros Annotation macros Template modification macros Graphical macros Where to find each macro
Slide 3-

Color utility macros
Slide 4-

Color utility macros Set of 10 macros to manage color names To initiate the macros in your current session you call the %COLORMAC macro To get help on any macro call the %HELPCLR macro %colormac; %helpclr(ALL|macro-name); This will print out help information to the log file
Slide 5-

%RGB %RGB(red, green, blue); Creates an RGB color name from the numeric RGB component values Example: %colormac; %put %rgb(255, 0, 0) is red; This will print out to the log: CXFF0000 is red
Slide 6-

%RGB You can run this macro from within SGPLOT, SGPANEL or GTL proc sgplot data=sashelp.class noborder; scatter x=height y=weight/ markerattrs=(color=%rgb(255, 0, 0) size=10 symbol=CircleFilled); run;
Slide 7-

Other available color utility macros https://support.sas.com/documentation/cdl/en/graphref/67881/HTML/default/viewer.htm#n0z9vlsy95ugxcn1qchqznw88m6e.htm
Slide 8-

Annotation macros
Slide 9-

SG Annotation Mechanism to add Text labels Lines and arrows Ovals/Circles Rectangles/Squares Polygons Images 2 main tasks to add these elements Create an SG annotation data set Modify the SG procedure to use this data set
Slide 10-

SG Annotation - Example data sgannodata1; infile datalines dlm='#'; length function $ 9 linecolor $ 4 shape $ 6 direction $ 3; input function x1 y1 x2 y2 height width linecolor shape direction ; datalines; rectangle # 50 # 50 # . # . # 30 # 40 # blue # # arrow # 51 # 50 # 30 # 35 # . # . # red # closed # out ; run; proc sgplot data=sashelp.class noborder sganno=sgannodata1 ; scatter x=weight y=height; run;
Slide 11-

SG Annotation Macros Set of 10 macros Can be used within a DATA to simplify the process of creating annotation observations
Slide 12-

SG Annotation Macros data sgannodata1; infile datalines dlm='#'; length function $ 9 linecolor $ 4 shape $ 6 direction $ 3; input function x1 y1 x2 y2 height width linecolor shape direction ; datalines; rectangle # 50 # 50 # . # . # 30 # 40 # blue # # arrow # 51 # 50 # 30 # 35 # . # . # red # closed # out ; run; data sgannodata2; %sgrectangle(x1=50, y1=50, height=30, width=40, linecolor="blue"); %sgarrow(x1=51, x2=30, y2=35, linecolor="red", shape="closed", direction="out"); run; =
Slide 13-

Axis break proc sgplot data=break noautolegend; highlow y=y low=zero high=x / group=y lineattrs=(thickness=3); xaxis integer offsetmin=0; yaxis min=0 max=4; run; proc sgplot data=break noautolegend; highlow y=y low=zero high=x / group=y lineattrs=(thickness=3); xaxis ranges=(1-3.5 9.75-11) integer offsetmin=0; yaxis min=0 max=4; run; Full height break. What if you want a break in the axis only?
Slide 14-

AXISBREAK macro Create graph as shown before %AXISBREAK uses an annotation polygon function to erase the full break %AxisBreak (Axis=X, low=3.5, high=9.75, dataout=anno, back=wall type=bracket); proc sgplot data=break noborder sganno=anno; scatter x=x y=y; xaxis ranges=(1 - 3.5 9.75 - 11) integer; yaxis min=0 max=4; run;
Slide 15-

Template modification macros
Slide 16-

Modifying Style Templates - Recap
Slide 17-

Modifying Graph Templates - Recap
Slide 18-

MODSTYLE Macro Allows you to easily make changes to style templates without accessing the code %modstyle(parent=listing, name=MyListing, type=CLM, NumberOfGroups=3, colors=magenta purple brown, linestyles=Solid ShortDash MediumDash); ods listing style=MyListing; proc lifetest data=sashelp.BMT plots=survival(atrisk=0 to 2500 by 500); time T * Status(0); strata Group; run;
Slide 19-

MODSTYLE Macro
Slide 20-

MODTMPLT Macro Allows you to easily make limited changes to graph templates without accessing the code title “MY TITLE”; %modtmplt(template=Stat. Lifetest.Graphics.ProductLimitSurvival, options=replace, steps=t); proc reg data=class plots(only)=fitplot; model weigh = height; run;
Slide 21-

MODTMPLT Macro
Slide 22-

Graphical macros
Slide 23-

CompactMatrixMacro (Author: Sanjay Matange) proc sgscatter data=safety; matrix asat alat alkph biltot; run; %CompactMatrixMacro(data=safety, var1=asat, var2=alat, var3=alkph, var4=biltot);
Slide 24-

NEWSURV Macro (Author: Jeff Meyers)
Slide 25-

NEWSURV Macro Call %newsurv(data=sashelp.bmt, time=T, cens=status, cen_vl=0, class=group, classref=ALL, /*class ref for HR*/ classdesc=Group, /*label for class var*/ classvalalign=left, /*alignment for class values*/ risklabellocation=above, risklocation=bottom, /*location of n at risk table*/ risklist=0 to 7 by 0.5, /*time values for n at risk*/ timelist=1 to 2 by 1, /*time values for which to display KM estimates */ timedx=Years, /*label to desribe time units on table*/ xmin=0, xmax=7, xincrement=0.5, xdivisor=365.25, /*manage x axis*/ ytype=ppt, /*y axis in percentage (pct) or proportion*/ xlabel=Time (Years), ylabel=Proportion Alive and Disease-Free, /*axis labels*/ symbolsize=6pt, linesize=2pt, color=BLACK BLUE RED, /*manage style */ title=General Example of a Kaplan Meier Plot Showing Multiple Options with SASHELP.BMT Dataset, width=9in, height=6in, gpath=&BaseDir,plotname=Ex7, plottype=png);
Slide 26-

NEWSURV Macro Examples
Slide 27-

NEWSURV Macro Examples
Slide 28-

NEWSURV Macro Also produces a table report of the information You can control what columns appear You can include more than 1 mode in the call/table You can export directly to RTF, PDF OR HTML
Slide 29-

FORESTPLOT Macro (Author: Jeff Meyers)
Slide 30-

FORESTPLOT Macro %forestplot (DATA=neuralgia, METHOD=LOGISTIC, /*logistic, phreg, km or binomial*/ LOGPROC=logistic, /*calculate ORs with logistic or genmod*/ EVENTCOV=pain, EVENT=Yes, /*event variable and event level*/ CATCOV=sex, CONTCOV=age, /*categorical and continuous vlists*/ MDISPLAY=cat1 cont1, /*which variables to displayed and their order*/ CATDISPLAY=2, /*display for cat vars, see documentation for options*/ XAXISTYPE=log, /*display log*/ LABEL=Odds Ratios, /*x-axis label*/ BY=TREATMENT, /*by var*/ T3PVAL=wald, /*type of test for type 3 p-value*/ DISPLAY=ev_t est_range pval, /*stats to display*/ CWEIGHTS=0.2 0.4 0.4, /*amount of plot space for labels graph & stats*/ gpath=&BaseDir,plotname=Ex8d,plottype=png);
Slide 31-

FORESTPLOT Macro %forestplot(DATA=sashelp.bmt, METHOD=KM, NMODELS=2, TIME=t, CENS=status, TIMEPOINT=1000, LABEL=Event-free Rate, TIMEDX=Days, CWEIGHTS=0.25 0.35 0.4, HEIGHT=6in, BY=|group, TDISPLAY=3, MTITLE=All Patients|, BYLABEL=|By Disease Group, SUBHEADER=1000 Day DFS, DISPLAY=EV_T est_range pval, MODPVAL=|logrank, SYMBOL=diamondfilled|circlefilled, SYMBOLSIZE=20pt|10pt, ERRORBARS=0|1, gpath=&BaseDir,plotname=Ex8l,plottype=png);
Slide 32-

EULER_MACRO %Euler_Macro ( n1=30, /*n for set 1 (n1 + ni = N1)*/ n2=20, /*n for set 2*/ ni=10, /*n for intersection only*/ skin=gloss);
Slide 33-

VENN Macro %venn(data = work.data, venn_diagram=4, /*# of sets to plot*/ cutoff=<0.3, /*cutoff for quantitative vars. Plots counts satisfying these statement*/ out_location=&BaseDir, outputfilename=Ex10a);
Slide 34-

GLTPIECHARTMACRO %GTLPieChartMacro(data=sashelp.prdsale, category=product, /*group var*/ response=actual, /*var that has value for area of slice. This is optional, if not included it would plot freq or pct of category var*/ dataskin=gloss, title=Actual Sales by Product, footnote=Data Set: SAShelp.prdsale, footnotefontsize=6);
Slide 35-

WHERE TO FIND THE MACROS
Slide 36-

ppt slide no 36 content not found
Slide 37-

ppt slide no 37 content not found
Slide 38-

QUESTIONS??
Slide 39-

Coming up Step-by-step examples of common graphs Please email me with suggestions! ODS Graphics Designer and Editor
Slide 40-

Thanks