An Idea Exchange for SAS software and services

Comments
by PROC Star
on ‎02-22-2018 02:40 PM

I agree with your recommendation. However, if you're on a Window's system and want that capability now, take a look at:

http://www.sascommunity.org/wiki/Excelling_to_Another_Level_with_SAS

 

The macro described in that paper can already do what you're suggesting, as well as a number of other tasks that I wish were included in PROC EXPORT.

 

Art, CEO, AnalystFinder.com

 

by Regular Contributor
on ‎02-22-2018 03:04 PM

Nope...Linux.

by SAS Employee HenryFeldman
on ‎02-23-2018 09:49 AM

The XLSX export code builds a range with the same name as the sheet.

 

You want to specify the name?

 

Henry

by PROC Star
on ‎02-23-2018 10:52 AM

@HenryFeldman: I can't speak for @tomrvincent, but I don't think that proc export for xlsx can do the following. I have an existing worksheet and I want to paste sashelp.class into that worksheet, using a rectangle beginning at cell G10 and do so without affecting any of the worksheet's cells that are outside of that range.

 

Art, CEO, AnalystFinder.com

 

by SAS Employee HenryFeldman
on ‎02-23-2018 11:11 AM
Correct, the code currently doesn't support inserting cells into an existing sheet.


Idea Statuses
Top Liked Authors