BookmarkSubscribeRSS Feed
EH
Obsidian | Level 7 EH
Obsidian | Level 7

Hello all,

 

I often use Send to Excel to export my output dataset for further use in Excel. EG then starts a separate session of Excel, also when Excel is already open. Is it also possible to Send the output to a new Workbook in an existing Excel session? I am running EG 6.1.

 

When having two separate Excel sessions, I cannot use copy - paste values. Also, I cannot use formulas from the first Excel to the second session.

 

Hope my problem is clear!

 

Thanks for your suggestions,

 

Cheers,

Eric

10 REPLIES 10
RW9
Diamond | Level 26 RW9
Diamond | Level 26

It sounds like one of two issues, and I don't use EG so not sure which.  First, it could be that EG is using something could DDE to send the data to Excel.  This is very old technology and really shouldn't be used at all anymore.  If you want to create output, then use one of the new tech's, e.g. tagsets.excelp, libname excel, even proc export.  As I said though I don't use EG so don't know if that is indeed the problem.

 

The other issue could be Excel's object instance, generally speaking Office objects like to be exclusive, i.e. one object, within multiple workbooks within it.  Depending on implementation.  

 

At the end of the day however the best recommendation when anyone mentions the name, is not use Excel at all for any purpose as it was never designed to do <insert what you want to do with it here>.

SASKiwi
PROC Star

When I use Send to Excel in EG say from the Output window a box pops up saying do I want to open a new workbook/session or add to an existing workbook/session. Does that not happen for you?

EH
Obsidian | Level 7 EH
Obsidian | Level 7

No it is not the case.

 

Doc says: "You can send the results to a new document or an active document. If you send the results to an active document and you have multiple documents open, you can select which document to send the results to."

 

This question is not asked.

 

So please when any of the SAS employees has arrived...

 

After reading more of the same doc, it seems that I have to install the SAS Add-In for Microsoft Office. After I did, nothing changes. The other way around also does not work: I can choose "Open a SAS data source" from Excel, but it does not show my own (WORK) datasets or any of my own defined libraries.

 

Thanks for your reply!

 

Cheers,

Eric

Loko
Barite | Level 11

Hello,

 

Have you tried writing the table in a library defined within metadata and afterwards trying to open the table using Sas Add-Inn?

 

I use this technique quite often and there is no problem to have the data in the same excel session.

 

 

EH
Obsidian | Level 7 EH
Obsidian | Level 7

Thanks,

 

Those metadata is readonly for me. I define my libraries by "submit sas code when server is selected". Still, it is a start!

 

Thanks again,

Eric

SASKiwi
PROC Star

I'm using EG 7.11 and SAS Add-In 7.1 and I get this window:

 

screenshot11.jpg

EH
Obsidian | Level 7 EH
Obsidian | Level 7
Unfortunately I do not get this popup. However, I have seen it before, so maybe it is a configuration issue? Thanks! Eric
EH
Obsidian | Level 7 EH
Obsidian | Level 7

Rethinking, it may have something to do with the fact I am running EG on a BI Server. That server apparently is capable of starting an Excel session on my PC and dumping data into that session, but it probably cannot join an existing Excel session. Can somebody confirm this, or is there hope for me :-). Cheers, Eric

SASKiwi
PROC Star

So do you remotely logon to your BI Server and run EG there? If so EG would only know about server Excel sessions not your PC Excel sessions.

 

Try opening Excel first on your BI server before a send. Do you get the window pop up then?

EH
Obsidian | Level 7 EH
Obsidian | Level 7

No, EG is running on my PC sending SAS commands to the BI Server and receiving output in the output tab. That output can be sent to Excel, but only to a new Excel session for every other dataset.

 

Eric

 

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!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

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
  • 10 replies
  • 1981 views
  • 3 likes
  • 4 in conversation