proc cas file exists function?

acordes — Thu, 15 Sep 2022 14:22:30 GMT

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;

Re: proc cas file exists function?

DerylHollick — Sun, 02 Oct 2022 21:59:46 GMT

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;

topic Re: proc cas file exists function? in SAS Programming

proc cas file exists function?

Re: proc cas file exists function?