Hello!
We have just installed SAS VIYA, including SAS Studio module but we were used to use SAS9.x, and so it seems that we are not able to use anymore some PROC, expecially the PROC Export. Indeed we try to export .csv files with a | delimiter with the following code (from SAS snippets)
proc export data=WORK.FINAL
outfile="\Public\SAS Validation Tests\TEST #7\final1.csv"
dbms=csv
replace;
delimiter="|";
run;*/
But either we have an error like "file doesn't physically exist" or the file is created as per log but we can't find the file at the location we defined within the SAS server... (We do not want to export it localy but in the server).
Does any one would like to kindly help us?
Many thanks!
Thanks @Cynthia_sas and @Kurt_Bremser for your answers.
For information we finally succeed with this type of code, including FILESRVC:
FILENAME REFFILE FILESRVC FOLDERPATH='/Public/tests' FILENAME='final1.csv';
proc export data=WORK.FINAL
outfile=REFFILE
dbms=csv
replace;
delimiter="|";
run;
The CAS backend of Viya runs on Linux, so you canno use backslashes in path names. Also keep in mind that CAS uses its own clustered file storage, which is not like a physical filesystem.
Thanks @Cynthia_sas and @Kurt_Bremser for your answers.
For information we finally succeed with this type of code, including FILESRVC:
FILENAME REFFILE FILESRVC FOLDERPATH='/Public/tests' FILENAME='final1.csv';
proc export data=WORK.FINAL
outfile=REFFILE
dbms=csv
replace;
delimiter="|";
run;
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.
Find more tutorials on the SAS Users YouTube channel.