Creating Table from Excel in SAS Enterprise

[dach141]

Hi, I am pretty new to SAS overall, I am trying to create a table I made in Excel using SAS Enterprise guide 6.1.

See data set and excel table attached.

Thanks

[Kurt_Bremser · Accepted solution]

First, I had to make valid SAS variable names, then I used proc sgplot:

options validvarname=any;
data have;
set myfold.filter_for_sortsortedvendor_0_5_;
rename
  'Product Category'n=product_category
  'Percentage of Total Expenditure'n=percentage
;
run;

options validvarname=v7;

ods graphics / reset width=6.4in height=4.8in imagemap;

proc sgplot data=WORK.HAVE;
	hbar Vendor / response=percentage categoryorder=respdesc;
	xaxis grid;
run;

ods graphics / reset;

[dach141]

Thank You!