Tip of the Day
sasCommunity Tip of the Day
Certain types of ODS output, such as HTML and PDF, will be automatically displayed by SAS for Windows if you have chosen "View results as they are generated" in the Results tab of the Preferences menu item.
ExcelXP tagset output will not be displayed automatically, but you can open it using the Windows command START in an X statement. Use the system option NOXWAIT to automatically close the DOS shell opened by the X statement:
ods tagsets.excelxp file='c:\temp\class.xml'; proc print data=sashelp.class; run; ods tagsets.excelxp close; options noxwait; x 'start c:\temp\class.xml';
Be sure to close the file in Excel before running the program again; if you don't, the first ODS statement will fail because the file will already be in use.
You can use the START command to open any known Windows file type.
Submitted by JackHamilton. Contact me at my Discussion Page.
Feel free to comment on this tip.
Tips Index by Status
The Tip of the Day Project
A new technical Tip of the Day related to SAS software will be shown on this page and the sasCommunity.org main page every day. Before getting started, you can Browse and Search the current list of tips contributed by users.
Anyone can participate. We hope you do! Here's how:
- Submit a Tip by posting a SAS tip that you think others might find useful
- Review a Tip prior to publishing