Is is possible to output data to a specific cell in a spreadsheet?
Thanks,
DanD
Hi:
If you are you using TAGSETS.EXCELXP or other ODS destinations and Base SAS, then the way that ODS works is to completely rewrite or recreate the file specified in the FILE= option or the BODY= option. The only way to write to a particular cell or range of cells is to use named ranges and PROC EXPORT and/or the LIBNAME engine -- using SAS methods -- but these are NOT ODS methods.
Using Microsoft technology, you might, with DDE, or ODBC or OLE-DB be able to write to existing sheets/workbooks to a particular cell.
cynthia
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.