Help using Base SAS procedures

Export data from dataset without formats?

Reply
N/A
Posts: 0

Export data from dataset without formats?

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
Super Contributor
Super Contributor
Posts: 3,174

Re: Export data from dataset without formats?

Posted in reply to deleted_user
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
N/A
Posts: 0

Re: Export data from dataset without formats?

Thank you!
Ask a Question
Discussion stats
  • 2 replies
  • 1559 views
  • 0 likes
  • 2 in conversation