topic Re: The Import/Export facility is not supported on this operating system in SAS Programming

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

vannu — Fri, 26 Oct 2018 06:47:44 GMT

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;

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

Kurt_Bremser — Fri, 26 Oct 2018 07:15:12 GMT

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.

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

andreas_lds — Fri, 26 Oct 2018 07:37:29 GMT

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_;