Date:         Thu, 15 Jul 2004 07:11:24 -0700
Reply-To:     Xavier Autret <xav_x@NOOS.FR>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Xavier Autret <xav_x@NOOS.FR>
Organization: http://groups.google.com
Subject:      Too easy or that can not be done?
Content-Type: text/plain; charset=ISO-8859-1

From that data set, I would like to have one proc that will do that
output.

Data set:

X  Y   a  b
-----------
A 011 10 27
A 142 44 22
B 142 29 24
C 142 18  7

Output:

                    Y
      |---------------------------|
      |     011     |     142     |
      |-------------|-------------|
  X   | a | b | a/b | a | b | a/b |
-----------------------------------
  A   |   |   |     |   |   |     |
  B   |   |   |     |   |   |     |
  C   |   |   |     |   |   |     |

For computing "a/b", I already try : proc tabulate and "<denominator
definition>", proc report and "define / across", but that just do not
work.

Is it possible in one proc?

Thks!

Xavier