LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (February 1997, week 2)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:   Fri, 14 Feb 1997 21:31:41 +0100
Reply-To:   ehoogenb@solair1.inter.nl.net
Sender:   "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:   Eric Hoogenboom <ehoogenb@SOLAIR1.INTER.NL.NET>
Organization:   NLnet
Subject:   Re: SAS calculations
Content-Type:   text/plain; charset=us-ascii

Eric Hoogenboom wrote:

(...)

> proc sql; > select raw.var1, put(raw.var1/aggr.sumvar1) as pcvar1 > from raw, > (select sum(var1) as sumvar1 > from raw) aggr; > run; > quit;

I just saw that I used the put function. Skip that please. Second, if you want the variables in a new dataset, use the create table statement before the select.

Eric.


Back to: Top of message | Previous page | Main SAS-L page