Yes but in your code I can't see the lower and upper bound. I would like to see in my dataset the bands because I see that the extreme values are not detected as outliers.   ... View more

How can I verify that the filter works? Showing the band lower and upper to check the outliers points? ... View more

I custom my code like that proc sgplot data=elapsed_long_perc noautolegend; /* Definizione dei colori personalizzati per ogni fascia */ styleattrs datacolors=(CREAM PAPPK BIOY VIGY VPAG); /* Creazione del barplot senza bordi */ vbarparm category=Fascia response=Percentuale / nooutline group=Fascia limitlower=max limitupper=min groupdisplay=cluster; *scatter x=Fascia y=Percentuale /datalabel=Percentuale datalabelpos=center markerattrs=(size=0); /* Aggiunta delle barre di errore con maggiore spessore */ highlow x=Fascia low=min high=max / lineattrs=(thickness=3 color=LTGRAY); /* Linea curva che segue i valori */ series x=Fascia y=Percentuale / smoothconnect lineattrs=(color=LIYBR thickness=2 pattern=solid); /* Personalizzazione degli assi */ yaxis label="Variazione Percentuale (%)" labelattrs=(size=14) valueattrs=(size=12); xaxis label="Frequenza pedonale annuale" discreteorder=data labelattrs=(size=14) valueattrs=(size=12); /* Aggiunta delle etichette ai valori */ text x=Fascia y=Percentuale text=Percentuale / position=left textattrs=(weight=bold size=12); scatter x=Fascia y=min /datalabel=min datalabelpos=center markerattrs=(size=0) datalabelattrs=(size=11 color=black);; scatter x=Fascia y=max /datalabel=max datalabelpos=center markerattrs=(size=0) datalabelattrs=(size=11 weight=bold color=white); /* text x=Fascia y=min text=min / position=bottomright textattrs=(size=10); */ /* text x=Fascia y=max text=max / position=topright textattrs=(size=10); */ /* Titolo del grafico */ title height=14pt "Variazione Elapsed medio rispetto a 2 volte all'anno"; run; And I obtained this plot Is there the offset option to move the percentage values a little bit? ... View more

Something like that   Or with tha bars like that In this last case can I modify the width of the line? ... View more

Thank you,   Is there a way to put the numbers inside the bars like that   ... View more

Is there a way to put the min and max values as well maybe smaller than the mean? ... View more

Thank you, it works! Is there a way to put the percentage values on top of the bar as well? Something like datalabel. ... View more

I am using this code proc sgplot data=elapsed_long_perc; /* Definisci i colori personalizzati per ogni fascia */ styleattrs datacolors=(LIO MOO STO GRRO DARO); vbarparm category=Fascia response=Percentuale / limitlower=max limitupper=min groupdisplay=cluster; series x=Fascia y=Percentuale / smoothconnect; /* Creazione del barplot con colori distinti per ogni fascia */ /* vbar Fascia / response=Percentuale datalabel */ /* group=Fascia */ /* datalabelattrs=(size=12); */ /* Personalizzazione degli assi */ yaxis label="Variazione Percentuale (%)" labelattrs=(size=14) valueattrs=(size=12); xaxis label="Frequenza pedonale annuale" discreteorder=data labelattrs=(size=14) valueattrs=(size=12); /* Titolo del grafico */ title height=14pt "Variazione Elapsed medio rispetto a 2 volte all'anno"; run; And I see this plot: Is there a way to put the colors manually? ... View more

How can I insert these con var x >= 2 <= 42; var y integer; con Mycon: x = 2 + 4*y; to this proc opt model proc optmodel; num a{1..2}=[2 12]; num b{1..3}=[2 12 24]; num d{i in 1..10}=i; num e{i in 1..47}=i; var var_a{1..2} binary; var var_b{1..3} binary; var var_c >=5 <=15; var var_d{1..10} binary; var var_e{1..47} binary; impvar sum=-8*sum{i in 1..2} a[i]*var_a[i] + -2*sum{i in 1..3} b[i]*var_b[i] + -2*var_c + -4*sum{i in 1..10}d[i]*var_d[i] + 2*sum{i in 1..47}e[i]*var_e[i] ; min obj=sum; con con_total:sum>=1; con con_a:sum{i in 1..2} var_a[i]=1; con con_b:sum{i in 1..3} var_b[i]=1; con con_d:sum{i in 1..10}var_d[i]=1; con con_e:sum{i in 1..47}var_e[i]=1; solve ; print a var_a ; print b var_b ; print var_c ; print d var_d ; print e var_e ; quit; @RobPratt  ... View more

How can I integrate that in the code of the proc optmodel above? @RobPratt  ... View more

Thank you @Ksharp, just to add more complexity, if I have a categorical variable in my table, for instance in the variable "e" is a string, can I minimize the function group by string variable? An optimization for each category. ... View more

If I would like to read the data from my dataset? ... View more