Date:         Fri, 23 Jan 2009 22:24:17 -0800
Reply-To:     Nguyen An Nguyen <nguyenannguyen@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Nguyen An Nguyen <nguyenannguyen@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: getting results from multiple proc means into single dataset
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

Dear Joe,

Thanks for the solutions. I have a new dataset, call it New, that is
"similar" to another one, call it Old. But the variable names are
completely different. I already guessed which variable in New
corresponds to which var in Old (I will call this act variable
mapping).

Now, I have to do simple proc means (without class statement) to
compare the means statistics of these (old and new) variables, to
confirm the mapping. If the means are not too far away, then my guess
is likely to be correct, and vise versa. Ultimately, I would want to
see something like:

Variable_in_New Mean Min Max  Variable_in_Old Mean Min Max

New_var 1           12       0    15.5   Old_var1       11.3    0
16

Unfortunately, I have hundreds of variables in New to be matched. I
can do separate proc means for Old and New, then combine them using
Excel. It is doable. Just wonder if there is another way to do it
quicker, without too much manual work.

Dear Nat: the two datasets are quite different (not the same variable
names) and large. So your solution would not work in my case. Thanks
for your suggestion anyway.

> N.N.
>
> CONFIDENTIALITY NOTICE:  This electronic message contains
> information which may be legally confidential and/or privileged and
> does not in any case represent a firm ENERGY COMMODITY bid or offer
> relating thereto which binds the sender without an additional
> express written confirmation to that effect.  The information is
> intended solely for the individual or entity named above and access
> by anyone else is unauthorized.  If you are not the intended
> recipient, any disclosure, copying, distribution, or use of the
> contents of this information is prohibited and may be unlawful.  If
> you have received this electronic transmission in error, please
> reply immediately to the sender that you have received the message
> in error, and delete it.  Thank you.