Desktop productivity for business analysts and programmers

populate specific cells in excel using SAS/EG

Reply
New Contributor
Posts: 2

populate specific cells in excel using SAS/EG

Hello,

 

I receive 100 monthly files already pre-populated with extensive data from an Oracle database. I need to add 5 numbers from a SAS dataset to specific cell locations in each file. I'm using Enterprise Guide and don't have DDE, nor is copy/paste an efficient approach.

 

Before anyone asks, I cannot re-create the excel files and don't have access to the Oracle source data. And I know DDE is frowned upon, but it would work perfectly in this case since it gives direct control to populate specific cells. Alas,...,

 

I've been tinkering with the libname PCFILES option to connect to an excel file (which works successfully!), and then trying various strategies to populate the specific cells. This is where I'm stuck, was wondering if the sql update option could work (something along the lines of - update myxls.'Sheet1$'n) but not sure how to reference the cells and not just the sheet.

 

Any suggestions on the above or in general would be appreciated!

 

Thanks,

Bart

Respected Advisor
Posts: 3,063

Re: populate specific cells in excel using SAS/EG

This is one possible solution:

 

A Poor/Rich SAS Users Proc Export - sasCommunity

 

 

Ask a Question
Discussion stats
  • 1 reply
  • 229 views
  • 0 likes
  • 2 in conversation