Another is to use a different procedure than Export.
Dummy code:
ods excel file="path/yourfilename.xlsx"; proc print data=yourdatasetname noobs label; var firstvarname secondvarname thirdvarname; run; ods excel close;
One advantage of Proc Print is that you can use variable lists. If you have variables with names like measure1, measure2, ..., measure50 you could use Measure1-Measure50 on the var statement if you want them in numeric order. Or if some of variables are already together in order in the data set but you want to place them before or after other variables you use a list with two dashes : thisvar -- thatvar. This list uses those variables in the order they appear in the dataset. Of if you want all variables whose names start with XYZ together but may not specifically care about order within the group use XYZ: the colon tells SAS to use all variable whose names start with XYZ. The order is usually alphabetic. SQL will not allow use of any of the lists constructs. So if you have many variables this may be quite a bit easier on the typing.
Additionally you can provide changes to variable label just for the print statement or style overrides such as cell colors based on values.
or use PROC TABULATE or PROC REPORT with ODS EXCEL, which would have many of the same benefits as described by @ballardw
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.