[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sas-l
Subject:    Re: Option to get rid of Tab at very End of the File
From:       Venky Chakravarthy <swovcc () HOTMAIL ! COM>
Date:       2007-02-28 22:04:51
Message-ID: 200702282204.l1SJZeQe016173 () mailgw ! cc ! uga ! edu
[Download RAW message or body]

On Wed, 28 Feb 2007 15:38:29 -0600, SAS_learner <proccontents@GMAIL.COM>
wrote:

>Hello guys,
>
>I am trying to import  tab delimted file (.CSV). Everything seems to be
Okay
>expect for last variable. The reason I belive is that there is extra Tab at
>the end of file,So the SAS is getting some special characters. Is there any
>option to get rid of special character ( I belive it end of the
>
>thanks

Try

data _null_ ;
  infile <your file> ;
  input ;
  substr(_infile_,length(_infile_)-1) = " " ;
  file <your file> ;
  put _infile_ ;
run ;

Venky Chakravarthy
[prev in list] [next in list] [prev in thread] [next in thread]