About DME790

DME790 · ‎09-21-2018

Hi All, I'm using Proc Template to change the style of an sgplot, however with the below code the border colors aren't changing and I need to know how to add the code in to change the color of the text to white. Proc Template; define style styles.defstyle; parent=styles.default; style body from body / backgroundcolor=white; class graphgridlines / contrastcolor=white; class graphbackground / color=dabg; class graphwalls / color=dabg; end; run; this is the current output any help appreciated.

DME790 · ‎08-22-2018

Hi @FredrikE @Jagadishkatam , I knew I made a mistake as soon as I ready your responses. I need to keep the column sorry - I don't want the heading second row that shows Number of Exits TotalJuly2017 Total201718 Cheers Dean

DME790 · ‎08-21-2018

Hi All, I have the following Proc Report code however I want to get rid of the second column with the heading name in it. Is there a way I can do this? Data Test; input CombinedCode $ TotalJuly2018 RankedJuly2018 TotalJuly2017 RankedJuly2017 Total201718 Ranked201718; datalines; AAA 2288 15 564 20 12071 12 BBB . . 9 76 77 76 CCC 776 31 180 33 2349 32 DDD 1593 19 549 21 7265 18 EEE 2827 12 887 14 10997 14 FFF 1395 20 1463 9 11864 13 GGG 439 36 109 39 1795 34 HHH 9873 6 3151 6 42898 6 III 11 68 31 63 60 77 JJJ 376 37 119 38 1465 37 KKK . . 25 70 138 71 LLL 7 69 9 76 49 78 MMM 4132 9 1105 12 15367 10 NNN 293 41 87 46 1087 41 OOO 1053 27 . . 987 44 PPP 473 35 126 37 1451 38 ; run; Proc Report data=Test; Column CombinedCode ('July 2018' ( TotalJuly2018,(pctsum) RankedJuly2018 TotalJuly2018)) ('July 2017' ( TotalJuly2017,(pctsum) RankedJuly2017 TotalJuly2017)) ('2017-18 Financial Year' ( Total201718,(pctsum) Ranked201718 Total201718)) ; Define CombinedCode / DIsplay; Define TotalJuly2018 / DIsplay 'Number of Exits' f=comma9.; Define RankedJuly2018 / DIsplay 'Ranking' order order=Internal; Define TotalJuly2017 / DIsplay f=comma9.; Define RankedJuly2017 / DIsplay; Define TotalJuly201718 / DIsplay f=comma20.; Define RankedJuly2017 / DIsplay; define pctsum / 'Percentage' format=percent7.1; rbreak after / ol summarize; run; which produces this and I would like Number of Exits, TotalJuly2017 and Total201718 not displaying in the report. any help appreciated. Cheers Dean

DME790 · ‎08-08-2018

@ChrisNZ Hey Chris - thanks for all your help it is much appreciated. I now have it all working. Cheers Dean

DME790 · ‎08-08-2018

@ChrisNZ Thanks for your help Chris - I moved the code over to my program and now it doesn't return anything - blank PDF paper. Going to rewrite my whole code as the code that you helped with works. If you are a Rugby supporter good luck in the Bledisloe Cup this year. Cheers Dean

DME790 · ‎08-08-2018

Hi @ChrisNZ I set the height and now it all fits onto a page. Can I ask what is the purpose of the ODS_ALL_ close; statement and why does it sit after the goptions and options. I thought this would cancel out anything above it? goptions dev=actximg; options papersize=A3 orientation=landscape leftmargin=1cm rightmargin=1cm; ods _ALL_ close; ods PDF file="%sysfunc(pathname(WORK))\results.PDF"; ods layout gridded columns=3 order_type=row_major column_gutter=1cm advance=output; ods region width=12cm height=8.cm ; Cheers Dean

DME790 · ‎08-08-2018

Hi @ChrisNZ, Thanks for your help on this one - I ran the code you tried and I don't get an error but the output ends up being on two pages - I have attached the PDF file. Could it be the 'printer' and/or settings that could play around with the settings?

DME790 · ‎08-06-2018

Hi @ChrisNZ, Thanks for the response. The below code I'm trying to assign the output to A3 size as the final output I need has 3 x 3 . Should I be using a different code to output to A3? opions papersize= ("11.69in", "16.54in") orientation=landscape; ods region width=6in; Cheers Dean

