BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
SMartin_82
Fluorite | Level 6

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
johnsville
Obsidian | Level 7

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?

View solution in original post

13 REPLIES 13
Reeza
Super User
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
Fluorite | Level 6

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
Community Manager

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

 

Chris

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
SMartin_82
Fluorite | Level 6

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
Super User

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
Obsidian | Level 7

what works for me is to use DBMS=XLSX

or in your case: DBMS=XLS

SMartin_82
Fluorite | Level 6

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

johnsville
Obsidian | Level 7

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
Fluorite | Level 6

Hi,

 

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

 

BR, Silke

TajisDawn
Calcite | Level 5

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
Community Manager

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.

It's time to register for SAS Innovate! Join your SAS user peers in Las Vegas on April 16-19 2024.
TajisDawn
Calcite | Level 5

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
Fluorite | Level 6

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

 

 

 

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

What is Bayesian Analysis?

Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 13 replies
  • 39243 views
  • 1 like
  • 6 in conversation