topic Re: Creating a table in SAS Programming

Creating a table

Viktoreli — Wed, 13 Nov 2019 09:39:21 GMT

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.

na 1 2 3

1 2 0 1

2 0 0 1

3 1 1 1

Re: Creating a table

PeterClemmensen — Wed, 13 Nov 2019 09:45:56 GMT

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;

Re: Creating a table

Viktoreli — Wed, 13 Nov 2019 09:52:02 GMT

Thank you alot!!:)