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
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.
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.
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
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.