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