An Idea Exchange for SAS software and services

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:


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,


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


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?



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,


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