Help using Base SAS procedures

Proc Gchart

Reply
Occasional Contributor
Posts: 15

Proc Gchart

Hi!

I have some problems with Proc Gchart.

As you see in the attached graph, the biggest bars are at the top of the graph but I rather want the biggest bars at the bottom of the graph

For example, I want the orange bar to be at the bottom of the graph, does anyone know how I can manage to do that?

I have created the graph in enterprise guide, but I’ll attach the code that generates the graph and hopefully someone can solve my problem with code.

Best Regards

Hannes

proc gchart.JPG

PROC SQL;

    CREATE VIEW WORK.SORTTempTableSorted AS

        SELECT T.AAA, T.Arb_Totalt_red

    FROM WORK.QUERY_FOR_VECKOARBETSTID_HE_0000 as T

;

QUIT;

    PATTERN1 COLOR=CXFF9900;

    PATTERN2 COLOR=BLUE;

    PATTERN3 COLOR=RED;

    PATTERN4 COLOR=YELLOW;

    PATTERN5 COLOR=CX339966;

    PATTERN6 COLOR=CXFF9900;

    PATTERN7 COLOR = _STYLE_;

    PATTERN8 COLOR = _STYLE_;

    PATTERN9 COLOR = _STYLE_;

    PATTERN10 COLOR = _STYLE_;

    PATTERN11 COLOR = _STYLE_;

    PATTERN12 COLOR = _STYLE_;

Legend1

    FRAME

    POSITION = (MIDDLE RIGHT OUTSIDE)

    LABEL=(   "Legend")

    ;

Axis1

    STYLE=1

    WIDTH=1

    MINOR=

    (NUMBER=1

    )

    LABEL=(   " ")

;

Axis2

    STYLE=1

    WIDTH=1

    LABEL=(   " ")

;

TITLE;

FOOTNOTE;

PROC GCHART DATA=WORK.SORTTempTableSorted

;

    VBAR

     AAA

/

    SUMVAR=Arb_Totalt_red

    SUBGROUP=Arb_Totalt_red

    CLIPREF

FRAME    TYPE=MEAN

    INSIDE=SUM

    LEGEND=LEGEND1

    COUTLINE=BLACK

    RAXIS=AXIS1

    MAXIS=AXIS2

;

RUN; QUIT;

TITLE; FOOTNOTE;

PATTERN1;

PATTERN2;

PATTERN3;

PATTERN4;

PATTERN5;

PATTERN6;

Super User
Super User
Posts: 7,942

Re: Proc Gchart

Posted in reply to Sennahlake

Hi,

TBH I don't really use GChart as now using sgplot or GTL, so not sure how useful my response will be here.  What I think you would need to do is to explicitly set YAXIS values to be (40, 35, 30, 25, 20...) i.e. in reverse.  Not sure how you would do it in GChart but below is some syntax for sgplot:

yaxis label="Label" values=(40,35,30,25,20,15,10,5,0);

To add, the SAS help on SGPLOT:

http://support.sas.com/documentation/cdl/en/grstatproc/62603/HTML/default/viewer.htm#xaxis-stmt.htm

Super User
Posts: 11,343

Re: Proc Gchart

Posted in reply to Sennahlake

Generally the approach would be to sort or order the data by an appropriate variable the first group seen is on the bottom. The values in this case look like all you need is to either use an ORDER BY Arb_Totalt_red clause in your SQL.

Often I end up adding a variable to represent a final order after seeing the first version of the chart to do the sort.

Ask a Question
Discussion stats
  • 2 replies
  • 266 views
  • 0 likes
  • 3 in conversation