Hello @JanosBecsi  I have been having trouble uploading new versions of macros to the website.  This is where the fixes need to be done in the program if you want to modify yours: It is basically just adding a when statement that will always be false so it'll never be picked, but if &ndata=0 the case syntax won't resolve in an error.     ... View more

Hello @MJAIN .  This would be a bit tricky.  The p-value is written using an ENTRY statement in GTL.  In order to italicize just the P in p-value you would need the entry statement to look something like: ENTRY textattrs=(style=italic) "p" textattrs=(style=normal) "-value:" ....; The parameter PVALHEADER is meant to be placed in directly as text in the ENTRY statement, but this can be used to our advantage to manipulate the ENTRY statement: %newsurv(data=sashelp.bmt,time=t,cens=status,class=group, pvalheader=Logrank" textattrs=(style=italic) " p" textattrs=(style=normal) "-value:) By using the double quotes in the parameter it will close off the text part of the ENTRY statement allowing for the textattrs to be applied to different pieces leading to the desired result:   ... View more

Too add more information it seems when I remove the TEXTPLOT from my GTL code the error goes away, so there is some kind of interaction going on there that I'm not seeing.  I don't even have a group variable in my TEXTPLOT. ... View more

This documentation is what I was following that said I could go either with the DATTRS option or the DISCRETEATTRVAR option: GTL reference    Either way, I removed the attribute map references from my GTL code and tried with the DATTRVAR instead and it resulted in the same error. I removed my LEGENDITEM statements as well just in case there was something there.  I didn't see any other statements with a NAME assignment option either, so I'm pretty lost on what's causing this. My dataset is just coordinates and an ID column basically for plotting.  My GTL code is: proc template; %if &nby=1 or %qupcase(&by_method)=PANELS %then %do; define statgraph _sunburst; begingraph / designheight=&GraphHeight.in designwidth=&GraphWidth.in backgroundcolor=&bg_color /**Turns the border around the plot off if border=0**/ %if %superq(border)=0 %then %do; border=false %end; subpixel=on; /*%do i = 1 %to %sysfunc(countw(%superq(_group_lvls),|)); %local fillcolor&i; %let fillcolor&i=%scan(%superq(colors),&i,%str( )); legenditem type=fill name="grp&i" / label="%scan(%superq(_group_lvls),&i,|,m)" fillattrs=(%if %sysevalf(%superq(fillcolor&i)^=,boolean) %then %do; color=&&fillcolor&i %end; %else %if %sysfunc(mod(&i,12))=0 %then %do; color=graphdata12:color %end; %else %do; color=graphdata%sysevalf(%sysfunc(mod(&i,12))):color %end;); %end; /* discreteattrmap name="attrs" / ignorecase=false; %do i = 1 %to %sysfunc(countw(%superq(_group_lvls),|)); value "&i" / fillattrs=(%if %sysevalf(%superq(fillcolor&i)^=,boolean) %then %do; color=&&fillcolor&i %end; %else %if %sysfunc(mod(&i,12))=0 %then %do; color=graphdata12:color %end; %else %do; color=graphdata%sysevalf(%sysfunc(mod(&i,12))):color %end;); %end; enddiscreteattrmap; /* discreteattrvar attrvar=_attrs_ var=group_lvl attrmap="attrs" ;*/ /* discreteattrvar attrvar=_attrs_ var=group_lvl attrmap="attrs" ; */ layout lattice / rows=&rows columns=&columns order=columnmajor opaque=false columngutter=5 rowgutter=5; sidebar / align=&Legend_Location ; discretelegend %do i = 1 %to %sysfunc(countw(%superq(_group_lvls),|)); "grp&i" %end; / title="&group_label" border=false location=outside autoalign=(bottom) opaque=false valueattrs=(size=&legend_font_size color=&font_color /*family="&font_family"*/) titleattrs=(size=&legend_font_size color=&font_color /*family="&font_family"*/) exclude=('') %if %qupcase(&Legend_Location)=RIGHT %then %do; across=1 %end;; endsidebar; *entry ' '; %do b = 1 %to &nby; %if %sysevalf(%superq(by)^=,boolean) %then %do; cell; cellheader; entry halign=center "%scan(%superq(_by_lvls),&b,|,m)" / valign=bottom textattrs=(size=&by_font_size color=&font_color weight=&by_font_weight/*family="&font_family"*/); endcellheader; %end; layout overlay / border=false opaque=false walldisplay=none aspectratio=1 xaxisopts=(type=linear display=none linearopts=(viewmin=&x_viewmin viewmax=&x_viewmax tickvaluefitpolicy=none) offsetmin=0.03 offsetmax=0.03) yaxisopts=(type=linear display=none linearopts=(viewmin=&&y_viewmin&b viewmax=&&y_viewmax&b minorticks=true minorgrid=true minorgridattrs=(pattern=1 color=greyef)) reverse=false); /**sunburst Polygons**/ polygonplot x=eval(ifn(_bylvl_=&b,x,.)) y=y id=r_id / display=(fill ) group=group_lvl; %if &box_outline=1 %then %do; seriesplot x=eval(ifn(_bylvl_=&b and ^missing(r_id),x,.)) y=y /group=r_id lineattrs=(%if %sysevalf(%qupcase(&box_outline_color)^=GROUP,boolean) %then %do; color=&box_outline_color %end; pattern=solid thickness=&box_outline_size) ; %end; /**Text Plot**/ %if &box_show_counts=1 %then %do; textplot x=eval(ifn(_bylvl_=&b,x_text,.)) y=y_text text=value / position=center splitjustify=center strip=true %if &rotate_text=1 %then %do; rotate=rotate %end; textattrs=(size=&count_font_size color=&font_color weight=&count_font_weight /*family="&font_family"*/); %end; endlayout; %if %sysevalf(%superq(by)^=,boolean) %then %do; endcell; %end; %end; endlayout; endgraph; end; %end; ... View more

