topic Re: Best Graph for Table for Data with Multiple Rows and Columns in SAS Studio

Best Graph for Table for Data with Multiple Rows and Columns

nicktr18 — Mon, 04 Mar 2019 22:20:41 GMT

I have web-scraped data for nine states for their top 100 rated beers, broken those top 100 beers from each state into eight style groups, and imported the data into SAS as a .csv file. I have inserted that table below.

My question is: what graph would best represent this data? I would like to show graphs for each style as well as a graph showing each state's best style.

Re: Best Graph for Table for Data with Multiple Rows and Columns

Haris — Mon, 04 Mar 2019 23:03:01 GMT

PROC SGPLOT VBAR is one graph you want to look into. First, you would need to transpose your data so that you have a State, Style, and BeerAmount columns. Then you can plot anything you want. For example:

PROC TRANSPOSE;
 by Var1;
 var Arkansas--Tennessee;
run;

PROC SGPLOT;
   VBAR State / response=BeerAmount group=Style groupdisplay=cluster;
run;

Re: Best Graph for Table for Data with Multiple Rows and Columns

nicktr18 — Mon, 04 Mar 2019 23:17:15 GMT

Thanks, Haris! Is there any way to break up the clusters and only show a single style at a time?

Re: Best Graph for Table for Data with Multiple Rows and Columns

Haris — Mon, 04 Mar 2019 23:51:00 GMT

Filter using WHERE STYLE=