Thanks it worked with both methods ... View more

Thanks @Damo I will try that and leave a feedback ... View more

Hello draycut, hello RW9, thanks for the help, It unfortunately didn't work with your suggestions, I probably might have made a mistake some where in the code but I finally found a very easy way to solve the problem.   the issue is that I wanted to sort the listed items in my keylegend. Not using ascending or descending order as used in Sortorder (the Keylegend Statement).   I solved the problem this way: since I have set the order already in my attrmap while assigning colors to the bars. I just added an extra column to my attrmap which is Show = "Attrmap" this displays the legend items in the order which is defined in the Attrmap for a example if you assign colors this way using attrmap   data attrmap; input id $ value $10. @19 fillcolor $8. show $10.; datalines; flavor Vanilla beige     attrmap flavor Chocolate cx663D29  attrmap flavor Strawberry pink attrmap ; run;   this will display the items in your legend in this order vanilla, Chocolate, Strawberry ... View more

Thanks draycut for your reply am still trying to implement that but it hasn't worked yet. I hope am not making any mistake. I will let you know if it worked ... View more

Thanks RW9 for your reply am still trying to implement that in sgplot but it hasn't worked yet. I hope it works. ... View more

okay Sanjay, thanks for that ... View more

ok thanks for your reply ... View more

Hi Sanjay; sorry for repling so late. I was a little bit busy with some other issues. Here is the code for Program. The problem is that the width decreases with the number of bars. I do not want that, I want the width to be fix no matter the number of bars. I hope you can help. Thanks in advance proc import datafile= "saslibrary\test1.xls" out=test dbms=xls replace; getnames=yes; run; %macro report (); %do i = 501 %to 505 ; proc sgplot data=test pad=(bottom=5%); styleattrs datacolors=(red); yaxis grid type=discrete discreteorder=data; hbar sport_typ /response=count barwidth=0.8 missing datalabel = count; yaxis display=(nolabel) offsetmin=0.05 offsetmax=0.05; xaxis label='Number of Athletes' grid offsetmin=0.0 offsetmax=0.05; where rep_id = &i; run; title " "; %end; %mend report; %report (); ... View more

Hello Sanjay, sorry I was on holidays. I came back today and tried your suggestion but it didn't work. Is there any other way I can adjust the width? I will be glad if any one can help. Am just thinking of using if statement. To say if number of bars less than 4 then width=? else width =? but I haven't tried that yet. ... View more

Okay, thanks a lot. I will try that and let you know the outcome I have the offsetmin and offsetmax set to 0.05 does that have any influence on the width of the bars? yaxis display=(nolabel) offsetmin=0.05 offsetmax=0.05;   ... View more