Hi all,  I have a  table that looks like this : id date var1 var2 var3 3 06.01.81 2.5 50 40 3 15.11.88   20 50 3 18.08.89   18 60 3 11.12.90 10.78 190 70 10 06.10.90   350 80 10 16.10.98   184 90 10 17.10.95 1.65 79 100 10 18.10.85   367 110 10 19.10.66   500   10 20.10.98   497   10 21.10.77   600     I want sas to  obtain the last known value if the next known is missing. This should take place within the same id so that my tables looks like this at the end   id date var1 var2 var3 3 06.01.81 2.5 50 40 3 15.11.88 2.5 20 50 3 18.08.89 2.5 18 60 3 11.12.90 10.78 190 70 10 06.10.90 . 350 80 10 16.10.98 . 184 90 10 17.10.95 1.65 79 100 10 18.10.85 1.65 367 110 10 19.10.66 1.65 500 110 10 20.10.98 1.65 497 110 10 21.10.77 1.65 600 110  any help? ... View more

Dear all,  I have a plot that looks like this: I wish to insert the percentages in the graph and the keylegend should just be one or two lines outside the graph. I used across=2 but it isn't working. Any help? proc sgplot data = mydata dattrmap= myattrmap pad=(bottom=5%) noautolegend noborder; xaxis grid type=discrete discreteorder=data; vbar year / response=frequencies group = mygroup attrid=mygroup barwidth=0.9 missing ; xaxis display= (nolabel) valueattrs=(family="verdana" size=8pt) fitpolicy=rotate ValuesRotate=Vertical; yaxis display= (nolabel) valueattrs=(family="verdana" size=8pt); keylegend / location=outside position=bottomright across=2 title="" valueattrs=(size=10 family="verdana") outerpad=(top=0.2cm) noborder; run; ... View more