Hello @Sara614, This macro does not have a functionality to show the top X% of results unfortunately. ... View more

Hello @Smokeman75, This macro is considered open source and is not validated.  It has been used extensively during my time at Mayo Clinic where results have been double checked for manuscripts and analyses, but there's no official validation documentation. ... View more

Hello @rmorgenstern, This option can be set with the PCTDISPLAY parameter.  Set this to either COL or ROW to get the percentages you want. ... View more

Thank you for pointing me towards the VVALUEX function. I was not aware of this function before.  I was able to make it work with a slight modification: if input(vvaluex('last.'||strip(vname(container(i)))),12.0)=1 then output; Thank you much! ... View more

First of all, no need to be condescending when you're not adding any information valid to the question at hand.  I gave all of the information needed and the part of the log is the only item relevant to the question.  If you really want to see the whole log for some reason and want to see the logical reason why I did not copy the entire thing, here you go.  The issue is caused the the exact item that I was asking the question about to begin with and I prefer not to take up an entire monitor screen to show unnecessary information.   The primary question again is: why does 'last.container1'N work but nliteral('last.container1') not work?   1 %_eg_hidenotesandsource; 5 %_eg_hidenotesandsource; 33 34 35 data test; 36 set meta; 37 by container:; 38 39 array container $ container:; 40 do i=1 to dim(container); 41 if nliteral('last.'||strip(vname(container(i))))=1 then output; 42 *if 'last.container1'N then output; 43 end; 44 run; NOTE: Character values have been converted to numeric values at the places given by: (Line):(Column). 41:12 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=INIT container1=BEGINGRAPH1 container2= container3= container4= Panel=0 ID=0 function1=BEGINGRAPH function2= function3= req1= req2= op1=DESIGNHEIGHT=10in opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=1 LAST.container1=0 FIRST.container2=1 LAST.container2=1 FIRST.container3=1 LAST.container3=1 FIRST.container4=1 LAST.container4=1 _I_=. i=5 _ERROR_=1 _N_=1 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=INIT container1=BEGINGRAPH1 container2=LATTICE1 container3= container4= Panel=0 ID=0 function1=LATTICE function2= function3= req1= req2= op1= opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=1 LAST.container2=0 FIRST.container3=1 LAST.container3=1 FIRST.container4=1 LAST.container4=1 _I_=. i=5 _ERROR_=1 _N_=2 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=addPanel container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4= Panel=0 ID=0 function1=LATTICE function2= function3= req1= req2= op1=ROWS=2 opt2=COLUMNDATARANGE=UNION opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=1 LAST.container3=0 FIRST.container4=1 LAST.container4=1 _I_=. i=5 _ERROR_=1 _N_=3 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=COLUMNAXES1 Panel=0 ID=0 function1=COLUMNAXES function2= function3= req1= req2= op1= opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=1 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=4 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=COLUMNAXES1 Panel=0 ID=1 function1=COLUMNAXIS function2= function3= req1= req2= op1=Type=Linear opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 2 The SAS System 10:40 Wednesday, February 7, 2024 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=5 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=COLUMNAXES1 Panel=0 ID=1 function1=COLUMNAXIS function2=LINEAROPTS function3= req1= req2= op1=MINORTICKS=TRUE opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=1 _I_=. i=5 _ERROR_=1 _N_=6 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=addPanel container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY1 Panel=1 ID=0 function1=OVERLAY function2= function3= req1= req2= op1=WALLDISPLAY=none opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=1 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=7 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY1 Panel=1 ID=0 function1=OVERLAY function2=YAXISOPTS function3= req1= req2= op1=Type=Linear opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=8 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY1 Panel=1 ID=0 function1=OVERLAY function2=YAXISOPTS function3=LINEAROPTS req1= req2= op1=MINORTICKS=TRUE opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=9 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=scatter container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY1 Panel=1 ID=1 function1=SCATTER function2= function3= req1=X=xvar req2=y=yvar op1=group=groupvar opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=10 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=scatter container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY1 Panel=1 ID=1 function1=SCATTER function2=MARKERATTRS function3= req1= req2= op1=Symbol=circleFilled opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=1 _I_=. i=5 _ERROR_=1 _N_=11 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. 3 The SAS System 10:40 Wednesday, February 7, 2024 NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=addPanel container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=0 function1=OVERLAY function2= function3= req1= req2= op1=WALLDISPLAY=none opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=1 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=12 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=0 function1=OVERLAY function2=YAXISOPTS function3= req1= req2= op1=Type=Linear opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=13 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=0 function1=OVERLAY function2=YAXISOPTS function3=LINEAROPTS req1= req2= op1=MINORTICKS=TRUE opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=14 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=scatter container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=1 function1=SCATTER function2= function3= req1= req2= op1=X=xvar opt2=y=yvar opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=15 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=scatter container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=1 function1=SCATTER function2=MARKERATTRS function3= req1= req2= op1=Symbol=circleFilled opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=16 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=series container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=2 function1=SERIES function2= function3= req1= req2= op1=X=xvar opt2=y=yvar opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=17 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=series container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=OVERLAY2 Panel=2 ID=2 function1=SERIES function2=LINEATTRS function3= req1= req2= op1=Pattern=SOLID opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= 4 The SAS System 10:40 Wednesday, February 7, 2024 opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=1 _I_=. i=5 _ERROR_=1 _N_=18 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=SIDEBAR1 Panel=0 ID=0 function1=SIDEBAR function2= function3= req1= req2= op1=Align=RIGHT opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=1 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=19 NOTE: Invalid numeric data, '"last.container1"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container2"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container3"N' , at line 41 column 12. NOTE: Invalid numeric data, '"last.container4"N' , at line 41 column 12. WARNING: Limit set by ERRORS= option reached. Further errors of this type will not be printed. Macro=linearAxis container1=BEGINGRAPH1 container2=LATTICE1 container3=LATTICE2 container4=SIDEBAR1 Panel=0 ID=1 function1=ENTRY function2= function3= req1= req2= op1="Label Text" opt2= opt3= op2= opt4= opt5= op3= opt6= opt7= op4= opt8= opt9= op5= opt10= opt11= op6= opt12= opt13= op7= opt14= opt15= op8= opt16= FIRST.container1=0 LAST.container1=0 FIRST.container2=0 LAST.container2=0 FIRST.container3=0 LAST.container3=0 FIRST.container4=0 LAST.container4=0 _I_=. i=5 _ERROR_=1 _N_=20 NOTE: There were 22 observations read from the data set WORK.META. NOTE: The data set WORK.TEST has 0 observations and 36 variables. NOTE: DATA statement used (Total process time): real time 0.01 seconds cpu time 0.00 seconds 45 46 %_eg_hidenotesandsource; 60 61 62 %_eg_hidenotesandsource; 65 ... View more

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