Nick,
I'd like to resolve the matter before I present the macro at SGF in a week and a half. Please contact me, offline tomorrow, at:
atabachneck@gmail.com I didn't understand your last message as you said that you'd use:
c:\nick\Dropbox\test.xlsx
instead of
c:\nick\Dropbox\test.xlsx
They look the same to me. I tested the macro, before posting it, thus would really like to figure out what the problem is.
Art
For anyone who has been following this thread, the 'need' that Nikolaos had caused us to revise the macro we had written so that it would be useful both as an action command from the SAS Explorer window and as a macro that one can call from either base SAS or EG.
Plus, in the process of accomplishing those modifications, we decided to expand it to include the capabilities of:
1. including a variable name header row than can display either variable names or variable labels
2. including the abilities to either create a new workbook, add a worksheet to an existing workbook
3. copy a table to a range of either a new Workbook, an existing worksheet, or a new worksheet
The published paper, unfortunately, won't reflect the updated code, but the code,powerpoint and updated paper can all be downloaded from:
A Poor/Rich SAS Users Proc Export - sasCommunity
BTW, many thanks to Nokolaos as, while we were trying to help him, he helped us by testing the code.
Art
Glad to help and, of course, to be helped! It is a very good piece of work.
Cheers,
Nick
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 25. 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.