Date:         Mon, 26 Feb 2007 10:53:51 +1100
Reply-To:     "Johnson, David" <David.Johnson@CBA.COM.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Johnson, David" <David.Johnson@CBA.COM.AU>
Subject:      Re: Stacking Rows from Output Tables from proc univariate
Content-Type: text/plain; charset="us-ascii"

This seems very odd.  I would look first at the Univariate code.

Your points are specified and have names; 2 of each, but your prefix
specifies only two values while your Var statement specifies 4.

I would get these to agree first, and then send the exact error message
to the list before looking at doing a match merge.


Kind regards

David

/* - - - - - - - - - - - - - - - - - - - - -
It is a capital mistake to theorize before one has data.
Insensibly one begins to twist facts to suit theories, instead of
theories to suit facts.
-Sir Arthur Conan Doyle
- - - - - - - - - - - - - - - - - - - - - */

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of OR
Stats
Sent: Monday, 26 February 2007 10:41 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Stacking Rows from Output Tables from proc univariate

Hi there:

Using Proc Univariate, I'd like to be able to get and use certain %'s
that is not the default.  So it appears the following code would output
that for
us:
proc univariate data=mymaintable;
                  var w x y z;
output out=mypercentout pctlpts  = 97.5 87.5
                       pctlpre  = Strength Width
                       pctlname = pct97_5 pct87_5;
            run;

The memory on my computer is such that the above code will only compute
and save the user specified percentiles for only up to two variables.
So despite my specifying [ w x y z], the output is always just that for
variables w and x.  To get around the problem, I decided to run the proc
twice then, since I have four variables.  But, for efficient
processing/using these %'s, I'd like them to all sit in one table.  And
it would be most convenient that they are stacked ontop of each other as
97.5and
87.5 are computed for all the variables.  Unfortunately, when the way
that the output statement is canned, it has the output %'s of the
variables stretched across columns.  And when I would like to merge
these different output table, but using a Data Step w. 'set' statement,
I can stack these rows, but I don't know how to put an identifier to
each row to distinguish the different variables per row.  Any
suggestions?  Thanx!

************** IMPORTANT MESSAGE *****************************
This e-mail message is intended only for the addressee(s) and contains information which may be
confidential.
If you are not the intended recipient please advise the sender by return email, do not use or
disclose the contents, and delete the message and any attachments from your system. Unless
specifically indicated, this email does not constitute formal advice or commitment by the sender
or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries.
We can be contacted through our web site: commbank.com.au.
If you no longer wish to receive commercial electronic messages from us, please reply to this
e-mail by typing Unsubscribe in the subject line.
**************************************************************