BookmarkSubscribeRSS Feed
deleted_user
Not applicable
I need to know if there is a way to export a SAS dataset to a specific group of cells without using DDE.

Basically, I am trying to build an automated process that will fill out an Excel Spreadsheet before I come to work in the mornings. It has to be very specific and fill in specific cells of the form, while not changing the rest of the documentation within the form.

Thank you,
Darren
1 REPLY 1
deleted_user
Not applicable
Run a CSV from SAS, which the Excel spreadsheet links to directly. When you open Excel, Excel will run a refresh and update the data as intended.

You can link in either of two ways. Setup a manual link from worksheet to CSV or use the Data, Import External data, import option - which you can even set to update every five minutes if you want.

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!

Discussion stats
  • 1 reply
  • 876 views
  • 0 likes
  • 1 in conversation