https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65356#M18648 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.<BR /> <BR /> FORMAT _ALL_ ; /* clear all output formats */<BR /> <BR /> The SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website has related SAS DOC and supplemental conference and sample code - see sample link below.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Sample 24800: How to invoke PROC EXPORT to create a delimited file<BR /> <A href="http://support.sas.com/kb/24/800.html" target="_blank">http://support.sas.com/kb/24/800.html</A> Wed, 19 Aug 2009 00:42:10 GMT sbb 2009-08-19T00:42:10Z https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65355#M18647 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?<BR /> TIA <BR /> Patrick Tue, 18 Aug 2009 23:36:50 GMT https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65355#M18647 deleted_user 2009-08-18T23:36:50Z https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65356#M18648 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.<BR /> <BR /> FORMAT _ALL_ ; /* clear all output formats */<BR /> <BR /> The SAS support <A href="http://support.sas.com/" target="_blank">http://support.sas.com/</A> website has related SAS DOC and supplemental conference and sample code - see sample link below.<BR /> <BR /> Scott Barry<BR /> SBBWorks, Inc.<BR /> <BR /> Sample 24800: How to invoke PROC EXPORT to create a delimited file<BR /> <A href="http://support.sas.com/kb/24/800.html" target="_blank">http://support.sas.com/kb/24/800.html</A> Wed, 19 Aug 2009 00:42:10 GMT https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65356#M18648 sbb 2009-08-19T00:42:10Z https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65357#M18649 Thank you! Wed, 19 Aug 2009 13:01:42 GMT https://communities.sas.com/t5/SAS-Procedures/Export-data-from-dataset-without-formats/m-p/65357#M18649 deleted_user 2009-08-19T13:01:42Z