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 (September 2008, week 3)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Tue, 16 Sep 2008 07:30:05 -0700
Reply-To:     "ajs2004@bigfoot.com" <ajs2004@BIGFOOT.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "ajs2004@bigfoot.com" <ajs2004@BIGFOOT.COM>
Organization: http://groups.google.com
Subject:      Re: Data input problem :splitting columns
Comments: To: sas-l@uga.edu
Content-Type: text/plain; charset=ISO-8859-1

data blah; infile cards dlm=' ,'; /* Note: both space and comma are delimiters */ input x1 y1 z1 x2 y2 z2; cards; 77.56787,22.09909,0 73.26787,21.09909,0 76.53487,23.09909,0 75.56787,22.09909,0 76.54587,22.09909,0 76.56787,22.03509,0 75.56457,22.05609,0 76.56787,22.05609,0 run;

proc print; run;

Obs x1 y1 z1 x2 y2 z2

1 77.5679 22.0991 0 73.2679 21.0991 0 2 76.5349 23.0991 0 75.5679 22.0991 0 3 76.5459 22.0991 0 76.5679 22.0351 0 4 75.5646 22.0561 0 76.5679 22.0561 0

On Sep 12, 1:07 pm, ajayo...@yahoo.com (ajay ohri) wrote: > Hi All, > > I have the following data in one column for each row , (each value is like x1,y1,z1 space x2,y2,z2 space....) > > 77.56787,22.09909,0 73.26787,21.09909,0 > 76.53487,23.09909,0 75.56787,22.09909,0 > 76.54587,22.09909,0 76.56787,22.03509,0 > 75.56457,22.05609,0 76.56787,22.05609,0 > > Note all z values are O (hence ,0 can be treated as a delimiter) > > How do I split this column into multiple columns for each row. > > Regards, > Ajay > > www.decisionstats.com


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