BookmarkSubscribeRSS Feed
JasonNC
Quartz | Level 8

Hi All,

 

I am trying to create the template attached.What is the best possible way to create the template.Can this be done using odsexcelxp tagset and proc report or i should go the route of ods excel?

 

Any help would be appreciated!!

2 REPLIES 2
Reeza
Super User

I would go ODS EXCEL and PROC REPORT. 

 

There doesn't appear to be anything complicated in the report that couldn't be handled with ODS EXCEL. 

 

ODS EXCEL creates a native XLSX file, ODS TAGSETS.EXCELXP creates an XML files, both will likely get you a file that looks the way you want, it's a matter of file formats. The code will likely be very similar between the two as well.

 

JasonNC
Quartz | Level 8

Thanks Reeza.You are the best!!

 

I will let you know how it goes

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