BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
acordes
Rhodochrosite | Level 12

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;
1 ACCEPTED SOLUTION

Accepted Solutions
DerylHollick
SAS Employee

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;

View solution in original post

1 REPLY 1
DerylHollick
SAS Employee

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;
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
  • 1 reply
  • 1387 views
  • 0 likes
  • 2 in conversation