The SAS Output Delivery System and reporting techniques

Hiding columns in ods tagsets.excelxp

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Hiding columns in ods tagsets.excelxp

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


Accepted Solutions
Solution
‎03-07-2013 06:03 PM
Super User
Posts: 19,100

Re: Hiding columns in ods tagsets.excelxp

Its easier to update.

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

Base SAS: ODS MARKUP

or here:

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

View solution in original post


All Replies
Super User
Posts: 19,100

Re: Hiding columns in ods tagsets.excelxp

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.

New Contributor
Posts: 4

Re: Hiding columns in ods tagsets.excelxp

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

Solution
‎03-07-2013 06:03 PM
Super User
Posts: 19,100

Re: Hiding columns in ods tagsets.excelxp

Its easier to update.

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

Base SAS: ODS MARKUP

or here:

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

New Contributor
Posts: 4

Re: Hiding columns in ods tagsets.excelxp

It worked! Thanks so much! Smiley Happy

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 4 replies
  • 1064 views
  • 0 likes
  • 2 in conversation