DME790 · ‎07-31-2018

Update, I have changed the code to the following. In Results - SAS Report view the graphs appear side by side. When you pen the PDF file the graphs are below each other. Any suggestions appreciated. ods PDF file="Test.PDF" notoc style=color; ods layout start columns=2; Options papersize= ("11.69in", "16.54in") orientation=landscape; ods region width=6in; ods graphics / width=6in height=3in; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Entered"; VBAR EVENT_DT / Response=ENTERED Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 150 by 10) offsetmin=0 label='Entered'; RUN; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Answered"; VBAR EVENT_DT / Response=ANSWERED Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 150 by 10) offsetmin=0 label='Answered'; RUN; ods region width=6in; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Abandoned"; VBAR EVENT_DT / Response=ABANDONED Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 150 by 10) offsetmin=0 label='Abandoned'; RUN; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Agent"; VBAR EVENT_DT / Response=Agent Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 50 by 5) offsetmin=0 label='Agent'; RUN; title; ods layout end; ods pdf close; Cheers Dean

DME790 · ‎07-31-2018

Hi all, I'm trying to use ODS PDF and ODS Layout Gridded to place graphs side by side on A3. I have the following code but the graphs are very small and they don't sit side by side. I have tried different code and this gets me close. Any help appreciated. data test; input event_dt :yymmdd. group $ Simplification $ ENTERED ANSWERED ABANDONED Agent; format event_dt yymmdd10.; DATALINES; 2018-07-09 AAA PreSimp 127 118 8 25 2018-07-10 AAA PreSimp 106 99 6 29 2018-07-11 AAA PreSimp 108 97 11 24 2018-07-12 AAA PreSimp 131 113 18 30 2018-07-13 AAA PreSimp 120 106 13 26 2018-07-16 AAA PreSimp 105 96 8 29 2018-07-17 AAA PreSimp 86 69 15 24 2018-07-18 AAA PreSimp 105 89 16 30 2018-07-19 AAA PreSimp 110 97 12 22 2018-07-20 AAA PreSimp 72 65 7 26 2018-07-23 AAA PreSimp 96 89 7 25 2018-07-24 AAA PreSimp 101 92 7 28 2018-07-25 AAA PreSimp 103 92 11 27 2018-07-26 AAA PreSimp 92 84 7 30 2018-07-27 AAA PreSimp 92 86 5 21 2018-07-30 AAA PostSimp 85 77 8 20 2018-07-30 AAA PostSimp 85 77 8 29 ; RUN; data attrmap; retain id "myid"; input value :&$10. fillcolor $8.; datalines; Pre Simp VIBG Post Simp BIBG ; run; ods PDF file="/sasdata/clk/dev/SERVPERFCO/SDPAGENUSER/BIS/Data/SASLib/0.Blended/CAR/misc/AAA_results.PDF"; options leftmargin=.5in rightmargin=.5in orientation=landscape nocenter; ods listing close; ods layout gridded columns=2 width=2in; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Entered"; VBAR EVENT_DT / Response=ENTERED Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 150 by 10) offsetmin=0 label='Entered'; RUN; ods layout gridded columns=2 width=2in; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Answered"; VBAR EVENT_DT / Response=ANSWERED Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 150 by 10) offsetmin=0 label='Answered'; RUN; ods layout gridded columns=2 ; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Abandoned"; VBAR EVENT_DT / Response=ABANDONED Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 150 by 10) offsetmin=0 label='Abandoned'; RUN; ods layout gridded columns=2 ; Proc SGPLOT data=test noborder dattrmap=attrmap; Title "Agent"; VBAR EVENT_DT / Response=Agent Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 50 by 5) offsetmin=0 label='Agent'; RUN; title; ods layout end; ODS PDF close; Cheers Dean

DME790 · ‎07-30-2018

Thanks @FreelanceReinh Works a treat Cheers Dean

DME790 · ‎07-30-2018

