In reply to Paul Kaefer.

PROC EXPORT with DBMS=XLSX can write/overwrite a specific sheet, but I don't think it can do a named range, nor an adhoc cell range.

For creating new workbooks, ODS EXCEL provides many options for embedding Excel capabilities -- formulas, filtering, freeze rows, etc.

And if you have the SAS Add-In for Microsoft Office, you can pull in SAS content into any part of your sheet. It's magical, but not driven by pure SAS code.