The Import/Export facility is not supported on this operating system

[vannu]

Hi, Im trying to export mainframe sas dataset to excel output , and my saslog says " The Import/Export facility is not supported on this operating system." is there any solution to solve this? so that i  can easily  export sas data set as excel output.

code i used :-

PROC EXPORT DATA=SASHELP.CARS                             
OUTFILE='C:\USERS\DOWNLOADS\EXTRA\SASCARS.XLSX'
DBMS=XLSX                                                 
REPLACE;                                                  
RUN;                                                     

[Kurt_Bremser]

Write your SAS data to a flat file (either fixed columns, or delimited), and use that for the data exchange with external applications.

CSV (comma separated) works best.

[andreas_lds]

If SAS runs on mainframe it is unlikely that you can access the C-drive of your windows computer. But before that problem can be solved you need to check which SAS version is installed on the mainframe. Have a look at the automatic variables using %put _automatic_;