Providing software solutions since 1976
37456 - Using ODS CSV as an alternative to the %DS2CSV macro- Sample
ODS CSV provides a newer method for converting SAS data sets to CSV files
24959 - Using ODS to Generate a CSV File Directly On a PC- Sample
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.
23652 - How can I create a CSV file with ODS?- Usage Note
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 ...
23615 - In the ODS MARKUP destination, how can I eliminate the top two blank rows when using the CSV tagset?- Usage Note
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 ...
13415 - Generating output with the CSV tagset may cause performance problems- Problem Note
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 ...
10241 - Variables with embedded commas generate problems when using the CSV and CSVALL destinations- Usage Note
Variables with embedded commas generate problems when using the CSV and CSVALL destinations.
23664 - How to send ODS output to Microsoft Excel, Word, and PowerPoint- Usage Note
How to send ODS output to Microsoft Excel, Word, and PowerPoint.
17862 - Percent signs are stripped from the data when generated with ODS MARKUP- Problem Note
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 ...
25383 - Demonstrates Basic Files Generated from ODS MARKUP using CSVALL tagset- Sample
This example demonstrates using the ODS MARKUP destination with the CSVALL tagset to generate CSV files
23495 - How do I generate a TAB-delimited file using the ODS MARKUP statement?- Usage Note
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 ...
13809 - Tagsets created with SAS 8.2 may not produce the same output in SAS 9.1- Usage Note
The ODS Markup destination was introduced in SAS 8.2 experimentally. This allowed the ability to create files in many different file formats such as XML, CSV, and LaTex. The Markup destination has added new ...
37040 - ODS creates output files for Microsoft Excel that are very large- Usage Note
Some files generated by ODS for use with Microsoft Excel are very large. This note contains information and sample code to reduce the file size.
13128 - Prevent the Results Viewer from opening automatically when generating output from ODS- Usage Note
This note illustrates how to prevent the Results Viewer from opening automatically when generating output from ODS.
