|Date: ||Mon, 9 Mar 2009 10:35:37 -0700|
|Reply-To: ||pudintain <jwcassell@EARTHLINK.NET>|
|Sender: ||"SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>|
|From: ||pudintain <jwcassell@EARTHLINK.NET>|
|Subject: ||Re: Using DSD option on infile,|
|Content-Type: ||text/plain; charset=ISO-8859-1|
On Mar 9, 11:27 am, iebup...@GMAIL.COM ("./ ADD NAME=Data _null_;")
> 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 <snoopy...@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 <jwcass...@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
Yup, need the colon on all the variables. Thanks folks.