To my knowledge there is no default option to build a legend vertically. It would require you to manually make it using something like a layout gridded combined with Entry statements (which have a rotate option) with legend items that match your graph. You would have to set the valueattrs to be size 1 and white to hide the normal legend text. This would be more complicated if not doing a bar or scatter plot as a line legend for series would also not be rotated and you would have to use annotation (drawline) to do so. If I have free time later I can make an example. ... View more

Can you clarify? You want the text running vertically or you want the items in the legend to be in rows instead of columns? ... View more

Hello @Kc2     The ID parameter determines what is used to merge and compare rows in datasets. The more ID variables you list the more detailed the comparison gets. The macro is designed to look through the list left to right and only grab the variables that are in the current dataset, so you don't have to worry about finding variables in every dataset. ... View more

Hello. I wasn't telling you that you had to do a KM analysis. I described a method you could use to overlay the plots with each other so you could try the same method with your code. It's not a survival analysis exclusive method. ... View more

I'm sure there are more elegant solutions, but one that comes to mind for me in these situations is to just duplicate the dataset. Set the dataset into itself twice using the in operators to separate the two versions. Then in one of the versions make the category variable equal to "Overall" for all values. Then it just becomes another "stratification level" to the graph. E.g. Data bmt; Set sashelp.bmt (in=a) Sashelp.bmt (in=b); If a Then group="Overall"; Run; Proc lifetest data=bmt; Strata group; Time T*status(0); Run; The calculated statistics aren't all valid anymore but the graph part doesn't care. I think you can still use your strata code to make the graph and it will just have another level for counts. ... View more

Hello @Sylvain2 . I developed this macro originally in SAS 9.3 I believe, and used it at my prior job through SAS 9.4m5. To my knowledge nothing significant changed in ods or output tables from 9.4m5 to 9.4m7 so it should work the same. My new job since then uses a different table generator for TFLs so I have not used or updated this macro in some years now. Breaking the macro would generally require variables changing names in output or ODS tables, so that is that I would watch out for. ... View more

So as an example lets say that we're creating a figure for FDA submission.  I'm developing an in house macro to make something like a line plot.  The program the user runs to create this line plot looks like this:   data xx;   set adam.stuff;   programming stuff; run; other programming statements;   %glineplot(parameter stuff to make the plot);   My graphing macros will save the code they create (any prep steps, GTL code, SGRENDER code) to a separate file so that when time comes to submit to the FDA we don't have to go back and paste in the graphing macro code into the program.  The FDA requires us to either nest the macro or print the code directly into the program.  I'm trying to save on that step.  What I can't do is collect the code prior to the macro running (data XX.... stuff above).  I'm trying to find a way to extract that code and paste it into the separate file with the generated code so it includes everything in one shot. ... View more

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