BookmarkSubscribeRSS Feed
smm662002
Quartz | Level 8

Hello,

I am trying to create an Excel report using Tagset.excelXP.

I would like to create the report from column B instead of column A and let the column A blank.

Would it be possible to do this by using tagsets?

Thank you,

Madalin

1 REPLY 1
Cynthia_sas
Diamond | Level 26

Hi:

  The only way I can think of doing what you want is to make a dummy column in your data that is explicitly blank. Otherwise, TAGSETS.EXCELXP output always starts in cell A1 in Excel.

cynthia

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

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
  • 1416 views
  • 0 likes
  • 2 in conversation