topic Creating Table from Excel in SAS Enterprise in New SAS User

Creating Table from Excel in SAS Enterprise

dach141 — Sat, 12 Oct 2019 23:42:08 GMT

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

Re: Creating Table from Excel in SAS Enterprise

Kurt_Bremser — Sun, 13 Oct 2019 09:17:31 GMT

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;

Re: Creating Table from Excel in SAS Enterprise

dach141 — Mon, 14 Oct 2019 09:29:12 GMT

Thank You!