topic Reorder Bargraph made with sgplot in SAS Enterprise Guide

Reorder Bargraph made with sgplot

DavidPhillips2 — Tue, 09 Dec 2014 18:34:01 GMT

I created a number of bar charts using sqplot and would like to reorder the subgroup to fit a non-alphabetic order. I tried the documentation that I found for reordering a gplot graph but it does not appear to work on a sgplot graph.

The syntax I am working with is legend order=('Undergraduate Non-degree Seeking').

There are other categories, however I’m working with just the first category first to see if it works.

The full order statement would be

order=(

'Baccalaureate'

'Master''s'

'Doctoral - Research / Scholarship'

'Doctoral - Professional Practice (First Professional)'

'Undergraduate Post-Baccalaureate Certificate'

'Graduate Post-Baccalaureate Certificate'

'Graduate Post-Master''s Certificate'

'Undergraduate Non-degree Seeking'

'Graduate Non-degree Seeking');

Do I need to use both legend order() value()?

Re: Reorder Bargraph made with sgplot

ballardw — Tue, 09 Dec 2014 18:51:21 GMT

Which version of SAS as changes are fairly rapid in the SG graphics?

It would help if you post could post some trial data in the form of a data step, dummy is fine, and the code you have tried so far.

Re: Reorder Bargraph made with sgplot

DavidPhillips2 — Tue, 09 Dec 2014 19:06:36 GMT

I just noticed an error in my wording I stated sgsplot I’m using gchart.

I am using SAS 9.2 and EG 5.1

legend2 label=(“Test”)

order=(

'Baccalaureate'

'Master''s'

'Doctoral - Research / Scholarship'

'Doctoral - Professional Practice (First Professional)'

'Undergraduate Post-Baccalaureate Certificate'

'Graduate Post-Baccalaureate Certificate'

'Graduate Post-Master''s Certificate'

'Undergraduate Non-degree Seeking'

'Graduate Non-degree Seeking');

title1 ls=1.5 "Enrollment Headcount Summary";

axis1 label=none;

axis2 label=none value=none;

axis3 label=none;

proc gchart data=enrollment;

vbar &enrRepTyRank /

type=sum

space=0

gspace=1

sumvar=STUDENTS_ENROLLED

group=ACADEMIC_PERIOD_DESC

subgroup=&enrRepTyRank

discrete

gaxis=axis1 maxis=axis2 raxis=axis3

legend=legend2;

run;

Re: Reorder Bargraph made with sgplot

DavidPhillips2 — Tue, 09 Dec 2014 19:12:42 GMT

This article is similar to what I am trying to accomplish but it does not work for me.

https://communities.sas.com/message/116761

Re: Reorder Bargraph made with sgplot

DavidPhillips2 — Tue, 09 Dec 2014 19:46:14 GMT

In this posting I’m noticing that the author uses both order() and value()

legend1 label=('Product Category') order=(&ord) value=(j=l &val);

Why is the author using both?

http://support.sas.com/kb/41/603.html

Re: Reorder Bargraph made with sgplot

Reeza — Tue, 09 Dec 2014 19:53:31 GMT

Sample data and expected output would be useful.

The general method to re-order is to recode to numbers and use formats to display the values of interest.

Re: Reorder Bargraph made with sgplot

DavidPhillips2 — Tue, 09 Dec 2014 20:48:09 GMT

'Doctoral - Research / Scholarship' should be before 'Baccalaureate'

proc sql;

CREATE TABLE testTable(

ACADEMIC_PERIOD varchar(50),

STUDENTS_ENROLLED int,

STATUS varchar(50),

DEGREE_LEVEL varchar(50)

);

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Doctoral - Research / Scholarship');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Doctoral - Research / Scholarship');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Doctoral - Research / Scholarship');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Doctoral - Research / Scholarship');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Doctoral - Research / Scholarship');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Doctoral - Research / Scholarship');

quit;

/*allow ordering*/

PROC Format;

Invalue $dLvl

'Doctoral - Research / Scholarship'='1'

'Baccalaureate' = '2';

value $dLvl

'1'='Doctoral - Research / Scholarship'

'2'='Baccalaureate';

RUN;

/*allow ordering*/

DATA testTable;

SET testTable;

degreeLevelRank = INPUT(degree_level,$dLvl.);

RUN;

%Stpbegin;

legend1 label=("Test")

order=(1 2 3 4 5 6 7 8 9);

/*order=('Baccalaureate' 'Master''s');*/

title1 ls=1.5 "Test";

axis1 label=none;

axis2 label=none;

axis3 label=none;

proc gchart data=testTable;

hbar ACADEMIC_PERIOD /

space=0

gspace=1

type=sum

outside=sum

sumlabel= 'Students Enrolled'

sumvar=STUDENTS_ENROLLED

group=Status

subgroup=degreeLevelRank

discrete

gaxis=axis1 maxis=axis2 raxis=axis3

legend=legend1;

format degreeLevelRank $dLvl.;

run; Quit;

%Stpend;

Re: Reorder Bargraph made with sgplot

DavidPhillips2 — Tue, 09 Dec 2014 21:13:51 GMT

Finally got it. The examples online are so confusing this should be much cleaner. I have to use an invalue because my string is long otherwise the invalue is not needed. Mostly you need to have order and value as the same string e.g. order=(‘1’ ‘2’) value=(‘1’ ‘2’)

proc sql;

CREATE TABLE testTable(

ACADEMIC_PERIOD varchar(50),

STUDENTS_ENROLLED int,

STATUS varchar(50),

DEGREE_LEVEL varchar(50)

);

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 40, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('1', 60, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 20, 'fulltime', 'Baccalaureate');

INSERT INTO testTable (Academic_period, STUDENTS_ENROLLED, STATUS, DEGREE_LEVEL)

VALUES ('2', 2, 'fulltime', 'Baccalaureate');