While I've marked this as a question, that was only to allow it to be seen.
The exportxl macro, written by Tom Abernathy, Matt Kastin (FriedEgg) and myself, has been updated to enable it to run on server based versions of SAS. I've mentioned this in a recent discussion but, in the event that you weren't following that thread, wanted to make sure that you knew about the changes we've made to the macro.
The macro lets one export SAS datasets to Excel without having to license SAS/Access for PC File Formats, not run into those annoying 32/64 bit incompatibilities, and lets one create new workbooks, create new worksheets, modify existing worksheets, take advantage of Excel templates, write to non-pre-defined ranges, export variable names or labels or neither, and export formatted or unformatted values.
Previously, the macro wouldn't work in server environments, but now it can with the new code that is available at: https://github.com/art297/Papers/blob/master/Excelling_to_Another_Level_with_SAS/src/exportxl.sas
and the paper, powerpoint and tip sheet can be found at:
https://github.com/art297/Papers/tree/master/Excelling_to_Another_Level_with_SAS/doc
In addition to all of the above, the macro is faster than all other methods for exporting to Excel if you're running on a stand-alone version of SAS in a Window's environment.
Art
p.s. This is not a product we are trying to sell but, rather, free use-at-your-own-risk code
Thanks, Art, for the headsup!
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Select SAS Training centers are offering in-person courses. View upcoming courses for: