topic Re: Proc Tabulate Error in SAS Programming

Proc Tabulate Error

KC_16 — Tue, 27 Feb 2018 17:33:35 GMT

I am trying to create a Proc Tabulate (Below) but get the following error message:

ERROR: There are multiple analysis variables associated with a single table cell in the following

proc tabulate data=work.all;
class Pmt Date_new;
var In tons ters;
table (Pmt * in * tons * ters) ,
(Date_new="Month");
run;

I need the table to output like this if possible

i hope this makes sense, please let me know if there is anything in addition I need to support.

Reeza — Tue, 27 Feb 2018 17:38:50 GMT

Try putting these as space delimited, not *

(Pmt * in * tons * ters)

By default though you'll get N counts. If you want the sum or mean you'll need to specify that.

You can find examples here:

The data being used is SASHELP.CARS so you can also run and test the code in the paper.

Reeza — Tue, 27 Feb 2018 17:39:52 GMT

Given the type of summaries you're doing, you may also want to investigate the MultiLabel Format options available.

It may help simplify some of your summaries.

KC_16 — Tue, 27 Feb 2018 17:43:37 GMT

That doesn't seem to work as the variables IN, TONS, TERS just append at the bottom of the table summing up the values.

Reeza — Tue, 27 Feb 2018 17:49:06 GMT

I think this is close to what you want, note that I used SASHELP.STOCKS so you can run the code.

You should be able to map this back to your data.

proc tabulate data=sashelp.stocks;
class date stock;
var open low high;
table stock*(open low high)*sum=''*f=dollar12.2, date ;
run;

KC_16 — Tue, 27 Feb 2018 17:52:01 GMT

Perfect! Thank you for your help!