Date:         Tue, 26 May 2009 02:38:29 -0700
Reply-To:     Amar Mundankar <amarmundankar@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Amar Mundankar <amarmundankar@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: Data rollup
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

On May 26, 2:11 am, "J. Carl Zeigler" <j...@jczeigler.com> wrote:
> The 'Trailing @' is perfect for this sort of thing.http://support.sas.com/documentation/cdl/en/lrdict/61724/HTML/default...
>
> 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

Hi J. Carl Zeigler,
Did you run the code ?? It is giving output as following.
o/p:
var
1
2
340
5

Regards,
Amar Mundankar.