Date:         Tue, 18 Jan 2005 11:40:18 -0800
Reply-To:     Dale McLerran <stringplayer_2@YAHOO.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
Comments:     DomainKeys? See http://antispam.yahoo.com/domainkeys
From:         Dale McLerran <stringplayer_2@YAHOO.COM>
Subject:      Re: Rename multiple variables
In-Reply-To:  <s1ecfb9e.019@SLCM02.firsthealth.com>
Content-Type: text/plain; charset=us-ascii

The AUTONAME option is useful, but does have one drawback.  If
I want to use variable name lists of the form temp00-temp23,
then variable names generated employing the AUTONAME option do
not suffice.  Note, too, that if I have in my output dataset
variables named temp00, temp00_mean, and temp00_std, then I
will probably not wish to use variable lists of the form temp00:.

I believe the AUTONAME option would be more useful if SAS had
prefixed the statistic keyword rather than postfixed the keyword.
Perhaps SI could make that an option in a future release.

Dale


--- Jack Hamilton <JackHamilton@FIRSTHEALTH.COM> wrote:

> You didn't say what you want the new names to be, but if you'll
> settle
> for temp00_mean and temp00_std, and so forth, use PROC SUMMARY with
> AUTONAME on the OUTPUT statement.
>
>
>
>
> --
> JackHamilton@FirstHealth.com
> Manager, Technical Development
> Metrics Department, First Health
> West Sacramento, California USA
>
> Coelum, non animum mutant, qui trans mare currunt.
>
>
> >>> "Li,Qian [Ontario]" <Qian.Li@EC.GC.CA> 01/18/2005 10:57 AM >>>
> Dear SAS-L experts,
>
> I have a dataset containing 224 variables. I need to output the mean
> and
> std values for each variable with DIFFERENT names. Are there better
> ways
> to do this using SQL procedure or DATA step?
>
> Any help are very much appreciated.
>
> The variables are:
>
> %let variables = temp00 temp01 temp02 temp03 temp04 temp05 temp06
> temp07
>     temp08 temp09 temp10 temp11 temp12 temp13 temp14 temp15
>     temp16 temp17 temp18 temp19 temp20 temp21 temp22 temp23
>     dwpt00 dwpt01 dwpt02 dwpt03 dwpt04 dwpt05 dwpt06 dwpt07
>     dwpt08 dwpt09 dwpt10 dwpt11 dwpt12 dwpt13 dwpt14 dwpt15
>     dwpt16 dwpt17 dwpt18 dwpt19 dwpt20 dwpt21 dwpt22 dwpt23
>     pres00 pres01 pres02 pres03 pres04 pres05 pres06 pres07
>     pres08 pres09 pres10 pres11 pres12 pres13 pres14 pres15
>     pres16 pres17 pres18 pres19 pres20 pres21 pres22 pres23
>     uwnd00 uwnd01 uwnd02 uwnd03 uwnd04 uwnd05 uwnd06 uwnd07
>     uwnd08 uwnd09 uwnd10 uwnd11 uwnd12 uwnd13 uwnd14 uwnd15
>     uwnd16 uwnd17 uwnd18 uwnd19 uwnd20 uwnd21 uwnd22 uwnd23
>     vwnd00 vwnd01 vwnd02 vwnd03 vwnd04 vwnd05 vwnd06 vwnd07
>     vwnd08 vwnd09 vwnd10 vwnd11 vwnd12 vwnd13 vwnd14 vwnd15
>     vwnd16 vwnd17 vwnd18 vwnd19 vwnd20 vwnd21 vwnd22 vwnd23
>     clud00 clud01 clud02 clud03 clud04 clud05 clud06 clud07
>     clud08 clud09 clud10 clud11 clud12 clud13 clud14 clud15
>     clud16 clud17 clud18 clud19 clud20 clud21 clud22 clud23
>     t01p925 t01p850 t01p700 t01p600 t01p500
>     t07p925 t07p850 t07p700 t07p600 t07p500
>     t13p925 t13p850 t13p700 t13p600 t13p500
>     t19p925 t19p850 t19p700 t19p600 t19p500
>     d01p925 d01p850 d01p700 d01p600 d01p500
>     d07p925 d07p850 d07p700 d07p600 d07p500
>     d13p925 d13p850 d13p700 d13p600 d13p500
>     d19p925 d19p850 d19p700 d19p600 d19p500
>     u01p925 u01p850 u01p700 u01p600 u01p500
>     u07p925 u07p850 u07p700 u07p600 u07p500
>     u13p925 u13p850 u13p700 u13p600 u13p500
>     u19p925 u19p850 u19p700 u19p600 u19p500
>     v01p925 v01p850 v01p700 v01p600 v01p500
>     v07p925 v07p850 v07p700 v07p600 v07p500
>     v13p925 v13p850 v13p700 v13p600 v13p500
>     v19p925 v19p850 v19p700 v19p600 v19p500;
>
> Qian
>
>
> "MMS <firsthealth.com>" made the following annotations.
>
------------------------------------------------------------------------------
> This message, including any attachments, is intended solely for the
> use
> of the named recipient(s) and may contain confidential and/or
> privileged information.  Any unauthorized review, use, disclosure or
> distribution of this communication(s) is expressly prohibited.
> If you are not the intended recipient, please contact the sender by
> reply e-mail and destroy any and all copies of the original message.
> Thank you.
>
 =============================================================================
>


=====
---------------------------------------
Dale McLerran
Fred Hutchinson Cancer Research Center
mailto: dmclerra@NO_SPAMfhcrc.org
Ph:  (206) 667-2926
Fax: (206) 667-5977
---------------------------------------



__________________________________
Do you Yahoo!?
Yahoo! Mail - Helps protect you from nasty viruses.
http://promotions.yahoo.com/new_mail