topic Re: vbar 2 columns created by catt or coalesceC in Graphics Programming

vbar 2 columns created by catt or coalesceC

capam — Tue, 24 Oct 2017 15:50:16 GMT

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

v1	v2	v3	v4		t1	t2
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.

Re: vbar 2 columns created by catt or coalesceC

RW9 — Tue, 24 Oct 2017 16:36:49 GMT

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			2	2
		3		3	1

Then use cat as a group.

Re: vbar 2 columns created by catt or coalesceC

capam — Tue, 24 Oct 2017 16:55:54 GMT

Can you give an example?

Re: vbar 2 columns created by catt or coalesceC

RW9 — Tue, 24 Oct 2017 17:59:21 GMT

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-sas-sg-procedures/

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

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

Re: vbar 2 columns created by catt or coalesceC

capam — Wed, 25 Oct 2017 13:10:07 GMT

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;