Anyone know what happened to that? it used to be at http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export but that's a dead link.
I don't know if it would work on Linux but I'm willing to try.
You can find the "A Poor/Rich SAS User’s Proc Export" paper at 1793-2014.pdf (sas.com)
May the SAS be with you 🙂
Mark
So, then, this is probably most of what you're looking for:
Papers/exportxl.sas at master · art297/Papers (github.com)
I forget the reason, but sascommunity.org was nuked several years ago. There was an effort to migrate much of the content here to articles, but not sure how successful that was.
Working with the volunteer team that managed sasCommunity.org, we moved most of the unique/popular content to this community site and decommissioned the sasCommunity.org site. It was hosted on a 3rd-party platform -- which has a cost in both fees and people to manage. The traffic had reduced considerably, especially after much of the content moved here. It was a long process but all those involved agreed it was the right time to do this.
More information about exportxl is here. I reviewed the code recently and I think it relies on SAS code to generate VB Script to automate Excel. Effective method, but that won't work on its own on Linux.
We usually recommend ODS Excel to people who need more control over the Excel documents they create: formatting, formulas, etc. However ODS Excel always creates a new workbook file, and cannot update existing spreadsheets.
One possible approach (which I have not tried) in SAS Viya is to use the Python library called OpenPyXL. You would add this Python library to the Python installation where SAS Viya runs, and then use PROC PYTHON to alter the Excel file with Python code. You could use SAS to generate the values you need, then PROC PYTHON to drive those values into a spreadsheet file, and then publish/download the Excel file where you need it.
@tomvincent wrote:
I ***HATE*** when companies do that. They should just keep the old pages and set them to read-only. grrr...
It wasn't company managed, people managed aka open source.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.
Ready to level-up your skills? Choose your own adventure.