topic Re: proc tabulate too many dimensions in SAS Programming

proc tabulate too many dimensions

Brandon16 — Mon, 26 Feb 2018 15:47:09 GMT

Hi,

How do I create a proc tabulate with 23 columns (each column is a different variable)? I get an error saying their are too many dimensions when using a small sample below.

proc tabulate data=test.testing;
class pdte;
var F1 F1V F2 F2V;
table (pdte="2") *
(F1="1") ,
(F1V="2") ,
(F2="3") ,
(F2V="4");
run;

Re: proc tabulate too many dimensions

Astounding — Mon, 26 Feb 2018 17:15:07 GMT

I'm not sure I can take you through all the steps you need to get a working program. But I can at least answer this question and leave the subsequent questions to you.

PROC TABULATE allows just three dimensions. You can define the pages, the rows, and the columns. Within a TABLE statement, the comma is a key symbol that separates one dimension from the next. So you can use at most two commas in a single TABLE statement.

To make PDTE the rows, and add a separate column for each of your variables, the TABLE statement would look more like this:

table pdte="2",

F1="1" F1V="2" F2="3" F2V="4";

The spacing and indentation are arbitrary ... whatever is easily readable is OK.

Re: proc tabulate too many dimensions

Brandon16 — Mon, 26 Feb 2018 17:21:55 GMT

That makes sense, thank you. I need to get the data currently in a dataset into a format where I can automate it into excel. Without using a Tabulate, im not sure how else I would go about doing it, any ideas at all please?

Re: proc tabulate too many dimensions

Astounding — Mon, 26 Feb 2018 17:49:34 GMT

I'm not an Excel user, so can't be that much help. But I would guess the easiest thing to port over to Excel would be a SAS data set. Why try to port over a report (which can take on many different forms), when you can port a data set?