36
Can Data Step Programs Send SAS Data to Excel?
A data step can create a comma separated value (CSV) text file.
Features:
• Wide capabilities of the data step make this a very flexible tool.
• DSD FILE option inserts a delimiter (,) between values.
• DSD quotes the values if they contain special characters.
• The Tilde (~) format modifier will quote all fields.
• ODS CSV destination with Proc Print gives virtually identical results.
• When opened in Excel, it is automatically parsed into columns.
Choosing the Right Tool from Your SAS
®
and Microsoft Excel
®
Tool Belt
Kommentare zu diesen Handbüchern