topic Hiding columns in ods tagsets.excelxp in ODS and Base Reporting https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130747#M10779 <HTML><HEAD></HEAD><BODY><P>Is there a way to hide columns in my excel output using ods tagsets.excelxp? I tried using the <SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">HIDDEN_COLUMNS option and it wouldn't work.</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">Thanks!</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">Anne<BR /></SPAN></P></BODY></HTML> Thu, 07 Mar 2013 22:54:20 GMT reyesanne 2013-03-07T22:54:20Z Hiding columns in ods tagsets.excelxp https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130747#M10779 <HTML><HEAD></HEAD><BODY><P>Is there a way to hide columns in my excel output using ods tagsets.excelxp? I tried using the <SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">HIDDEN_COLUMNS option and it wouldn't work.</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">Thanks!</SPAN></P><P><SPAN style="color: #333333; font-family: Arial, Helvetica, Verdana, sans-serif;">Anne<BR /></SPAN></P></BODY></HTML> Thu, 07 Mar 2013 22:54:20 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130747#M10779 reyesanne 2013-03-07T22:54:20Z Re: Hiding columns in ods tagsets.excelxp https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130748#M10780 <HTML><HEAD></HEAD><BODY><P>Verify that you're using the latest version of the tagsets.</P><P>When you use it, it puts a note in the log specifying the version #.</P><P></P><P>I think this is the latest version:v1.124, 08/12/2011</P><P></P><P>If you are and it still isn't working, its probably helpful if you post the code you couldn't get to work.</P></BODY></HTML> Thu, 07 Mar 2013 22:57:17 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130748#M10780 Reeza 2013-03-07T22:57:17Z Re: Hiding columns in ods tagsets.excelxp https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130749#M10781 <HTML><HEAD></HEAD><BODY><P>I'm using an older version - v1.122, 01/04/2011. Is there a different option to hide columns?</P></BODY></HTML> Thu, 07 Mar 2013 23:01:33 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130749#M10781 reyesanne 2013-03-07T23:01:33Z Re: Hiding columns in ods tagsets.excelxp https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130750#M10782 <HTML><HEAD></HEAD><BODY><P>Its easier to update.</P><P>Get the new code from here and run it. Apparently 1.127 is the latest anyways <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P><P><A class="active_link" href="http://support.sas.com/rnd/base/ods/odsmarkup/" title="http://support.sas.com/rnd/base/ods/odsmarkup/">Base SAS: ODS MARKUP</A></P><P></P><P>or here:</P><P><A href="http://support.sas.com/rnd/base/ods/odsmarkup/excltags.tpl" title="http://support.sas.com/rnd/base/ods/odsmarkup/excltags.tpl">http://support.sas.com/rnd/base/ods/odsmarkup/excltags.tpl</A></P></BODY></HTML> Thu, 07 Mar 2013 23:03:53 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130750#M10782 Reeza 2013-03-07T23:03:53Z Re: Hiding columns in ods tagsets.excelxp https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130751#M10783 <HTML><HEAD></HEAD><BODY><P>It worked! Thanks so much! <img id="smileyhappy" class="emoticon emoticon-smileyhappy" src="https://communities.sas.com/i/smilies/16x16_smiley-happy.png" alt="Smiley Happy" title="Smiley Happy" /></P></BODY></HTML> Fri, 08 Mar 2013 14:03:15 GMT https://communities.sas.com/t5/ODS-and-Base-Reporting/Hiding-columns-in-ods-tagsets-excelxp/m-p/130751#M10783 reyesanne 2013-03-08T14:03:15Z