BookmarkSubscribeRSS Feed
joshspurgin
Calcite | Level 5

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!

1 REPLY 1
Reeza
Super User

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&docsetVe...

 

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!


 

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1755 views
  • 0 likes
  • 2 in conversation