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

Catch up on SAS Innovate 2026

Dive into keynotes, announcements and breakthroughs on demand.

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