Creating a table

[Viktoreli]

Hi,

I have a dataset that looks something like this

id ve na  ai

1  1  2  3

2  1  2  2

3  3  3  9

4  2  3  11

5  3  2  2

6  3  1  11

And I want to create a table where I have ve on the y axis and on the x axis I want the number of "na" observations for each of its numbers.

Like

na   1               2                 3

ve

1     2              0                1

2     0              0                1  

3     1              1                1

[PeterClemmensen · Accepted solution]

You want this in a report, correct?

Try something like this

data have;
input id ve na ai;
datalines;
1 1 2 3
2 1 2 2
3 3 3 9
4 2 3 11
5 3 2 2
6 3 1 11
;

proc tabulate data=have;
    class ve na;
    table ve, na=''*n=''*f=best.;
run;

[Viktoreli]

Thank you alot!!:)