Date:         Mon, 9 Mar 2009 10:27:23 -0500
Reply-To:     "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "./ ADD NAME=Data _null_;" <iebupdte@GMAIL.COM>
Subject:      Re: Using DSD option on infile,
              but consecutive pipe characters not seen as missing data
Comments: To: Joe Matise <snoopy369@gmail.com>
In-Reply-To:  <b7a7fa630903090811w43f4098pc3bbe58287728bb0@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

I think all the formats need the : modifier or use INFORMAT statement.
 FORMATED input "var06 data11." is incompable with this type of input.

On 3/9/09, Joe Matise <snoopy369@gmail.com> wrote:
> As far as I understand it, that's what DSD does... perhaps take off the :
> from your informats, not sure if they might be causing trouble?
>
> -Joe
>
> On Mon, Mar 9, 2009 at 9:00 AM, jwc <jwcassell@earthlink.net> wrote:
>
> > 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
> >
>