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;
Try adding guessingrows=max to your proc import code.
Try adding guessingrows=max to your proc import code.
Looks like that took care of it. Thank you!!!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.