Dear all, I am new to SAS (coming from R) and i would like to sort boxplot by the median of the variable being plotted. The code i have generated using SAS Enterprise is the following: PROC SQL; CREATE VIEW WORK.SORTTempTableSorted AS SELECT T.Country, T.BUFF FROM WORK.QUERY_FOR_PROFITABILITY_MI as T WHERE BUFF BETWEEN -5 AND 5 ; QUIT; SYMBOL1 INTERPOL=BOXTJF VALUE=CIRCLE HEIGHT=1 MODE=EXCLUDE ; Axis1 STYLE=1 WIDTH=1 MINOR=NONE ; Axis2 STYLE=1 WIDTH=1 MINOR=NONE VALUE=(ANGLE=90) ; TITLE; TITLE1 "Box Plot"; FOOTNOTE; FOOTNOTE1 "Generated by the SAS System (&_SASSERVERNAME, &SYSSCPL) on %TRIM(%QSYSFUNC(DATE(), NLDATE20.)) at %TRIM(%SYSFUNC(TIME(), TIMEAMPM12.))"; PROC GPLOT DATA=WORK.SORTTempTableSorted ; PLOT BUFF * Country/ VAXIS=AXIS1 HAXIS=AXIS2 GRID ; /* ------------------------------------------------------------------- End of task code. ------------------------------------------------------------------- */ RUN; QUIT; %_eg_conditional_dropds(WORK.SORTTempTableSorted); TITLE; FOOTNOTE; GOPTIONS RESET = SYMBOL;%SYMDEL _CLIENTTASKFILTER; Is there a way to modify such code in order to get the desired order of the boxplots? Thanks for any help!
... View more