Hello Is it possible to label only the end point on each series plotted on the y axis.  I have the below and would like only the end point for the previous months and then only the end/most current point labeled on the current month.  Thank you. PROC TEMPLATE; DEFINE STATGRAPH LateLoanCt; begingraph / subpixel=on; entrytitle 'Total FM Late Loan Units'; layout overlay / xaxisopts=(display=(ticks tickvalues)) yaxisopts=(griddisplay=off display=(ticks tickvalues)); SERIESPLOT X=Pipe_BusinessDayofMonth Y=MTD_Late / LINEATTRS=(COLOR=GREEN PATTERN=SOLID) LEGENDLABEL='MTD' name='a'; SERIESPLOT X=Pipe_BusinessDayofMonth Y=MO1_Late / LINEATTRS=(COLOR=GREY PATTERN=SOLID) LEGENDLABEL="&PREVMOE" name='b'; SERIESPLOT X=Pipe_BusinessDayofMonth Y=MO2_Late / LINEATTRS=(COLOR=BLUE PATTERN=SOLID) LEGENDLABEL="&PREVMOE2" name='c'; SERIESPLOT X=Pipe_BusinessDayofMonth Y=MO3_Late / LINEATTRS=(COLOR=RED PATTERN=SOLID) LEGENDLABEL="&PREVMOE3" name='d'; discretelegend 'a' 'b' 'c' 'd'/ location=outside halign=center valign=bottom; endlayout; endgraph; end; run; PROC SGRENDER DATA=WORK.ALLUPLATE1 TEMPLATE=LateLoanCt; RUN; ... View more

Hello.  I have the below Proc Report I have run, with a By group.  When I output to ODS PDF I would like each By group to be on its own page as opposed to 1 report which runs over the page.  Is it possible to do this?  The reason all the variables are DISPLAY is because of how I had to set this up.  Basically this is the final output from 4 different Proc Reports stacked on top of each other.  Thank you.   ODS PDF STARTPAGE=NOW; ODS LAYOUT gridded rows=1 columns=1 STYLE={backgroundcolor=white}; ODS REGION ; ods proclabel "Outflow Summary"; PROC REPORT DATA=WORK.OUTFLOWS_TOTALA style(HEADER)=[background=blue foreground=white font_weight=bold] CONTENTS=''; BY Metric NOTSORTED; COLUMN ('Total FM Outflow Summary' Metric Lvl2_FF_Region SOURCE MTD PrevDay PrevWk PrevMo PrevMo2 PrevMo3); DEFINE Metric / group style=[font_weight=bold]; DEFINE Lvl2_FF_Region / group; DEFINE Source / DISPLAY; DEFINE MTD / DISPLAY FORMAT=COMMA8.; DEFINE PrevDay / DISPLAY "&PREVDAY" FORMAT=COMMA8.; DEFINE PrevWk / DISPLAY "&PREVWKE" FORMAT=COMMA8.; DEFINE PrevMo / DISPLAY "&PREVMOE" FORMAT=COMMA8.; DEFINE PrevMo2 / DISPLAY "&PREVMOE2" FORMAT=COMMA8.; DEFINE PrevMo3 / DISPLAY "&PREVMOE3" FORMAT=COMMA8.; COMPUTE Source; if SOURCE='' then call define (_row_,'style','style=[background=lightgrey font_weight=bold]'); ENDCOMP; BREAK BEFORE Metric / CONTENTS='' page; RUN; ODS LAYOUT END; ODS PDF CLOSE; ... View more

I have the below proceedure.  I have sorted the x axis variable in decending order, it shows in the correct descending order in the dataset.  However when I run the Proc Template and subsequent Proc Sgrender steps the x axis is resorted in ascending order.  How can I keep the descending order.  Thank you. PROC SORT DATA=WORK.ALLUP_PIPEHIST OUT=WORK.ALLUP_PIPEHIST1; BY DESCENDING TIME_REF ; FORMAT Pipe_Ct comma8.; RUN; *create bar chart of pipeline; title; footnote; PROC TEMPLATE; DEFINE STATGRAPH Pipe_App_Disp; begingraph / DATACOLORS=(blue grey); entrytitle 'Pipe / App / Disp History'; layout overlay / xaxisopts=(display=(ticks tickvalues)) yaxisopts=(griddisplay=off); barchart x=TIME_REF y=Pipe_Ct /group=SOURCE stat=sum GROUPDISPLAY=STACK dataskin=crisp BARWIDTH=.5 BARLABEL=TRUE BARLABELATTRS=(color=black weight=bold ); discretelegend 'a' / TITLE='Source:'; endlayout; endgraph; end; run; PROC SGRENDER DATA=WORK.ALLUP_PIPEHIST1 TEMPLATE=Pipe_App_Disp; RUN; ... View more

Hello Is there a way to set the begining Y axis value in PROC SGPLOT. My minimum value is 1200 in the below and as a result my Y Axis begins with the number 1200, however the ask from the client is to set the Y axis point lower, realizing this will generate more white space.  Thank you.   PROC SGPLOT DATA=WORK.HEAPPS_6; SERIES X=AppMonth_BusDay Y=App5dayAvg / LINEATTRS=(COLOR=BLUE PATTERN=SOLID) LEGENDLABEL='Total 5/Day Avg'; SERIES X=AppMonth_BusDay Y=Forecast / LINEATTRS=(COLOR=BLUE PATTERN=SHORTDASH) LEGENDLABEL='Total FC'; KEYLEGEND / ACROSS=1 DOWN=1 LOCATION=INSIDE POSITION=TOP; XAXIS LABEL='Month And Business Day' LABELATTRS=(WEIGHT=BOLD FAMILY=Courier); YAXIS TYPE=LINEAR; YAXIS LABEL='5 Day Application Avg' LABELATTRS=(WEIGHT=BOLD FAMILY=Courier); TITLE BOLD 'HE Application Inflow' FONT=Courier; WHERE (APP_MO >= month(&M1EDTE)) AND (APP_MO <= month(&AODTE)) ; RUN;   ... View more

Hello, I was reading the information at the below link for positioning multiple graphs on one PDF page.  I have 2 questions.  Is the approach outlined in the link below (using horgin= and vorgin=) will that work as well for Proc Tabulate or Proc Means outputs?  Then secondly is there any advantage gained in control of th eset up using ODS PowerPoint vs ODS PDF.  Thank you.   http://support.sas.com/documentation/cdl/en/graphref/67881/HTML/default/viewer.htm#p0wtchgwnh41ctn1xcu6pfx4geqm.htm   ... View more

Good Afternoon, I am looking to set the colors of each individual pice slice based on the catagory value (Alignment).  Is there a means to do or control this.  Below is a example of the code I am utilizing.  Thank you. PROC TEMPLATE; DEFINE STATGRAPH PIPEPIE; BEGINGRAPH; ENTRYTITLE 'Current Pipeline Distribution'; ENTRYFOOTNOTE ' As of '; layout region; piechart category=Alignment response=PERCENT1 / dataskin=crisp datalabellocation=outside; endlayout; endgraph; end; run;   PROC SGRENDER DATA=WORK.PIPE_PIE1 template=PIPEPIE; RUN; ... View more