Tip of the Day

From sasCommunity
Jump to: navigation, search

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.


Prior tip - Next tip -- Random Tip

Submit a Tip


 

Tips Index by Status

Currently in Use | Yet to be Scheduled | Still Under Review | Tip Awaiting Refinement

Search Tips:


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:

  1. Submit a Tip by posting a SAS tip that you think others might find useful
  2. Review a Tip prior to publishing
This effort is similar to, and was motivated by, the WikiPedia Tip of the Day Project. Please tell us what you think