Export data from dataset without formats?

[deleted_user]

Howdy. I need to export data from an existing SAS dataset into a pipe delimited text file without the formatting ( I need to insert this data into a DB2 table). How can I do this?
TIA
Patrick

[sbb]

Use a DATA step, at least to remove any output formats, and either use the same DATA step to generate the delimited file or use PROC EXPORT.

FORMAT _ALL_ ; /* clear all output formats */

The SAS support http://support.sas.com/ website has related SAS DOC and supplemental conference and sample code - see sample link below.

Scott Barry
SBBWorks, Inc.

Sample 24800: How to invoke PROC EXPORT to create a delimited file
http://support.sas.com/kb/24/800.html

[deleted_user]

Thank you!