Looking for Skip_Space Equivalent with ODS EXCEL

joshspurgin — Tue, 08 Jan 2019 20:30:21 GMT

I have read through a lot of posts but haven't found a recent answer or discussion just yet. I am eager to make the jump to using ODS EXCEL instead of TAGSETS.EXCELXP. At the moment, the main thing preventing that is that I have a lot of programs that use the SKIP_SPACE option and I have yet to find an ODS EXCEL equivalent available. Is there something available to perform the same functionality with ODS EXCEL or is this still not available in ODS EXCEL in any way?

At the time of this article from February 2017, it was not a recognized function but I was hoping that might have changed in the last two years.

Thanks!

Re: Looking for Skip_Space Equivalent with ODS EXCEL

Reeza — Tue, 08 Jan 2019 20:44:29 GMT

FYI - I moved your question to the ODS forum, which is more appropriate.

AFAIK, that hasn't been added, the documentation doesn't have it listed.

https://documentation.sas.com/?docsetId=odsug&docsetTarget=p09n5pw9ol0897n1qe04zeur27rv.htm&docsetVersion=9.4&locale=en

I do believe that's controlled by the template style though, so you can look into modifying the style template. The hardest part is figuring out which part of the template you need to change.

@joshspurgin wrote:

I have read through a lot of posts but haven't found a recent answer or discussion just yet. I am eager to make the jump to using ODS EXCEL instead of TAGSETS.EXCELXP. At the moment, the main thing preventing that is that I have a lot of programs that use the SKIP_SPACE option and I have yet to find an ODS EXCEL equivalent available. Is there something available to perform the same functionality with ODS EXCEL or is this still not available in ODS EXCEL in any way?

At the time of this article from February 2017, it was not a recognized function but I was hoping that might have changed in the last two years.

Thanks!

topic Looking for Skip_Space Equivalent with ODS EXCEL in ODS and Base Reporting

Looking for Skip_Space Equivalent with ODS EXCEL

Re: Looking for Skip_Space Equivalent with ODS EXCEL