I thought I could just use the DISCRETEATTRVAR statement in my GTL code: discreteattrvar attrvar=_attrs_ var=group_lvl attrmap="attrs" ; I'll give this a try ... View more

This page was helpful, thank you. I was hoping to find a tagattr that could turn the Locked part of a cell off/on. My company wants to make an Excel sheet that has some columns not editable and some that are. ... View more

Hello @JanosBecsi ,   There is a part of the macro that is updating numbers with proc SQL update statements using macro variable counts created in a datastep.  There are situations where no datasets are actually compared and so none of these numbers are created so the statement would look like: case  else  Normally with datasets compared there is a when clause for each dataset.  When no datasets are compared it can't create any when clauses so it creates the syntax error that you're seeing.  I have a newer version that I've made to try to avoid this situation that I will try to upload soon.   @Kurt_Bremser The macro internally uses PROC SQL a lot, which is where the error is coming from after the macro is called. ... View more

Wow that is slick. It worked very well even when I had multiple Sunburst plots in a lattice layout. Wish I had known about that option sooner. ... View more

Hello @PKristanto ; The Log-rank test is only available with the BY level variables in this macro.  E.g. if BY=ARM and you were getting KM values by arm you could then get a log-rank p-value comparing the arm strata. ... View more

Hello @3fatty , Sorry for the delayed response.  I haven't had as much time lately to peruse the communities page.  That's an interesting solution for the censor symbol.  You can remove the legend by putting LEGEND=%str( ) I believe.  You can remove just the legend of the censors by setting CENSORMARKERS=0. ... View more

Hello @user021 .  Unfortunately I haven't had time to update this macro lately.  The company I work for doesn't currently use this macro and I've been busy with my family and haven't had as much time to work on my personal macros.  I can try to take a look at adding the 95% CI of the mean (I think that's just +/- 1.96 STD correct?).  I think adding 95% CI for a proportion would be quite a bit more work given how the macro is constructed.  I think that would require getting the binomial CI for each level individually unless there's an option in PROC FREQ that I'm missing. ... View more