- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
WHERE TO GET THE MACRO
We did our best to only include carefully written and tested code, but the code may have to be updated from time to
time to correct for errors or enhancements that we or others might discover. Additionally, while a copy of the macro is
included in this paper, copying and pasting from a pdf file often introduces stylish looking quotation marks which
aren’t correctly recognized by SAS. As such, we created a page for the paper on sasCommunity.org. The page
includes copies of the source code and updated versions of this paper. The page can be found at:
http://www.sascommunity.org/wiki/A_Poor/Rich_SAS_Users_Proc_Export
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
So, then, this is probably most of what you're looking for:
Papers/exportxl.sas at master · art297/Papers (github.com)
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I wonder what happened to that wiki site and why it was nuked... 😞
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
Next webinar will be in January 2025. Until then, check out our archives: https://www.basug.org/videos. And be sure to subscribe to our our email list.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
I think I suggested years ago that SAS have the ability to write to a range (since it can *read* from one)...maybe fix that damned white space bug at the same time...:(
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content