Proc Import csv but need to delete last line

hondahawkrider — Thu, 11 May 2017 16:15:11 GMT

Have a script that works great

proc import 
   datafile="c:\temp\input.csv"
   replace
   /*
   out command below only keeps what var columns you need for data - missing vars
   represent empty columns 
   */
   out = data_read (keep = var1 var2 var4 var5 var11 var12)
   dbms=csv
   out=t2
   ;
   guessingrows=32767
   ;
   *getnames=yes - pulls the header names, only use if csv has headers 
   namerow will also tell you what line to get the names if necessary;
   getnames=no
   ;
   *Firstobs=9;
   *datarow tells you what line to start;
   datarow=9
   ;
   DELIMITER=' '
   ;
run ;
proc contents ;
run ;
proc print ;
run ;
proc export
   data=t2
   outfile="C:\temp\output.csv"
   dbms=csv
   replace
;
run ;

The problem is that the the input.csv file now contains the following statement

" Elapsed: 00:14:43.61," at the end of the file

So I am looking for way to delete the last line or find a way to delete rows that beging with "elapsed"

Re: Proc Import csv but need to delete last line

art297 — Thu, 11 May 2017 17:36:47 GMT

Here is one possible solution: replace the first two lines of your script:

proc import 
   datafile="c:\temp\input.csv"

with

filename FT16F001 temp; 
data _null_; 
  infile "c:\temp\input.csv";
  file FT16F001;
  input; 
  if _infile_ eq: 'Elapsed' then stop; 
  put _infile_; 
run;

proc import 
   datafile=FT16F001

Art, CEO, AnalystFinder.com

topic Re: Proc Import csv but need to delete last line in SAS Programming

Proc Import csv but need to delete last line

Re: Proc Import csv but need to delete last line