Date:         Thu, 13 Aug 1998 10:34:48 -0700
Reply-To:     "Berryhill, Timothy" <TWB2@PGE.COM>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Berryhill, Timothy" <TWB2@PGE.COM>
Subject:      Re: Shorthand method in Proc Means
Comments: To: "Boylan, Dave" <dboylan@UTILICORP.COM>
Content-Type: text/plain

Dave, I would try the XXXnn-XXXnn variable list format on the VAR statement:
   VAR EMP1980-EMP2007 EST1980-EST2007 OUT1980-OUT2007;
If that failed, I would list them that way on a KEEP list (in the DATA=parm)
and default the analysis variables.
 
On the SUM= statement, just code:
   SUM=;
This tells SAS to sum each analysis variable and to use the input name for
the output name.
 
 
Tim Berryhill - Contract Programmer and General Wizard
TWB2@PGE.COM or http://www.aartwolf.com/twb.html
Frequently at Pacific Gas & Electric Co., San Francisco
The correlation coefficient between their views and
my postings is slightly less than 0
> ----------
> From:         Boylan, Dave[SMTP:dboylan@UTILICORP.COM]
> Reply To:     Boylan, Dave
> Sent:         Thursday, August 13, 1998 10:16 AM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Shorthand method in Proc Means
>
> I'm performing a Proc Means on a dataset with about 100 variables.  I
> would
> like to SUM 84 of these variables.  Is there a shorthand way of coding
> this:
>
>
> Proc Means data=work.ecodat noprint nway;
>         Class Sic CountyId;
>         Var emp1980 emp1981 emp1982 ............................;
>         output out=work.EcoSum
>         sum = emp1980 emp1981 emp1982.........................;
> run;
>
>
> the variables are:
>         emp1980-emp2007
>         est1980 - est2007
>         out1980 - out2007
>
>
> Thanks for your help.
> --------------------------------------
> David Boylan
> Corporate Forecasting
> UtiliCorp United, Inc.
> 816.467.3062
> --------------------------------------
>