Date:         Wed, 1 Aug 2007 09:59:07 -0000
Reply-To:     Pralay <pralayhazra@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Pralay <pralayhazra@GMAIL.COM>
Organization: http://groups.google.com
Subject:      Re: It is very very simple question reading data in sas
Comments: To: sas-l@uga.edu
In-Reply-To:  <1185961143.936738.311550@i38g2000prf.googlegroups.com>
Content-Type: text/plain; charset="us-ascii"

On Aug 1, 2:39 pm, reddy <mail2ka...@gmail.com> wrote:
> I have two variables   name and   age.
>
>  data is
>
> cards;
> ffc ffc ffc 23
> ksds 24
> dsfasdfsdf 34
> ss ss ss 45
> ;
>
> i want output like this
>
>  name               age
>
> ffc ffc ffc         23
>
> ksds                24
>
> dsfasdfsdf          34
>
> ss ss ss            45
>
> could u please help any one
>
> Thanks in advance
>
> s.karunakar
> Mail: mail2ka...@gmail.com

Hello Karunakar,

As a quick fix u can try the following code.

data dsn;
        infile datalines;
        input var $ 200.;
                Age=input(compress(var,'abcdefghijklmnopqrstuvwxyz'),12.);
                Name=compress(var,'1234567890');
datalines;
ffc ffc ffc 23
ksds 24
dsfasdfsdf 34
ss ss ss 45
;
run;

There must be some better way to do this!!!

Cheers,
Pralay