- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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!
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
My recommendation would be to work with Tech Support on this. They would need more information about your SAS Viya installation and connected drives and permissions to help you with this question. To open a track with Tech Support, fill out the form at this link: http://support.sas.com/ctx/supportform/createForm .
Cynthia
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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;