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!
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.
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.
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 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.