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

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

Ivan555 — Mon, 27 May 2019 10:05:49 GMT

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!

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

Kurt_Bremser — Mon, 27 May 2019 10:35:36 GMT

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.

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

Ivan555 — Mon, 27 May 2019 10:45:52 GMT

Understood, thank you much!