I recently migrated bulk of my SAS functions to EG 5.1 and was quite surprised to learn that SAS EG does not create NAMED RANGE on Excel exports. I learned this was a design decision after submitting a SAS Support ticket. The NAMED RANGE has been a cornerstone of my SAS-to-Excel PIVOTanalysis assembly line and the absence is a critical gap to my present analysis process.
I rely on the NAMED RANGE (in Excel output) so that PIVOT Table reports (in Excel) don't have to be constantly maintained to point to a specific/explicit range (that changes everytime I refresh the exported data) such as A1:XX32443 to A1:XY32558.
From EG, I mostly export to EXCEL "on the fly" from the dataset "view" rather than via an Export node. Maybe the Export node creates a NAMED RANGE but since I mostly am doing adhoc research I don't create overly fancy EG process flows (in fact I pretty much avoid it -- too messy IMO).
Please bring back (or add) NAMED RANGE support to all of the EXPORT (to Excel) functions in EG!!