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;
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;
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;
Hello Reeza, Thanks its working but my graph shown y=0,1 how to change it ? to for example 100 , 200, 300, 400 ?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.