topic exporting a file in SAS Programming

exporting a file

Ananyayadav — Sun, 09 Sep 2018 15:07:14 GMT

hey..i m getting error in exporting file in sas.

my code was:

proc export data=lib.car_sales
outfile='F:\SASUniversityEdition\myfolders\Book1.xlsx'
dbms=xlsx;
run;

and my error was:

ERROR: DBMS type XLSX not valid for export.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

Please help me out.

Re: exporting a file

Tom — Sun, 09 Sep 2018 15:32:48 GMT

You are either running an older version of SAS or you do not have SAS/Access to PC Files licensed.

Re: exporting a file

Reeza — Sun, 09 Sep 2018 16:52:46 GMT

Since you're using SAS University Edition, you need to export it to the myfolders location you set up. So your export should be:

proc export data=lib.car_sales
outfile='/folders/myfolders/Book1.xlsx'
dbms=xlsx;
run;

@Ananyayadav wrote:

hey..i m getting error in exporting file in sas.

my code was:

proc export data=lib.car_sales
outfile='F:\SASUniversityEdition\myfolders\Book1.xlsx'
dbms=xlsx;
run;

and my error was:

ERROR: DBMS type XLSX not valid for export.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: PROCEDURE EXPORT used (Total process time):
real time 0.01 seconds
cpu time 0.00 seconds

Please help me out.