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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
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.