BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
gjacks
Calcite | Level 5

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;

1 ACCEPTED SOLUTION

Accepted Solutions
JerryV
SAS Employee

Try adding guessingrows=max to your proc import code.

View solution in original post

2 REPLIES 2
JerryV
SAS Employee

Try adding guessingrows=max to your proc import code.

gjacks
Calcite | Level 5

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 2 replies
  • 1239 views
  • 1 like
  • 2 in conversation