How do simple bar chart for two variable

[Palucci]

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;

[Reeza · Accepted solution]

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;

---

[Palucci]

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