BookmarkSubscribeRSS Feed
Phil
Calcite | Level 5
After an XML file is saved using the ExcelXP tagset, can you automate saving the output file as .XLS? Has anyone done this - maybe like calling a "File Save As" screen?
1 REPLY 1
OS2Rules
Obsidian | Level 7
I use the ExcelXP tagset to create a large number of spreadsheets and they are all created with a .XLS extension.

There is no reason that you can't name the file anything you want - I name my files using macro variables:

ods tagsets.ExcelXP path="&path" body="&body" style=minimal;

where the "&body" resolves to "sheetname.xls"

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