Date:         Sat, 30 Jan 2010 16:20:53 -0500
Reply-To:     Mark D H Miller <mdhmiller@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Mark D H Miller <mdhmiller@GMAIL.COM>
Subject:      Re: Multiply
Comments: To: TheSharpOne <sharp131@HOTMAIL.CO.UK>
In-Reply-To:  <5e230a2c-b177-426e-b578-42856e0965d0@b2g2000yqi.googlegroups.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Is not   x * -1  the same as     x  = -(x)   !!!

... Mark Miller

On 1/29/2010 6:09 AM, TheSharpOne wrote:
> it won't be pretty but you could try something likethe code below.
> Just replace WORK with your library name and SAMPLE with your table
> name:
> Proc SQL NoPrint;
>    Select Trim(Name)!!' = '!!Trim(Name)!!'*-1;' INTO : varlist
> separated by ' '
>    From Dictionary.columns
>    Where libname = 'WORK' AND memname = 'SAMPLE'
>    ;
> Quit;
>
> Data x1;
>    set x;
>    &varlist;
> Run;
>
>