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
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
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
Got it. but how do i transform the data. should i create new table and insert the data.
@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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.