Date:         Mon, 24 Jun 1996 10:15:02 EDT
Reply-To:     "F.Joseph Kelley" <JKELLEY@UGA.CC.UGA.EDU>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "F.Joseph Kelley" <JKELLEY@UGA.CC.UGA.EDU>
Subject:      Re: delimiters
Comments: To: Narayan Baliga <nbaliga@UMICH.EDU>
In-Reply-To:  Message of Thu, 20 Jun 1996 19:15:23 GMT from <nbaliga@UMICH.EDU>

reading a file delimited (mostly) with commas:
(since it is known which variable pair is delimited with spaces instead
of commas, use SAS to parse that into two variables.)
                                -- Joe
  data test ;
    infile cards dsd dlm=',' ;
    length var3_4 $ 20 ;
    input name $ var1 vars var3_4 $ var5 ;
    var3 = input(scan(var3_4,1),8.) ;
    var4 = input(scan(var3_4,2),8.) ;
  cards ;
  hi bob, 12,34,56 78,90
  jackson,90,78,56 34 , 12
  ;;;;
  proc print ;
  run;