topic create a bar gragh with sgplot in Graphics Programming

create a bar gragh with sgplot

radha009 — Sun, 22 Apr 2018 19:07:56 GMT

I want to create a bar chart using sas code with data as below with sgplot.

PROC SGPLOT DATA = applications;

VBAR sys / RESPONSE = app;

VBAR sys / RESPONSE = env;

RUN;

Sys app env

a 67 45

b 20 54

c 35 60

d 40 78

Re: create a bar gragh with sgplot

Reeza — Sun, 22 Apr 2018 19:32:04 GMT

1. Transform your data to a long format so that you have three variables: SYS, MEASUREMENT_TYPE (APP/ENV), Value (measurement).

SYS, Measurement_Type, Value

2. Sort

3. Use VBAR, GROUP = Measurement_Type and GroupDisplay=Cluster.

If this doesn't work for you, post your code.

I did test it and this does generate the graph indicated.

@radha009 wrote:

I want to create a bar chart using sas code with data as below with sgplot.

PROC SGPLOT DATA = applications;

VBAR sys / RESPONSE = app;

VBAR sys / RESPONSE = env;

RUN;

Sys app env

a 67 45

b 20 54

c 35 60

d 40 78

Re: create a bar gragh with sgplot

radha009 — Sun, 22 Apr 2018 20:07:32 GMT

Got it. but how do i transform the data. should i create new table and insert the data.

Re: create a bar gragh with sgplot

Reeza — Sun, 22 Apr 2018 20:36:36 GMT

@radha009 wrote:

Got it. but how do i transform the data. should i create new table and insert the data.

PROC TRANSPOSE or data step using an array. Tutorials below:

How to reshape data wide to long using proc transpose | SAS ...

Reshaping data wide to long using a data step | SAS ... - Stats at UCLA