topic Re: plotting two variables in one bar in Graphics Programming

plotting two variables in one bar

Ram_SAS — Sun, 09 Apr 2017 18:47:42 GMT

Hi,

In proc sgplot with either hbar or vbar statement, how to bring information from two variables to one bar. For eg. var1=5 and var2=10. Other obs could be var1=2 and var2=5. The plot should show one bar for each obs and each representaive bar should show informaion from both var1 (red) and var2 (blue). The group won't work here.

Re: plotting two variables in one bar

Ram_SAS — Sun, 09 Apr 2017 19:11:37 GMT

Basically need to show two 'response' values into one bar with different color.

Re: plotting two variables in one bar

Reeza — Sun, 09 Apr 2017 19:17:30 GMT

You'll need to restructure you data into how SAS expects it to be for a stacked bar chart.

This means combining the variables and included a new variable to denote the source/group.

Re: plotting two variables in one bar

Ram_SAS — Sun, 09 Apr 2017 19:59:28 GMT

You mean create a new variable by adding var1+var2. But in the vbar statement, what will be go in response=?? and group= combined?? groupdisplay=stack? Thanks.

Re: plotting two variables in one bar

Reeza — Sun, 09 Apr 2017 20:09:41 GMT

If you want sample code post sample data.

Re: plotting two variables in one bar

Ram_SAS — Sun, 09 Apr 2017 20:37:22 GMT

Here is a sample data. Need to show var1 and var2 of each customer in the same bar.

data fitness;
input cus_id country $ var1 var2;
datalines;
102 Can 3.73 11.2
105 USA 20.3 9.1
123 USA 4.6 16.4
156 Can 8.1 0.3
177 USA 0.5 13.4
;
run;

Re: plotting two variables in one bar

Cynthia_sas — Mon, 10 Apr 2017 00:25:52 GMT

Hi:

Restructuring the data will get you want you want. You just need to make 2 observations for every observation in the input data.

cynthia

Re: plotting two variables in one bar

Reeza — Mon, 10 Apr 2017 02:45:51 GMT

If you want the bars stacked change GROUPDISPLAY from CLUSTER to STACK.

Re: plotting two variables in one bar

Ram_SAS — Mon, 10 Apr 2017 02:57:45 GMT

Thanks Reeza and Cynthia..! Did not get the restructuing part, it is clear now.

Re: plotting two variables in one bar

Reeza — Mon, 10 Apr 2017 03:12:09 GMT

The correct answer should be Cynthia's post.