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
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 <email@example.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?
> On Mon, Mar 9, 2009 at 9:00 AM, jwc <firstname.lastname@example.org> 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