Hi, I'm very new to SAS and have been struggling to accomplish this seemingly simple task. For starters, perhaps it's best I describe what I'm trying to achieve. Our organization has a customer who wishes to streamline their process by running a program that downloads a specific file into their SAS environment. We both have SAS environments although I'm using SAS Studio Viya LTS and they're using "SAS desktop" (i'm honestly not sure what they're meaning though with that term). What i've gathered so far, is that before they can download anything, we need to produce a physical file. i've done that by running proc casutil;
save casdata="filename" incaslib="src" outcaslib="public" casout="filename.csv" replace;
run; If I navigate to the Public folder within Manage Data I can see the file there. Additionally, if I also run: proc cas;
table.fileinfo / caslib="Public";
quit;
proc cas;
session mySession;
caslibinfo /;
quit; I can also see it. It's at this point that I'm stuck. I've tried using the following: %macro get_csv;
ods _all_ close;
filename jobout filesrvc folderpath='/Public/' filename="filename.csv";
%let file_exists = %sysfunc(fexist(jobout));
%put File exists: &file_exists;
%mend;
%put %get_csv; The output of that though is 0 which I don't understand since I can visually see that it's indeed in the Public folder. What am I missing and what can I add to this to solve the problem?
... View more
