BookmarkSubscribeRSS Feed
0 Likes

We can specify a range when importing from excel but we need a named range defined within the worksheet to be able to write to it.  That should be fixed.

5 Comments
art297
Opal | Level 21

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

 

tomrvincent
Rhodochrosite | Level 12

Nope...Linux.

HenryFeldman
SAS Employee

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

 

You want to specify the name?

 

Henry

art297
Opal | Level 21

@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

 

HenryFeldman
SAS Employee
Correct, the code currently doesn't support inserting cells into an existing sheet.