topic Re: legend with count (n) in New SAS User

legend with count (n)

somkamalin — Thu, 06 Dec 2018 22:15:22 GMT

I have variables trt and trt(n=200). In mean plot automation process (GTL), I want to apply discreteattribmap from dataset to trt which is already there in input dataset but want to display only trt(n=200) in legend. trt(n=200) is generated while running GTL which i cant assign attrimmap before running code. I tried with linecolor = trt. in series plot. .It displayed both trt, trt(n=200). but only want trt(n=200) in legend.. Can any one help me?.

Re: legend with count (n)

ballardw — Thu, 06 Dec 2018 23:49:01 GMT

I think that you will need to show at a minimum your existing GTL code and the Proc Sgender used to create the graphs.

Possibly example data as well.

Since " trt(n=200)" is an unlikely variable name it isn't clear exactly what this is supposed to represent when you say "I have variables trt and trt(n=200). "

Re: legend with count (n)

somkamalin — Fri, 07 Dec 2018 00:32:39 GMT

sorry for the confusion. trt variable takes character values 'Drug A' and
trt(n=200) is not variable name . You can rename it as trtn which takes
value 'Drug A (n=200)'.. I will send the code shortly.

Re: legend with count (n)

somkamalin — Fri, 07 Dec 2018 02:03:37 GMT

output is attached. discreteattribmap working for scatter but not matching with line color from 'line' of series plot. I need line,symbol color,symbol shape need to merged in legend and plot. can anybody help?

trt= 'Drug A' or 'Drug B'

trtn= 'Drug A(n=200)' or 'Drug B(n=230)'

proc template;
define statgraph order;
begingraph;
layout overlay/yaxisopts=(label="Concenration mg/L")
xaxisopts=(label="Week");
ScatterPlot
X=ndy Y=meancon / GROUP=trt NAME="scatter"
YErrorLower=EVAL(meancon-stdcon)
YErrorUpper=EVAL(meancon+stdcon);
SeriesPlot X=ndy Y=meancon / GROUP=trtn name = 'line' ;
mergedlegend 'scatter' 'line' / ;
;
EndLayout
;
EndGraph
;
END;
RUN;

ods rtf file = 'C:\Users\sasgraph_lib\meanplot1.rtf' style = mystyle;
PROC SGRENDER DATA=pk2 dattrmap = sym TEMPLATE=order
; dattrvar trt ='kk' ;
RUN;

quit;

ods rtf close;
ods listing;

Re: legend with count (n)

somkamalin — Fri, 07 Dec 2018 14:46:36 GMT

main aim is to : 1. color , shape of line , symbol with "trt" from discreteattribmap applied to trt .

2. make legend with trtn which has count as above.

3. line and symbol merged in legend.

Can anybody give hint or suggestion on this ?. Thanks.

Re: legend with count (n)

ballardw — Fri, 07 Dec 2018 15:47:25 GMT

Why do you have two different group variables if they should display as a single item on the legend?

All the examples if find using MERGEDLEGEND show use of the same GROUP variable.

Re: legend with count (n)

somkamalin — Fri, 07 Dec 2018 16:32:45 GMT

trt is from input data set which i am assigning discreteattribmap for color , symbol, line type. But trtn generated during GTL run which I cant assign discreteattribmap beforehand. only difference between them is suffix count. I need only legend with trtn. Main aim is to get discreteatribmap directly from input data set.

Re: legend with count (n)

somkamalin — Wed, 12 Dec 2018 22:01:21 GMT

No response yet.