Using Proc Tabulate in SAS

Posted on 2014-08-14
Last Modified: 2016-02-13

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

          CLASS  EDIT;
      TABLE n(EDIT);

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.
Question by:morinia
    1 Comment
    LVL 8

    Accepted Solution

    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


            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.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    In today’s complex data management environments, it is not unusual for UNIX servers to be dedicated to a particular department, purpose, or database.  As a result, a SAS® data analyst often works with multiple servers, each with its own data storage…
    Read about achieving the basic levels of HRIS security in the workplace.
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now