Hi All, I'm trying to use Attrmap and a proc format but they seem to cancel each other over. If I run the code without the format Simplification typeFmt. I get the green from the Attrmap - as expected - and legend = 0 (pic 1). If I run with format Simplification typeFmt. I loose the formatting from Attrmap and the legend = Pre trial (pic2) Is there a way I can have both - Attrmap and the proc format work together. Green columns from the Attrmap and a legend shows Pre trial and Post Trial. Data Attrmap; Retain id "myid"; input value $ fillcolor $8.; datalines; 0 VIBG 1 BIBG ; run; proc format; value typeFmt 0 = "Pre Trial" 1 = "Post Trial" ; ods graphics on / width=9in height=5in; Proc SGPLOT data=work.DSCMax noborder dattrmap=attrmap; */ format Simplification typeFmt.; VBAR EVENT_DT / Response=Max_answer_tm Group=Simplification attrid=myid nooutline seglabel seglabelattrs=(weight=Bold color=WHITE size=8 ); yaxis display=(noline noticks) grid values=(0 to 3600 by 300) offsetmin=0 label='mm:ss'; RUN; ODS graphics OFF; Apologies if the test data doesn't run - this is what it looks like though data test; Input CD EVENT_DT Group Simplification MAX_ANSWER_TM; Datalines; TSDa 2018-07-06 DSC 0 38:21 TSDa 2018-07-09 DSC 0 9:41 TSDa 2018-07-10 DSC 0 23:31 TSDa 2018-07-11 DSC 0 14:47 TSDa 2018-07-12 DSC 0 17:40 TSDa 2018-07-13 DSC 0 20:34 TSDa 2018-07-16 DSC 0 8:55 TSDa 2018-07-17 DSC 0 22:17 TSDa 2018-07-18 DSC 0 16:42 TSDa 2018-07-19 DSC 0 10:31 TSDa 2018-07-20 DSC 0 11:12 TSDa 2018-07-23 DSC 0 10:13 TSDa 2018-07-24 DSC 0 6:37 TSDa 2018-07-25 DSC 0 17:00 TSDa 2018-07-26 DSC 0 7:11 TSDa 2018-07-27 DSC 0 10:43 ; RUN; Pic 1 Pic 2

DME790 · ‎07-12-2018

Hi @Reeza, Apologies as I didn't read your response properly - I thought that was a question - now I know what you meant, replace day with weekday. I should have known better as your responses to queries are always very helpful. Regards Dean

DME790 · ‎07-11-2018

Hi @Astounding, The report is for weekdays only so don't want to return Saturdays or Sundays - am I right if I change the code to the below to remove Saturdays as well? data _null_; datevar = today() - 1; if weekday(datevar) = 1 then datevar = datevar - 2; else if weekday(datevar) = 7 then datevar = datevar - 1; call symputx('datevar', put(datevar, yymmddn8.)); run; Cheers Dean

DME790 · ‎07-11-2018

Hi @Reeza, I have never used IFC/IFN - can you show me an example or direct me to some help please. Ultimately I need to populate a Where statement like below. WHERE Date = "&DateVAR."d Thanks for your help. Cheers Dean

Online Status	Offline
Date Last Visited	‎08-04-2020 01:23 AM

Proc Append Monthly Data

Re: help with Merge

help with Merge

Re: Import CSV or a SAS EG file into SAS VA

Import CSV or a SAS EG file into SAS VA

Re: remove duplicates based on variables

remove duplicates based on variables

Re: Replace data in a table

Replace data in a table

Re: include missing metrics

Re: count of repeat contacts fromk previous days

Re: ODS PDF graph layout

Re: SGPLOT - Attrmap and Proc Format not working together

Re: return yesterdays date except on a Monday return the Friday date

Re: Change the names in alegend in an SGPLOT

Re: change the Y axis interval and max number on a SGPLOT

change the Y axis interval and max number on a SGPLOT

Re: Using a Date_Range Prompt in a Data Step SAS EG7.1

Using a Date_Range Prompt in a Data Step SAS EG7.1

Re: Import CSV or a SAS EG file into SAS VA

change the font and border color in SGPLOT

Re: Removing a column heading from a proc report

Removing a column heading from a proc report

Re: ODS PDF graph layout

Re: ODS PDF graph layout

Re: ODS PDF graph layout

Re: ODS PDF graph layout

Re: ODS PDF graph layout

Re: ODS PDF graph layout

ODS PDF graph layout

Re: SGPLOT - Attrmap and Proc Format not working together

SGPLOT - Attrmap and Proc Format not working together

Re: return yesterdays date except on a Monday return the Friday date

Re: return yesterdays date except on a Monday return the Friday date

Re: return yesterdays date except on a Monday return the Friday date