I am looking for the sibling of the tableExists function...
If file exists, but it's not as straightforward as I thought.
%let casy=FSVBALA_&fc._OUTLIER;
%let liby=risknoba;
cas mysession sessopts=(caslib="&liby");
proc cas;
table.tableExists result=e status=rc /
caslib = "&liby"
name = "&casy"
;
/* If the data exists, set dataExists = 1 and grab the current report data */
if(e.exists = 0) then do;
table.loadtable / path="&casy..sashdat" casOut="&casy" caslib="&liby";
table.promote /name="&casy" ;
print "hello";
end;
run;
I think fileInfo can be used.
caslib myCaslib datasource=(srctype="path") path="&path";
proc cas; table.fileInfo result=r / caslib="myCaslib"; filelist = r.FileInfo[,"Name"]; if (filelist == "my_file.txt") then print "my_file.txt exists"; quit;
I think fileInfo can be used.
caslib myCaslib datasource=(srctype="path") path="&path";
proc cas; table.fileInfo result=r / caslib="myCaslib"; filelist = r.FileInfo[,"Name"]; if (filelist == "my_file.txt") then print "my_file.txt exists"; quit;
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
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.
Ready to level-up your skills? Choose your own adventure.