Hi, is there a way I can just update an Excel (2010) worksheet (while leaving the other worksheets untouched), and also bring over the formats form SAS to Excel.. for example percentages, numbers, dollars.. etc. Thanks
Hi, generally when you use PROC EXPORT or the LIBNAME engine, your SAS formats are not respected by Excel when it opens the file. That's because Excel has defaults that it uses. See this user group paper for some examples of exported data versus using ODS techniques:
http://support.sas.com/resources/papers/proceedings13/316-2013.pdf
If you use the Output Delivery System, you can work around some of the Excel defaults, however, ODS cannot write to an existing workbook or add a sheet to an existing workbook.
cynthia
I think DDE should work for that
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 the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.