Cutting off long file names in a list

gjacks — Tue, 19 Jun 2018 15:24:56 GMT

I am trying to pull a list of file names that are over a certain age to archive them. I can get the list to work, but the long file names are being cut off at 54 bytes. My code is below. I'm sure it's something simple I'm missing, but I haven't been able to find it with searches on here or Google.

X "find path -type f -mtime +0 -print > textfile.txt";

libname sg "path";
proc import datafile = "textfile.txt" out=sg.filename dbms=csv replace; getnames=no; datarow=1;
run;
filename outbox email "name@company.com" subject="Archive Report";
      data _null_;
      set sg.filename;
      file outbox LRECL=32767
      TO=("name@company.com")
      FROM=("name@company.com")
      ATTACH=("textfile.txt");
      if _n_=1 then do;
      put "Hello,";
      put "Message for body of email.";
      put;
      end;
      put (_all_) ($);
   run;

Re: Cutting off long file names in a list

JerryV — Tue, 19 Jun 2018 15:56:32 GMT

Try adding guessingrows=max to your proc import code.

Re: Cutting off long file names in a list

gjacks — Tue, 19 Jun 2018 16:09:19 GMT

Looks like that took care of it. Thank you!!!

topic Cutting off long file names in a list in SAS Programming

Cutting off long file names in a list

Re: Cutting off long file names in a list

Re: Cutting off long file names in a list