Hello everybody, My first time asking a question in this forum, I have a couple of figures made in Excel that I try to move to SAS EG for more automatic handling. Unfortunately I got stuck on a couple of figures. What they has In common is that they use the same numeric variable across different groups. What I want is to use the same variable twice over different groups each with different attributes such as color and marker symbol. This is what I want (From Excel): My initial Dataset looks like this. I want to plot the Avg and Rek variables over the Sek variable. For this I try to use SGPanel, “panel by” Sek and two series Avg and Rek. I use an Attributemap where the Sek variable as the value I tried many different approaches. The closest I get is when I make a copy of the Sek variable (Sek2) since only one Attrid can be assigned to variable. More over I created an additional grouping variable GroupAvg or GroupRek so I can group on this variable and use the Sek variables to control the attributes. This gives the names in the legend correct. proc sgpanel data=omsattnig2 dattrmap=MyAttrMap;
panelby sek / noborder nowall noheaderborder spacing=50
headerbackcolor=white headerattrs=(family=Arial size=16pt) novarname
headerbackcolor=white headerattrs=(family=Arial size=16pt) novarname;
series X=year y=Avg / markers markerattrs=(size=15) lineattrs=(thickness= 4)
group=GroupAvg grouplc=sek lcattrid=myregavg groupmc=sek mcattrid=myregavg groupms=sek msattrid=myregavg;
series X=year y=Rek / markers markerattrs=(size=15) lineattrs=(thickness = 4)
group=GroupRek grouplc=sek2 lcattrid=myregrek groupmc=sek2 mcattrid=myregrek groupms=sek2 msattrid=myregrek;
rowaxis display=(nolabel noticks) valueattrs=(family=Arial size=12pt /*weight=bold*/) values=(0 to 14 by 2)
grid gridattrs=(thickness=2) offsetmin=0 offsetmax=0;
colaxis display=(nolabel noticks) valueattrs=(family=Arial size=12pt /*weight=bold*/)
fitpolicy=rotate valuesrotate=vertical offsetmin=0;
keylegend / title='' noborder position=top valueattrs=(size=12pt) autoitemsize across=4 ;
format Avg Rek SPf.;
run; The only remaining problem is that The legend only showing one of the attribute sets. Probably because this is the same variable and this is the last one Maybe I misunderstood or overcomplicate things but I really starting to get out of ideas. Hope I made myself clear, a little hard to explain. Any help is appreciated. I’m on version 7.15 of EG Best regards!
... View more