Hey all!
Long time SAS programmer still getting used to the EG environment...
I have a question about how ODS works in the EG world. I know that you can automatically set your results settings (Tools > Options > Results > Results General) to display your format in multiple destinations, and I use this for a good chunk of my day-to-day ad hoc work. However, sometimes the options available are limited, so I want to use ODS code to explicitly get exactly the output that I want.
So, here's the question... If I have my results generator set to automatically create an Excel file, but then I also use ODS Excel to create an Excel file, does it create two separate files with two separate sets of options? I believe it does, but I wanted to hear from the community with invariably more EG experience than I have...
Tasha
Hi:
If you turn on the ODS EXCEL choice in the Results Window and then you also use explicit ODS EXCEL statements in your code, you will see 2 outputs inside EG, as shown below:
Hope this helps,
Cynthia
Hi:
If you turn on the ODS EXCEL choice in the Results Window and then you also use explicit ODS EXCEL statements in your code, you will see 2 outputs inside EG, as shown below:
Hope this helps,
Cynthia
Yes, Cynthia that does help. Thank you! So, just to make sure I'm 100% clear on how this works, is it fair to say that the two Excel files would be controlled by different options? I.E., the file created through the ODS Excel code would be controlled by the options in my ODS Excel code, and the automatic generated file would be controlled by options selected through the EG menus...
Thank you, Cynthia. Yeah, I was referring to the results options.
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.