Samples & SAS Notes > SAS Reference
>
ODS (Output Delivery System)
| Date | Title | Type | ||
|---|---|---|---|---|
| 10/14/09 |
37456 - Using ODS CSV as an alternative to the %DS2CSV macro ODS CSV provides a newer method for converting SAS data sets to CSV files http://support.sas.com/kb/37/456.html, 20KB |
Sample | ||
| 4/6/05 |
24959 - Using ODS to Generate a CSV File Directly On a PC In this example, a SAS program running on z/OS generates a CSV file from a PROC PRINT and writes it to a PC file. Once on the PC, it is accessed as a CSV file by a standard spreadsheet program. http://support.sas.com/kb/24/959.html, 20KB |
Sample | ||
| 1/12/04 |
23652 - How can I create a CSV file with ODS? In Release 8.1, you can create a CSV file by using the ODS XML statement with the TYPE=CSV or TYPE=CSVALL option. TYPE=CSVALL keeps the titles. This is experimental in Release 8.1 but works rather well; see ... http://support.sas.com/kb/23/652.html, 17KB |
Usage Note | ||
| 12/24/03 |
23615 - In the ODS MARKUP destination, how can I eliminate the top two blank rows when using the CSV tagset? This can be done by modifying the CSV tagset. Below is an example. proc template; define tagset tagsets.newcsv; parent = tagsets.csv; notes "This is the CSV definition";* we removed the start: put NL. It ... http://support.sas.com/kb/23/615.html, 17KB |
Usage Note | ||
| 1/21/08 |
13415 - Generating output with the CSV tagset may cause performance problems When generating output with the CSV and the CSVALL tagsets in SAS 9.12 and SAS 9.13, performance problems may exist. This may result in out of memory errors, or increase CPU and elapsed times. The CSV tagset has to ... http://support.sas.com/kb/13/415.html, 19KB |
Problem Note | ||
| 7/11/05 |
23664 - How can I send ODS output to Excel, Word, PowerPoint, and Oracle? There are many ways to read ODS output with Excel, Word, PowerPoint, SPSS, Oracle, and Access. Excel Excel from HTML and CSV The bullets below contain syntax to get you started. For more in-depth information, see ... http://support.sas.com/kb/23/664.html, 21KB |
Usage Note | ||
| 5/24/04 |
10241 - Variables with embedded commas generate problems when using the CSV and CSVALL destinations Variables with embedded commas generate problems when using the CSV and CSVALL destinations. http://support.sas.com/kb/10/241.html, 19KB |
Usage Note | ||
| 8/10/05 |
25383 - Demonstrates Basic Files Generated from ODS MARKUP using CSVALL tagset This example demonstrates using the ODS MARKUP destination with the CSVALL tagset to generate CSV files http://support.sas.com/kb/25/383.html, 21KB |
Sample | ||
| 2/27/08 |
17862 - Percent signs are stripped from the data when generated with ODS MARKUP When a percent sign is included in the data, this character is stripped when rendered by the ODS Markup destination. Therefore, any destination such as such as CSV, HTML, EXCELXP and any other tagset generated will have ... http://support.sas.com/kb/17/862.html, 19KB |
Problem Note | ||
| 12/23/03 |
23495 - How do I generate a TAB-delimited file using the ODS MARKUP statement? You can modify Tagsets.CSV to create a tagset that uses a TAB character for the delimiter rather than a comma. The example below checks to see if the COLSTART variable has the value of "1". If it does, then the ... http://support.sas.com/kb/23/495.html, 17KB |
Usage Note | ||
