I am working on a dashbaord.  I have been following and using the code as noted in Mr Allisons's book: SAS/GRAPH Beyond The Basics.  (A FANTASTIC BOOK by the way!!!!).  The dashboard then will be output via ODS PowerPoint as that is the desired medium.  My issue is that I cannot seem to get the individual graph titles to appear in each GREPLAY section.  I have adjusted the individual pixel size of each graph output by applying the % of the total pixels size to the designated graph as outlined in the book.  But regardless of what I do I cannot seem to get the titles to appear.  I even have tried making the graph indivual pixel size smaller but no changes.  I believe I am missing a key concept/item, however I am at a loss.  Any assistance would be appreciated.  If looking to run the below code, first delete or comment out the PROC TEMPLATE code for the powerpoint set up (due to the background image) and then change the file name in the ODS output statement.  I left them in here in case it is something I am doing within these statements that is impacting my output.  Thank you.   /* reset all and set options/macros for later use */ goptions reset=all; goptions device=png; goptions display; %let titlesize=10; %let textsize=6.5; %let legendtitlesize=7; %let fnt='albany amt'; %let fntb='albany amt/bold'; /* delete gsreg catalog to start fresh*/ proc catalog c=work.gseg kill; RUN; /* PowerPoint Template */ /* Note other running this code will want to change or comment this piece out due to background image reference*/ PROC TEMPLATE; DEFINE STYLE MyPPStyle1; PARENT=styles.pearl; CLASS Body / /*fontfamily=calibri fontsize=12pt*/ BACKGROUNDIMAGE='/sasuserhome/nbkqsn7/DailyDashboard/PowerPoint.jpg'; /* CLASS Systemtitle / fontfamily=calibri fontsize=12pt fontweight=bold;*/ /* CLASS title / fontfamily=calibri fontsize=12pt fontweight=bold color=blue textdecoration=underline;*/ /* class usertext from systemtitle / just=c;*/ /* CLASS FOOTNOTE / fontfamily=calibri fontsize=12pt fontweight=bold color=blue textdecoration=underline;*/ END; RUN; /* Sample data to test the output */ DATA WORK.TESTING; INPUT letter $1 value; DATALINES; A 1 B 2 C 3 ; RUN; /* Create the graphs for the various metrics */ /*annotation dataset */ Data TITLEANNO; LENGTH function $8 color style $20 text $50; RETAIN xsys ysys '3' hsys '3' when 'a'; function='label'; position='5'; x=50; y=50; color='black'; size=22; style='Albany AMT'; text='Sample Header'; OUTPUT; RUN; /*create Header output */ /* the pixel size is determined by taking a % of the overall pixel size and applying. This graph is 42.5% by 5% of 1500 (wide) 1000 (height) */ goptions xpixels=637.5 ypixels=50; PROC GSLIDE anno=TITLEANNO name="mytitles"; RUN; /*create bar chart output for testing */ /* the pixel size is determined by taking a % of the overall pixel size and applying. This graph is 20% by 20% of 1500 (wide) 1000 (height) */ goptions xpixels=300 ypixels=200 gunit=pct htitle=5 ftitle="Albany AMT" htext=5 ftext="Albany AMT"; axis1 label=none value=none major=none minor=none; axis2 label=none; pattern1 v=s c=blue; PROC GCHART data=WORK.TESTING; TITLE /*height=8pt*/ "Simple"; vbar letter / type=sum sumvar=value nostats width=15 space=8 raxis=axis1 maxis=axis2 noframe name="check"; RUN; /* create series plot outpuit for testing */ /* the pixel size is determined by taking a % of the overall pixel size and applying. This graph is 42.5% by 30% of 1500 (wide) 1000 (height) */ goptions xpixels=637.5 ypixels=300; axis1 label=none value=none major=none minor=none; axis2 label=none; symbol1 value=dot h=3 interpol=join w=2 color=blue; PROC GPLOT data=WORK.TESTING; PLOT value*letter /haxis=axis1 vaxis=axis2 name="pipegph" noframe; RUN; /* Create template to hold outputs and PowerPoint ODS output */ ods listing image_dpi=300; goptions xpixels=1500 ypixels=1000; goptions cback=white; goptions border; OPTIONS ORIENTATION=LANDSCAPE; options nodate nonumber topmargin=.1in; ODS NOPROCTITLE; ods escapechar='^'; /*note others running will want to change this line of code*/ ODS POWERPOINT file='/sasuserhome/nbkqsn7/ContTowerTrend5.pptx' STYLE=MyPPStyle1 nogfootnote gtitle; ODS POWERPOINT LAYOUT=_NULL_; goptions gunit=pct htitle=&titlesize ftitle=&fntb htext=&textsize ftext=&fnt; TITLE; FOOTNOTE; PROC GREPLAY tc=tempcat nofs igout=work.gseg; TDEF dashbrd des='Dashboard' /* left side */ /* overall title whole page*/ 1/llx=5 lly=90 ulx=5 uly=100 urx=47.5 ury=100 lrx=47.5 lry=90 color=black /* volumes header */ 2/llx=5 lly=83 ulx=5 uly=88 urx=47.5 ury=88 lrx=47.5 lry=83 color=black /* pipe app disp graph */ 3/llx=5 lly=50 ulx=5 uly=80 urx=47.5 ury=80 lrx=47.5 lry=50 color=black /* total fund unit graph */ 4/llx=5 lly=25 ulx=5 uly=45 urx=25 ury=45 lrx=25 lry=25 color=black /* fund $ volume graph */ 5/llx=27.5 lly=25 ulx=27.5 uly=45 urx=47.5 ury=45 lrx=47.5 lry=25 color=black /* Total Dispos graph */ 6/llx=5 lly=3 ulx=5 uly=23 urx=25 ury=23 lrx=25 lry=3 color=black /* Dispos per Biz Day graph */ 7/llx=27.5 lly=3 ulx=27.5 uly=23 urx=47.5 ury=23 lrx=47.5 lry=3 color=black /* Right side */ /* Sppeds Header */ 8/llx=52.5 lly=95 ulx=52.5 uly=100 urx=97.5 ury=100 lrx=97.5 lry=95 color=black /* App To ICA Cycle Time graph */ 9/llx=52.5 lly=73 ulx=52.5 uly=93 urx=72.5 ury=93 lrx=72.5 lry=73 color=black /* ICA To Close Cycle Time Graph */ 10/llx=77.5 lly=73 ulx=77.5 uly=93 urx=97.5 ury=93 lrx=97.5 lry=73 color=black /* Aged 60 /90 graph */ 11/llx=52.5 lly=51 ulx=52.5 uly=71 urx=72.5 ury=71 lrx=72.5 lry=51 color=black /* Fund Cycle Time */ 12/llx=77.5 lly=51 ulx=77.5 uly=71 urx=97.5 ury=71 lrx=97.5 lry=51 color=black /* PERFORMANCE Header */ 13/llx=52.5 lly=45 ulx=52.5 uly=50 urx=97.5 ury=50 lrx=97.5 lry=45 color=black /* ICD On time */ 14/llx=52.5 lly=23 ulx=52.5 uly=43 urx=72.5 ury=43 lrx=72.5 lry=23 color=black /* COT Graphs */ 15/llx=77.5 lly=23 ulx=77.5 uly=43 urx=97.5 ury=43 lrx=97.5 lry=23 color=black /* Late Loan Ct */ 16/llx=52.5 lly=2 ulx=52.5 uly=22 urx=72.5 ury=22 lrx=72.5 lry=2 color=black /* Late Loan % */ 17/llx=77.5 lly=2 ulx=77.5 uly=22 urx=97.5 ury=22 lrx=97.5 lry=2 color=black; template = dashbrd; /* nn:abc nn = matches numbers in the greplay template abc = matches the names of the graph grsegs (ie, the name='abc' on the proc gchart, etc) */ treplay 1:mytitles 2:mytitles 3:pipegph 4:check 5:check 6:check 7:check 8:mytitles 9:check 10:check 11:check 12:check 13:mytitles 14:check 15:check 16:check 17:check des='' name="MyDB"; run; quit; ODS POWERPOINT CLOSE; ... View more

