Hiding columns in ods tagsets.excelxp

[reyesanne]

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

[Reeza]

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.

[reyesanne]

I'm using an older version - v1.122, 01/04/2011. Is there a different option to hide columns?

[Reeza · Accepted solution]

Its easier to update.

Get the new code from here and run it. Apparently 1.127 is the latest anyways

Base SAS: ODS MARKUP

or here:

http://support.sas.com/rnd/base/ods/odsmarkup/excltags.tpl

[reyesanne]

It worked! Thanks so much!