DATA Step, Macro, Functions and more

excel engine

Accepted Solution Solved
Reply
Contributor
Posts: 45
Accepted Solution

excel engine

Hi ,

i have been using the excel engine to export about 10 tabels to excel ,  is there any way of adding format to my variables ? and also how can i add a title to the page ( before the table explaining what it is ) ???   thanks CL


Accepted Solutions
Solution
‎11-27-2013 01:41 PM
Super User
Posts: 17,826

Re: excel engine

Not using proc export but you can with ODS TAGSETS.EXCELXP - and this will allow titles. However this does not create a native excel file, it creates an XML file which can then be converted to an native Excel file in a variety of methods.

Base SAS: Demo: ExcelXP Tagset and Microsoft Excel

View solution in original post


All Replies
Solution
‎11-27-2013 01:41 PM
Super User
Posts: 17,826

Re: excel engine

Not using proc export but you can with ODS TAGSETS.EXCELXP - and this will allow titles. However this does not create a native excel file, it creates an XML file which can then be converted to an native Excel file in a variety of methods.

Base SAS: Demo: ExcelXP Tagset and Microsoft Excel

Valued Guide
Posts: 2,175

Re: excel engine

All these things can be done.

The simplest way depends on where you are and what you are already doing.

Please let us see the code you have so far.

peter.C

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 157 views
  • 0 likes
  • 3 in conversation