topic Re: proc tabulate in ODS and Base Reporting

proc tabulate

NazaninSAS — Fri, 28 Sep 2018 17:27:23 GMT

Hi,

how can I show this table vertically? and remove "N"?

EEOG

EEOG	All
2	3	5	7	10
N	N	N	N	N	N
15	106	11	150	60	342

this is my code:

PROC TABULATE DATA=Employee.Sheet1;

CLASS EEOG PRI;

TABLE EEOG ALL;

RUN;

Thanks,

Nazanin

Re: proc tabulate

Reeza — Fri, 28 Sep 2018 17:30:10 GMT

How is your data structured?

Re: proc tabulate

NazaninSAS — Fri, 28 Sep 2018 17:32:42 GMT

my data is in Excel.

something like this:

PRI	EEOG
1	7
2	3
3	7
4	3
5	7
6	7
7	7
8	7
9	7

Re: proc tabulate

ballardw — Fri, 28 Sep 2018 17:33:00 GMT

This may do what you want:

PROC TABULATE DATA=Employee.Sheet1;
   CLASS EEOG PRI;
   TABLE EEOG ALL ,
         n=' ';
RUN;

You were getting a row because you did not provide a column expression. The page, row and column expressions are separated by a comma. If there are two expressions the first is the ROW and the second is the column. If you have three expressions then they are page, row and column.

The n is the default statistic. Using n=' ' says to show a blank for the heading for that statistic. You could use other text such as "Count" if you like.

Re: proc tabulate

NazaninSAS — Fri, 28 Sep 2018 17:39:56 GMT

perfect!

I got the result I wanted.

Thanks,

Re: proc tabulate

SuryaKiran — Fri, 28 Sep 2018 18:01:31 GMT

If your working on SAS Enterprise Guide then play with Task>Describe>Summary Table (Which is Proc Tabulate) point-and-click feature.

It will create the code and you can copy and edit the code further.

Re: proc tabulate

NazaninSAS — Fri, 28 Sep 2018 18:13:20 GMT

Thanks,

my DB is this:

PRI	EEOG	PWD
1	7
2	3	DIS
3	7
4	3
5	2
6	7
7	7
8	10
9	7
10	3
11	7

however, I want to generate the following table:

EEOG	Count	PWD	LMA	Expectation	Gap
2	1	0	LMA	LMA*Count	Expectation-Count
3	3	1	LMA	LMA*Count	Expectation-Count
5	0	0	LMA	LMA*Count	Expectation-Count
7	6	0	LMA	LMA*Count	Expectation-Count
10	1	0	LMA	LMA*Count	Expectation-Count
	11	1

Re: proc tabulate

Reeza — Fri, 28 Sep 2018 18:16:50 GMT

What is the logic for those last columns? Not seeing any reference to LMA anywhere else.

That looks somewhat like a PROC FREQ depending on your definition of 'Expected' and LMA.

@NazaninSAS wrote:

Thanks,

my DB is this:

PRI

EEOG

PWD

1

7

2

3

DIS

3

7

4

3

5

2

6

7

7

7

8

10

9

7

10

3

11

7

however, I want to generate the following table:

EEOG

Count

PWD

LMA

Expectation

Gap

2

1

0

LMA

LMA*Count

Expectation-Count

3

3

1

LMA

LMA*Count

Expectation-Count

5

0

0

LMA

LMA*Count

Expectation-Count

7

6

0

LMA

LMA*Count

Expectation-Count

10

1

0

LMA

LMA*Count

Expectation-Count

11

1

Re: proc tabulate

Shmuel — Fri, 28 Sep 2018 18:18:47 GMT

You could get the same wanted result with:

proc freq data=employee.sheet1 ;
    table eeog / norow nocol;
run;

Re: proc tabulate

NazaninSAS — Fri, 28 Sep 2018 18:23:23 GMT

LMA is constant, I have to assign it later.

Re: proc tabulate

NazaninSAS — Fri, 28 Sep 2018 18:24:16 GMT

Thanks,

but I want to see the total as well!