05-11-2018 02:24 PM
I'd like to export a SAS query result to an existing Excel spreadsheet on a specific sheet tab. I have a pre-formatted template in my spreadsheet on Sheet1, that is linked to a range of cells on Sheet2. Sheet2 is where I want my data to be inserted. Is there a way to do that without creating a new spreadsheet document each time? Seems like it would be simple -- but I've spoken too soon before.
05-11-2018 09:33 PM
05-18-2018 08:51 AM
Hi Cynthia. Apologies for the delay in response. Ultimately I'd like to just develop and format the entire report in SAS and just export it to the location I need it in. This is more of a bridge process to that point. I will, however, give your suggestion a shot -- and let you know how it goes. Much appreciated!