DATA Step, Macro, Functions and more

Export with Error Excel file

Accepted Solution Solved
Reply
Super Contributor
Posts: 371
Accepted Solution

Export with Error Excel file

[ Edited ]

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.

 

HC

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

 


Accepted Solutions
Solution
‎06-13-2017 04:53 PM
Super User
Posts: 10,500

Re: Export with Error Excel file

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.

View solution in original post


All Replies
Solution
‎06-13-2017 04:53 PM
Super User
Posts: 10,500

Re: Export with Error Excel file

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.

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 92 views
  • 0 likes
  • 2 in conversation