exporting a file

[Ananyayadav]

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.

[Tom]

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

[Reeza]

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.

---