Usage Note 33590: How to programmatically determine the open ODS destinations
 |  |  |  |  |
Beginning with SAS® 9.2, you can programmatically determine which ODS destinations are open by querying the Dictionary.Destinations dictionary table. Querying the Dictionary.Destinations table displays both the open ODS destinations and the style that is applied to each destination. As with other dictionary tables, you can also determine this information with the Sashelp view Sashelp.Vdest.
Click the Full Code tab for sample code.
Operating System and Release Information
| Product Family | Product | System | SAS Release | |
| Reported | Fixed* | |||
| SAS System | Base SAS | z/OS | 9.2 TS1M0 | |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2 TS1M0 | |||
| Microsoft Windows XP 64-bit Edition | 9.2 TS1M0 | |||
| Microsoft® Windows® for x64 | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2 TS1M0 | |||
| Microsoft Windows Server 2003 Standard Edition | 9.2 TS1M0 | |||
| Microsoft Windows XP Professional | 9.2 TS1M0 | |||
| Windows Vista | 9.2 TS1M0 | |||
| 64-bit Enabled AIX | 9.2 TS1M0 | |||
| 64-bit Enabled HP-UX | 9.2 TS1M0 | |||
| 64-bit Enabled Solaris | 9.2 TS1M0 | |||
| HP-UX IPF | 9.2 TS1M0 | |||
| Linux | 9.2 TS1M0 | |||
| Linux for x64 | 9.2 TS1M0 | |||
| OpenVMS on HP Integrity | 9.2 TS1M0 | |||
| Solaris for x64 | 9.2 TS1M0 | |||
The sample code below lists to the log the current open ODS destination(s).
proc sql noprint;
select distinct destination into : dest
separated by ',' from dictionary.destinations;
quit;
%put &dest;| Type: | Usage Note |
| Priority: | |
| Topic: | SAS Reference ==> ODS (Output Delivery System) Data Management ==> Administration Third Party ==> Output ==> HTML Third Party ==> Output ==> PDF Third Party ==> Output ==> Postscript Third Party ==> Output ==> RTF Third Party ==> Output ==> XML |
| Date Modified: | 2022-10-25 09:16:22 |
| Date Created: | 2008-10-10 18:38:40 |