Hello, this is my first attempt to annotate a graph proceedure.  I am looking to label a individual endpoint.  In the below example I am using "wowididit" but this later would be replaced by the actual value.  I have created the annotation data set.  Then built the template for a Layout Datapanel view with a CLASSVAR (perhaphs this is my issue).  I am receiving no errors, however there also is nothing being annimated on the graphical output.  Any guidance or suggestions would be greatly appreciated.  Thank you.   /* make annotation dataset */ DATA SERIESANNO; LENGTH function style color $8. text $25.; RETAIN hsys xsys ysys "5"; function="label"; x=10; y=.60; position="3"; text="wowididit"; style="calibri"; color="bib"; size=6; OUTPUT; RUN; /* series graph template */ PROC TEMPLATE; DEFINE STATGRAPH SERIES_PLOT1_1; BEGINGRAPH /DATACOLORS=(yellow CX000A23 CX0073CF CXE31837 CXD1C9C0 CX00AD50) DATALINEPATTERNS=(4); ENTRYTITLE TEXTATTRS=(FAMILY="Calibri" SIZE=8pt)'ITP Completed In <= 10 Days' ; LAYOUT DATAPANEL CLASSVARS=(LOANPURPOSEGROUP) / rowdatarange=unionall ROWS=2 ROWAXISOPTS = (display=(tickvalues) linearopts=(tickvalueformat=PERCENT7.1) label=("ITP <= 10 Days") labelattrs=(FAMILY="Calibri" SIZE=8pt)) COLUMNAXISOPTS= (linearopts=(viewmax=10) label=("Loan Age In Calendar Days") labelattrs=(FAMILY="Calibri" SIZE=8pt)); SIDEBAR; discretelegend 'series' / TITLEATTRS=(FAMILY="Calibri" SIZE=8pt) ; ENDSIDEBAR;   LAYOUT PROTOTYPE; SERIESPLOT x=DAY_CT y=ITD_LT10_PCT / GROUP=APPDT_YYYYMM NAME='series' ; ANNOTATE; ENDLAYOUT;   ENDLAYOUT; ENDGRAPH; END; RUN; PROC SGRENDER DATA=WORK.CUMM_GRAPH_EXCL_CANC TEMPLATE=SERIES_PLOT1_1 SGANNO=SERIESANNO; RUN; ... View more

