topic Re: ERROR: DBMS type EXCEL not valid for export in SAS Procedures

ERROR: DBMS type EXCEL not valid for export

SMartin_82 — Thu, 11 Feb 2016 08:42:03 GMT

Hello,

I tried to get my dataset to excel file, but it didn't work:

PROC EXPORT
DATA=export
DBMS=Excel5
OUTFILE='path\datafile.xls'
REPLACE;
RUN;

I also tried DMBS=excels and excel. I read, that there is a problem for SAS with the 64-bit 'Windows' operating system. I use SAS Base 9.4.

Did someone solve this problem?

BR, Silke

Re: ERROR: DBMS type EXCEL not valid for export

Reeza — Thu, 11 Feb 2016 09:13:25 GMT

Do you have a license for SAS/Access to PC Files? You should see it if you run the following:

proc setinit; run;

Re: ERROR: DBMS type EXCEL not valid for export

SMartin_82 — Thu, 11 Feb 2016 09:58:53 GMT

I don't think so...

Base SAS Software
SAS/STAT
SAS/GRAPH
SAS/Secure 168-bit
SAS/Secure Windows
SAS Enterprise Guide
SAS Workspace Server for Local Access
High Performance Suite

Re: ERROR: DBMS type EXCEL not valid for export

ChrisHemedinger — Thu, 11 Feb 2016 13:57:42 GMT

Try ODS EXCEL to create an XLSX file. You need just Base SAS. Here are some examples.

Chris

Re: ERROR: DBMS type EXCEL not valid for export

johnsville — Thu, 11 Feb 2016 17:43:03 GMT

what works for me is to use DBMS=XLSX

or in your case: DBMS=XLS

Re: ERROR: DBMS type EXCEL not valid for export

SMartin_82 — Fri, 12 Feb 2016 07:34:33 GMT

I tried DBMS=XLS but it didn't work too

Re: ERROR: DBMS type EXCEL not valid for export

SMartin_82 — Fri, 12 Feb 2016 07:35:29 GMT

I tried this:

ods excel file='path\test.xls';
proc print data=data;
run;
ods excel close;

But I got out this warning and error messages:

WARNING: Unsupported device 'ACTIVEX' for EXCEL destination. Using device 'ACTXIMG'.
ERROR: The SAS System stopped processing this step because of insufficient memory.

Re: ERROR: DBMS type EXCEL not valid for export

johnsville — Fri, 12 Feb 2016 13:29:05 GMT

1) you have large file and a memory error...

2) My understanding is that if proc setinit does not yield something like this:

---SAS/ACCESS Interface to PC Files

you cannot do DBMS=XLS or XLSX.

Probably then you cannot do DBMS=EXCELCS, either.

What if you were to use

DBMS=CSV

which EXCEL will read?

Re: ERROR: DBMS type EXCEL not valid for export

Reeza — Fri, 12 Feb 2016 14:58:46 GMT

You don't appear to have a license to export Excel/Access files. It's probably worth chatting with whomever licenses SAS in your enterprise to obtain the license.

A workaround is to use the macro here:

http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export

Re: ERROR: DBMS type EXCEL not valid for export

SMartin_82 — Wed, 17 Feb 2016 09:22:02 GMT

Hi,

I tried DBMS=CSV -> it works. But it didn't work with xls.

BR, Silke

Re: ERROR: DBMS type EXCEL not valid for export

TajisDawn — Thu, 24 Mar 2016 13:25:29 GMT

I get the same warning: "WARNING: Unsupported device 'ACTIVEX' for EXCEL destination. Using device 'ACTXIMG'." but I do get an exported file. I'm using ODS Excel with proc report on Base (local) SAS. My reports seem to be fine but I have to be careful reading my log because sometimes I forget that other warnings may be masked by the one I know I see.

Does anyone know how to get ACTIVEX over AXTXIMG? Or is it something our company hasn't purchased? I'm on E.G 6.1 and SAS 9.4

Re: ERROR: DBMS type EXCEL not valid for export

ChrisHemedinger — Thu, 24 Mar 2016 13:52:07 GMT

You can change your settings in Tools->Options->Results: Graphs to generate PNG instead of ActiveX -- that will eliminate the warning and give you a clean log.

Re: ERROR: DBMS type EXCEL not valid for export

TajisDawn — Thu, 24 Mar 2016 14:25:59 GMT

Thank you. That worked. Now the only warning occurs when I have more than 262 characters, which does occur at times but not always (diagnosis code list vary in length).

Re: ERROR: DBMS type EXCEL not valid for export

JoseAlbertoRami — Tue, 09 Jan 2018 09:15:53 GMT

It happens kind of the same to me in my local PC, at the time of importing a specific range from an excel sheet.

PROC IMPORT DATAFILE="..."
OUT=work.SHEET
DBMS=XLSX
REPLACE;
GETNAMES=YES;
RANGE="SHEET$RANGE";
RUN;

ERROR: DBMS type XLSX not valid for export

However, if I switch connection to SASApp Server and upload the file into a server path, it works fine.

I think this post has been correctly answer previously, since in SASApp:

PROC PRODUCT_STATUS;
RUN;

among the products returned is.

For SAS/ACCESS Interface to PC Files ...
Custom version information: 9.3_M2

which in my case, is not supported for Local