Dear all, i would like to add fill pattern in some vbar (BTT group) using dattrmap with proc sgplot. Can you help me please for adding fill pattern in the code? please find my code (graph in file enclosed):   data attrmap; input id $ value $15. @22 fillcolor $10. @32 ; datalines; status Deceased (BTT) ygr status Deceased (DT) ygr status Transplanted bigb status Ongoing (BTT) bio status Ongoing (DT) bio ; run; /*ods select none;*/ ods graphics on; ODS GRAPHICS / RESET IMAGENAME = 'HistoDuration' IMAGEFMT =png HEIGHT = 5.2 in WIDTH = 6.2 in; ODS LISTING GPATH = '\\vcarapp010\Rapports\01 - Pivotal study\01-Report\07-Communication\01-Intern Communication\01-Site Activity Report\Graphs' ; ODS tagsets.sasreport13(ID=EGSR) gtitle; proc sgplot data=statuspatient dattrmap=attrmap; yaxis label='Support duration (days)' VALUES= (0 to 500 by 30); vbar patient/ barwidth=0.3 response=nbSupportDay group=status attrid=status nooutline discreteoffset=0.1 datalabel ; refline 180 / axis=y lineattrs=( color=darkgreen pattern=dash ); inset 'cumulative support duration= &supportDuration (year)' / position = topright; run;   Regards,       ... View more

Dear all, I try to create a report (doc) with tables and graphs but when i include a graph with proc report, line table appears in content (see line in red): Please find my code below ods rtf file='\\vcarapp010\Rapports\01 - Pivotal study\Report\ReportForAllPatients\SixMinWalktest_CPX_Test_Report.doc' dpi=300 contents=yes toc_data; ods noproctitle; ods escapechar='~'; footnote1 j=left "~S={preimage='\\vcarapp010\Rapports\03 - MATERIALS FOR REPORT\Logocarmat2.JPG'}" j=r 'Page ~{thispage}';/*/~{lastpage}*/ ods proclabel 'Chapter 1: Six minutes Walkin test '; proc report data= sixminuteWalkingTest2 nowd CONTENTS='Table 1.1 - Six minutes walking Test - Distance'; column INDEX Patient_Code preOp_value m1_value m2_value m3_value; define index / group noprint; break before index/ contents="" page; define Patient_Code / style={cellwidth=15%} "Patient"; define preOp_value / style={cellwidth=10%} "Pre-Op"; define m1_value / style={cellwidth=10%} "M1"; define m2_value / style={cellwidth=10%} "M2"; define m3_value / style={cellwidth=10%} "M3"; title1 "Study Code: CAR2016-01 / Date: &SYSDATE."; title2 'Table 1.1 - Six minutes walking Test - Distance'; run; data pt1; set sixminuteWalkingTest2; run; proc sort data=pt1; by index; run; data pt1; set pt1; by index; if last.index; keep index; run; data fmt; set pt1; fmtname = "mypic"; start =1; label = "\\vcarapp010\Rapports\01 - Pivotal study\Graphs\Histo_SixMinWalk.png"; keep fmtname label start; run; /* Create the format containing the links to the images. */ proc format cntlin=fmt; run; /* Create a format to blank out values in the column that will contain the image. */ proc format; value blank other=" "; run; ods listing close; data pt1; set pt1; index=1; run; ods rtf startpage=No; /*pour avoir un saut de page */ ods proclabel ' '; proc report data=pt1 nowd CONTENTS="Graph 1.2: Six minutes walking test Histogram" style(report)={background=white} style(header)={foreground=black background=white height=0} style(column)={just=right}; column index ('' image); define index / group noprint; break before index/ contents="" ; define image/ '' computed style(column)=[postimage=mypic. just=l cellwidth=7.0 in ] format=blank.; /* Set the computed variable equal to the variable */ /* value that matches the value in the $Mypic. format. */ compute image ; image = 1; endcomp; title1 "Study Code: CAR2016-01 / Date: &SYSDATE."; title2 "Graph 1.2: Six minutes walking test Histogram"; run; Thanks for you help,     ... View more

Dear all, I try to keep only the first 11 character from string with carriage return. ex:  "In progress. # 1 DCF[ CLOSED ] 02/03/2017 15:46Mr A. ADJE wrote null.and proposed value 999,999,999. 30/06/2017 11:10Mme  M. CANEAU wrote ok.and proposed value null. # 1 Notification. Change performed by Mme M. CANEAU on 30/06/2017 11:10 :ok-new  value: null"    Please find my sentence in my macro: %let fileDel2=%unquote(%sysfunc(getvarc(&tabid2,%sysfunc(varnum(&tabid2,&nomvar2)))));  %put &fileDel2;  %let nou=%substr(&fileDel2,1,11); %put &nou;   The log displays: In progress. # 1 DCF[ CLOSED ] 02/03/2017 15:46Mr A. ADJE wrote null.and proposed value 999,999,999. 30/06/2017 11:10Mme  M. CANEAU wrote ok.and proposed value null. # 1 Notification. Change performed by Mme M. CANEAU on 30/06/2017 11:10 : ok - new  value: null ERROR: Macro function %SUBSTR has too many arguments. ERROR: The macro KEEPMONITORTAB will stop executing.   If i perform directly on table without macro, it works. What can I do for that works also throught macro?   Thanks for your help ... View more

Dear all, i would like to perform the graph in attachments. I thought that it was possible usng Hbar with sgplot, but it does not. The problem is that some period are repeating (in this case "Home"). Do you think that it was possible with SAS v9.4? What procedure? Thanks for your support   ... View more