[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: SAS-Forum Creating an output dataset from proc tabulate that mimics the printed data
From:       Roger Deangelis <roger_deangelis () COMCAST ! NET>
Date:       2022-01-05 17:24:52
Message-ID: 2094024747985135.WA.rogerdeangeliscomcast.net () listserv ! uga ! edu
[Download RAW message or body]

For simple tabulate reports you probably can use the tabulate output, but I have 
not had much luck with complex 'proc tabulates' reports like this one

Maybe sas could at least provide the code to transpose this?

Here is the tabulate output.

p to 40 obs from WORK.TST total obs=46 04JAN2022:06:58:58                             \
 bs    Sex    Year    Region    Group    Condition    _TYPE_    _PAGE_    _TABLE_     \
N     01000     00000

 1     0     2015                                    11000        1         1        \
3    50.0000       .  2     0     2016                                    11000       \
1         1        1    33.3333       .  3     0     2017                             \
11000        1         1        2    66.6667       .  4     0     2018                \
11000        1         1        3    37.5000       .  5     1     2015                \
11000        1         1        3    50.0000       .  6     1     2016                \
11000        1         1        2    66.6667       .  7     1     2017                \
11000        1         1        1    33.3333       .  8     1     2018                \
11000        1         1        5    62.5000       .  9     0                         \
10000        1         1        9      .          45 10     1                         \
10000        1         1       11      .          55 11           2015    East        \
01100        1         1        1    16.6667       . 12           2016    East        \
01100        1         1        2    66.6667       . 13           2015    North       \
01100        1         1        2    33.3333       . 14           2016    North       \
01100        1         1        1    33.3333       . 15           2017    North       \
01100        1         1        1    33.3333       . 16           2018    North       \
01100        1         1        2    25.0000       . 17           2015    South       \
01100        1         1        3    50.0000       . 18           2017    South       \
01100        1         1        2    66.6667       . 19           2018    South       \
01100        1         1        4    50.0000       . 20           2018    West        \
01100        1         1        2    25.0000       . 21                   East        \
00100        1         1        3      .          15 22                   North       \
00100        1         1        6      .          30 23                   South       \
00100        1         1        9      .          45 24                   West        \
00100        1         1        2      .          10 25           2015                \
1                   01010        1         1        2    33.3333       . 26           \
2016                1                   01010        1         1        1    33.3333  \
. 27           2017                1                   01010        1         1       \
1    33.3333       . 28           2018                1                   01010       \
1         1        3    37.5000       . 29           2015                2            \
01010        1         1        2    33.3333       . 30           2016                \
2                   01010        1         1        1    33.3333       . 31           \
2017                2                   01010        1         1        1    33.3333  \
. 32           2018                2                   01010        1         1       \
3    37.5000       . 33           2015                3                   01010       \
1         1        2    33.3333       . 34           2016                3            \
01010        1         1        1    33.3333       . 35           2017                \
3                   01010        1         1        1    33.3333       . 36           \
2018                3                   01010        1         1        2    25.0000  \
. 37                               1                   00010        1         1       \
7      .          35 38                               2                   00010       \
1         1        7      .          35 39                               3            \
00010        1         1        6      .          30 40           2017                \
0        01001        1         1        2    66.6667       .


[prev in list] [next in list] [prev in thread] [next in thread]