Date:         Mon, 9 Mar 2009 08:00:27 -0700
Reply-To:     jwc <jwcassell@EARTHLINK.NET>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         jwc <jwcassell@EARTHLINK.NET>
Organization: http://groups.google.com
Subject:      Using DSD option on infile,
              but consecutive pipe characters not seen as missing data
Comments: To: sas-l@uga.edu
Comments: cc: james.cassell@ncmail.net
Content-Type: text/plain; charset=ISO-8859-1

I'm trying to read a pipe-delimited ascii file using the following
code:

data temp;
infile 'C:\shp\State_active_memb_200902031517.txt'   DLM='|' DSD
lrecl=300 TRUNCOVER ;

input var01           :$12.
       var02               :$12.
        var03   :$12.
         var04                     :$9.
        var05                 date11.
        var06              date11.
        var07             date11.
        var08          date11.
        var09              :$1. ;
run;

Consecutive pipe characters (||) are skipped over instead of being
read as missing values. Can anyone point me in the right direction?

Thanks,
James