topic Re: PROC EXPORT with SAS Studio in VIYA in SAS Studio

PROC EXPORT with SAS Studio in VIYA

Clém — Thu, 21 Oct 2021 10:01:42 GMT

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!

Re: PROC EXPORT with SAS Studio in VIYA

Cynthia_sas — Thu, 21 Oct 2021 18:00:03 GMT

Hi:
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

Re: PROC EXPORT with SAS Studio in VIYA

Kurt_Bremser — Thu, 21 Oct 2021 18:04:25 GMT

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.

Re: PROC EXPORT with SAS Studio in VIYA

Clém — Wed, 27 Oct 2021 16:31:11 GMT

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;