Export tables from SAS(UNIX-platform) to MS Windows-platform

[Ivan555]

Hello!

I've got SAS 9.4, workmachine on MS Widows OS(with active access Interface to PC Files), SAS on UNIX OS

While running code:

proc sql;
create table t1 (id int, typ int, dt char(8), qty int);
insert into t1 
values (1, 2, '20190325', 50)
 values (2, 2, '20190320', 15)
  values (3, 3, '20190401', 50);
quit;

filename = tratata "С:\!lib\2.xlsx";

PROC EXPORT DATA = t1
  DMBS = xlsx
  OUTFILE = tratata replace;
  SHEET = "T1";
RUN;

I am getting error:

ERROR:Temporary file for XLSX file can not be created  -> /home/SASoft/SASConfig/Lev1/SASApp/C:\!lib\/2.$$1. Make sure path name is correct and that you have write permissions.

Can't you say, is it possible to export file not on internal SAS folderpath(where access is denied), but on the MS Windows folderpath, being specified in the code?

Thx!

[Kurt_Bremser · Accepted solution]

A SAS process can write output only to locations that are available to it on the operating system level.

Your SAS runs on a UNIX server, so you can only use locations on that UNIX server.

If you have an active mount of a Windows resource on UNIX, you can use it. But you have to use UNIX filename syntax, of course. Drive letters and backslashes are only used on Windows.

Get in touch with your system administrators, they can advise you what's best with your setup.

[Ivan555]

Understood, thank you much!