Hello, I have the below program where I have created a map output.  I also created 4 patterns as well as 4 catagories in my Proc Format statement.  My question is, instead of assigning a pattern can I assign a color depending on the underlying value.  so for low - < .25 I would like this to always be green and so on, with the .75 - high always be red.  Thank you.   DATA WORK.MYMAP; SET MAPSGFK.US; WHERE STATECODE NOT IN ('AK', 'HI'); RUN;   *create format for map output; PROC FORMAT; VALUE ITP low - < .25 = '< 25%' .25 - < .50 = '25 - 49 %' .50 - < .75 = '50 - 74%' .75 - high = '> 75%' ; RUN; PATTERN1 V=S c=green; PATTERN2 V=S c=yellow; PATTERN3 V=S C=blue; PATTERN4 V=S C=Red; PATTERN5 V=MS c=lightgrey;   PROC GMAP DATA=WORK.SALESKPI_APPLICATION_OUT1 MAP=WORK.MYMAP ALL ; BY LVL1_SALES_CHANNEL; ID STATECODE; BLOCK ITP_PD_PCT / DISCRETE WOUTLINE=1 COUTLINE=black CEMPTY=BLACK cblock=black blocksize=4 shape=cylinder xview=0.75 yview=-1.0 zview=3.5; label ITP_PD_PCT = 'ITP Past Due %'; FORMAT ITP_PD_PCT ITP.; RUN; QUIT; ... View more

Hello I have a dataset, the number of observations in it will vary frrom day to day.  I would like to be able to create a dataset from it where only the last 5 observations are output to a new dataset.  I will not have numerical column I could use.  The below is representative of the data set I wish to subset.  What would be the most efficient way to create a new data set with just the last 5 observations.  Thank you. DATA WORK.SET_1; INPUT YYMM $8. VAR2 $3. VAR3 $3.; DATALINES; 2016-01 A1 B1 2016-01 A2 B2 2016-01 A3 B3 2016-01 A4 B4 2016-02 A5 B5 2016-03 A6 B6 2016-04 A7 B7 2016-04 A8 B8 2016-04 A9 B9 run; ... View more