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 (August 2007, week 1)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
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


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