[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

Using Proc Tabulate in SAS

Experts,

i have the following code that I am using for a Proc Tabulate:

PROC TABULATE DATA=TOTAL_EDITS;
          CLASS  EDIT;
      TABLE n(EDIT);
RUN;

My question is the results go across.  Is there a way to have the results which show the number of edits within each edit to go down so it is esier to read.
0
morinia
Asked:
morinia
1 Solution
 
ShannonEECommented:
Hi there Morinia,

The table statement gives details of

 (pages) , (rows) , (columns)

Note separated by commas.

You can leave dimensions off from the front, so you can not name (pages) for
a (row) and (column layout).

As well you can omit the first 2 dimensions and just name columns.

What is required in your case is to just name the rows, which isnt possible,

However you could specify the row dimension and provide a dummy
column dimension.

Try ,

TABLES    EDIT N ,
          ALL='Number of edits';

Open in new window

or

TABLES  EDIT ,
        N='Number of edits';

Open in new window

or other similar construct.

===================

There are other ways of getting what you want.  For instance you could use
the OUT= <new dataset name> statement on the PROC TABULATE line, and
just PROC PRINT the resultant dataset, maybe after a PROC TRANSPOSE
depending on what you want.

===================

Hope this is the pointer you require.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now