topic How do simple bar chart for two variable in SAS Programming

How do simple bar chart for two variable

Palucci — Wed, 03 Nov 2021 20:39:15 GMT

i have a problem i chose data already and i would like to show them using a simple bar chart however. I totally don't do it.

my data:

Customer1	Customer2
23771	27636

my code :

proc sql; 
create table graphbar as
select ak.CUSTOMER1, wy.CUSTOMER2,
from(select sum(product) as CUSTOMER1, from sold ak
cross join 
(select sum(product) as CUSTOMER2 from buy wy
;
quit;

proc SGPLOT data = graphbar;
vbar CUSTOMER1;
vbar CUSTOMER2 ;

run;
quit;

Re: How do simple bar chart for two variable

Reeza — Wed, 03 Nov 2021 20:52:57 GMT

proc sql; 
create table graphbar as
select *
from
(select "Sold" as Type, sum(sold.product) as Total from sold)
union
(select "Buy" as Type, sum(buy.product) as Total from buy)
;
quit;

proc SGPLOT data = graphbar;
vbar Total / group=Type;
run;

run;
quit;

@Palucci wrote:

i have a problem i chose data already and i would like to show them using a simple bar chart however. I totally don't do it.

my data:

Customer1 Customer2

23771 27636

my code :
proc sql; 
create table graphbar as
select ak.CUSTOMER1, wy.CUSTOMER2,
from(select sum(product) as CUSTOMER1, from sold ak
cross join 
(select sum(product) as CUSTOMER2 from buy wy
;
quit;

proc SGPLOT data = graphbar;
vbar CUSTOMER1;
vbar CUSTOMER2 ;

run;
quit;

Re: How do simple bar chart for two variable

Palucci — Thu, 04 Nov 2021 06:50:28 GMT

Hello Reeza, Thanks its working but my graph shown y=0,1 how to change it ? to for example 100 , 200, 300, 400 ?