Date:         Mon, 25 May 2009 14:11:01 -0700
Reply-To:     "J. Carl Zeigler" <jcz@JCZEIGLER.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "J. Carl Zeigler" <jcz@JCZEIGLER.COM>
Organization: http://groups.google.com
Subject:      Re: Data rollup
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

The 'Trailing @' is perfect for this sort of thing.
http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default/a000146292.htm#a000146300


data a ;
   infile cards missover ;
   input var @;
cards ;
1
2 3
340 120
5 6 7 8
;;;;





On May 7, 6:57 pm, linu...@COMCAST.NET (Phil Spence) wrote:
> I would like to achieve the following in proc sql. I know how to do this in
> Oracle, but would like to do it in SAS.
>
> What I have:
>
> var1 var2
> 100
> 230
> 340 120
>
> What I want:
>
> var1
> 100
> 230
> 340
> 120
>
> TIA