Data visualization with SAS programming

vbar 2 columns created by catt or coalesceC

Accepted Solution Solved
Reply
Contributor
Posts: 58
Accepted Solution

vbar 2 columns created by catt or coalesceC

I have 2 columns (t1 and t2)  created by catt or coalesceC from multiple columns (v1:v4) similar to the below.

 

v1v2v3v4 t1t2
1    1 
 2    2
  3  3 
       
   4-->4 
       
5     5
       
 7   7 
   5 5 
  8   8

 

I then run the following code. 

 

proc sgplot have;
	vbar t1;
	vbar t2;
run;

Then I get the following error message that I don't understand. 

 

ERROR: The same category variable must be used for summarized plots.


Accepted Solutions
Solution
‎10-25-2017 09:10 AM
Contributor
Posts: 58

Re: vbar 2 columns created by catt or coalesceC

I finally found the solution I was looking for. Replace vbar in the above with vbarbasic as shown below:

 

proc sgplot data=have;
	vbarbasic t1;
	vbarbasic t2;
run;

View solution in original post


All Replies
Super User
Super User
Posts: 8,190

Re: vbar 2 columns created by catt or coalesceC

The error tells you pretty much everything.  VBAR takes as first parameter a category variable for summarisation.  You can only have one.  Why have the data in two columns?  Why not coalesce the t values an have a category variable:

v1 v2 v3 v4  T cat  
1        1 1  
  2      
    3   1  

Then use cat as a group.

Contributor
Posts: 58

Re: vbar 2 columns created by catt or coalesceC

Can you give an example?
Super User
Super User
Posts: 8,190

Re: vbar 2 columns created by catt or coalesceC

There is plenty of examples out there, first google hit:

https://blogs.sas.com/content/sascom/2011/08/22/how-to-make-a-cluster-grouped-bar-chart-graph-using-...

 

Also, you may find this blog helpful, it covers everything graph orientated.

http://blogs.sas.com/content/graphicallyspeaking/

Solution
‎10-25-2017 09:10 AM
Contributor
Posts: 58

Re: vbar 2 columns created by catt or coalesceC

I finally found the solution I was looking for. Replace vbar in the above with vbarbasic as shown below:

 

proc sgplot data=have;
	vbarbasic t1;
	vbarbasic t2;
run;
☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 101 views
  • 0 likes
  • 2 in conversation