Export with Error Excel file

hhchenfx — Wed, 07 Jun 2017 19:06:04 GMT

Hi,

I have big trouble exporting my small file to Excel.

PROC EXPORT 
data=T1
outfile="&export_folder.\T1.xls"
DBMS=xls
replace;
run;

That code creates a excel file but when I click it, the following notice show up:

"We found a problem with some content in "T1". Do you want us to try to recover as much as we can? If you trust the source of this workbook click Yes".

Sometime, it allow me to open in the "protected mode" where basically I can only see but cant change, edit the file.


PROC EXPORT 
data=T1
outfile="&export_folder.\T1.xlsx"
DBMS=xlsx
replace;
run;

ERROR: XLSX is not yet supported by proc export.

PROC EXPORT 
data=T1
outfile="&export_folder.\T1.xlsx"
DBMS=EXCELCS
replace;
run;

ERROR: Failed to connect to the Server: .

When I export using CSV and DBMS=CSV, it works.

Below is my SAS info.

Can anyone help me with this problem?

Thanks a lot.

proc setinit; run;

Operating System: WX64_WKS.

Product expiration dates:

---Base SAS Software

14NOV2017

---SAS/STAT

14NOV2017

---SAS/GRAPH

14NOV2017

---SAS/ETS

14NOV2017

---SAS/FSP

14NOV2017

---SAS/OR

14NOV2017

---SAS/AF

14NOV2017

---SAS/IML

14NOV2017

---SAS/QC

14NOV2017

---SAS/SHARE

14NOV2017

---SAS/LAB

14NOV2017

---SAS/ASSIST

14NOV2017

---SAS/CONNECT

14NOV2017

---SAS/INSIGHT

14NOV2017

---SAS/EIS

14NOV2017

---SAS/GIS

14NOV2017

---SAS/SHARE*NET

14NOV2017

---SAS Enterprise Miner

14NOV2017

---MDDB Server common products

14NOV2017

---SAS Integration Technologies

14NOV2017

---SAS/Secure Windows

14NOV2017

---SAS Text Miner

14NOV2017

---SAS/Genetics

14NOV2017

---SAS Enterprise Guide

14NOV2017

---SAS Bridge for ESRI

14NOV2017

---OR OPT

14NOV2017

---OR PRS

14NOV2017

---OR IVS

14NOV2017

---OR LSO

14NOV2017

---SAS/ACCESS Interface to DB2

14NOV2017

---SAS/ACCESS Interface to Oracle

14NOV2017

---SAS/ACCESS Interface to Sybase

14NOV2017

---SAS/ACCESS Interface to PC Files

14NOV2017

---SAS/ACCESS Interface to ODBC

14NOV2017

---SAS/ACCESS Interface to OLE DB

14NOV2017

---SAS/ACCESS Interface to Teradata

14NOV2017

---SAS/ACCESS Interface to MySQL

14NOV2017

---SAS Enterprise Miner for Desktop

14NOV2017

---SAS/IML Studio

14NOV2017

---SAS Workspace Server for Local Access

14NOV2017

---SAS/ACCESS Interface to Netezza

14NOV2017

---SAS/ACCESS Interface to Aster nCluster

14NOV2017

---SAS/ACCESS Interface to Greenplum

14NOV2017

---SAS/ACCESS Interface to Sybase IQ

14NOV2017

---DataFlux Trans DB Driver

14NOV2017

---SAS Framework Data Server

14NOV2017

---Reserved for Dataflux

14NOV2017

---SAS Add-in for Microsoft Excel

14NOV2017

Re: Export with Error Excel file

ballardw — Thu, 08 Jun 2017 15:06:32 GMT

The first error indicates that you may have data content issues. It that case we can't help much without data. You might try exporting to CSV and open the result with Excel or other spreadsheep program to see if that behaves the same. If you get data issues you can then open in Wordpad or similr text editor to look for anything strange.

The other errors may be related to the bitness of SAS (64) and the version of Office products installed (if they are 32 bit).

Connection to server problems you'll need to describe more of your install such as are you use EG Studio or DM and the server and its OS.

topic Re: Export with Error Excel file in SAS Programming

Export with Error Excel file

Re: Export with Error Excel file