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

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!

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