topic Exporting multiple SAS tables to Specific Excel cells in SAS Enterprise Guide

Exporting multiple SAS tables to Specific Excel cells

asweeney — Thu, 04 Mar 2021 11:37:26 GMT

Hi. I am using Enterprise guide to export multiple tables to a single sheet into specific cells in Excel. The goal would be to use a macro for each table and the cell ranges for the export. I know I cant use proc export due to not being able to export to specific cells, and I have tried ODS excel but every time my file is corrupt and I cant open it. I am relatively new to SAS and have searched the forums to no success. I would greatly appreciate any advice! Thanks everyone!

Re: Exporting multiple SAS tables to Specific Excel cells

ballardw — Thu, 04 Mar 2021 17:36:09 GMT

Suggestion: Provide a couple of small datasets, or use SAS supplied data sets like SASHELP.CLASS, show the approach you are using to place two of these into your Excel.

Run the code and show us the LOG by copying the entire log for this effort and pasting the text into a text box opened on the forum with the </>.

Can't diagnose an illness without symptoms; can't diagnose code without data and code.

Also, are you trying to place this stuff into an existing Excel file or making a new file?