ERROR: DBMS type EXCEL not valid for export

[SMartin_82]

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

[Reeza]

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

proc setinit; run;

[SMartin_82]

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               

[ChrisHemedinger]

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

Chris

[SMartin_82]

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.

[Reeza]

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

[johnsville]

what works for me is to use DBMS=XLSX

or in your case: DBMS=XLS

[SMartin_82]

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

[johnsville · Accepted solution]

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?

[SMartin_82]

Hi,

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

BR, Silke

[TajisDawn]

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

[ChrisHemedinger]

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.

[TajisDawn]

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).

[JoseAlbertoRami]

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