Is there a way to hide columns in my excel output using ods tagsets.excelxp? I tried using the HIDDEN_COLUMNS option and it wouldn't work.
Thanks!
Anne
Its easier to update.
Get the new code from here and run it. Apparently 1.127 is the latest anyways
or here:
Verify that you're using the latest version of the tagsets.
When you use it, it puts a note in the log specifying the version #.
I think this is the latest version:v1.124, 08/12/2011
If you are and it still isn't working, its probably helpful if you post the code you couldn't get to work.
I'm using an older version - v1.122, 01/04/2011. Is there a different option to hide columns?
Its easier to update.
Get the new code from here and run it. Apparently 1.127 is the latest anyways
or here:
It worked! Thanks so much!
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.