Date:         Wed, 3 Oct 2001 18:12:47 -0500
Reply-To:     "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Smith, Curtis, Mr, DCAA" <Curtis.Smith@DCAA.MIL>
Subject:      Re: Text File Import Problem
Comments: To: Mike Stuart <muon33@NYC.RR.COM>
Content-Type: text/plain; charset="iso-8859-1"

Without seeing your actual data file, I can't be sure, but check the
documentation for the infile statement. There are options like flowover and
missover that might may the difference.

-----Original Message-----
From: Mike Stuart [mailto:muon33@NYC.RR.COM]
Sent: Wednesday, October 03, 2001 9:29 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Text File Import Problem


Having problems with a straight-forward import, I think the problem
has to do with non-viz characters, but I'm not sure.  When viewed, the
file I'm trying to read in is relatively straight-forward, one email
address per line.  I'm using the code below to read in this file.

data ffx.epilist ;
  infile epilist truncover ;
  input @1  email   $50. ;

  email = left(trim(lowcase(email))) ;

  domain = substr(email,(index(email,'@')+1)) ;

  run ;

The output however looks like this:


  obs                   email                               domain
   1         test1@dkadk.com 3234dk@efg.com jieuw@lm   dkadk.com
3234dk@efg.com

etc.

It looks like the line delimiter is missing.  Suggestions on how to
fix?  I've tried the import wizard using a number of different
delimiter option and am getting the same result.

Thanks -