Help using Base SAS procedures

proc export to txt

Reply
Frequent Contributor
Posts: 143

proc export to txt

Isnt the code

dsd dlm = ' | '    the method to help avoid excess characters, in this case excess | when using proc export to .txt.

Here is my fields in the dataset

LOAN       CLOSING_DATE     DEFAULT_REASON  LAST_NAME    EMAIL

Desired output

111111119|05/15/2014|Layoff|Shelton|shelton@gmail.com

Instead I get this

111111119|05/15/2014||||||||||||Layoff||||||||||||||

Shelton|shelton@gmail.com

I get extra  | and the word jump to the next line.  The Loan number should always begin the proc export.

Regular Contributor
Posts: 233

Re: proc export to txt

Code:

data have;
input LOAN  $     CLOSING_DATE  $10.   DEFAULT_REASON $ LAST_NAME  $  EMAIL$25. ;
datalines;
111111119 05/15/2014 Layoff Shelton shelton@gmail.com
;

proc export data=have
   outfile='/sasuserhome/hyenigalla/have.txt'
   dbms=dlm;
   delimiter='|';
run;

Output:

Capture.JPG

Super User
Posts: 11,343

Re: proc export to txt

Going to another line may mean that your field Last_namel contains control characters such as a carriage return or line feed.

Also you may want to post the entire proc export code to see if any options are interacting.

Respected Advisor
Posts: 3,156

Re: proc export to txt

Without seeing your actual data and your code, it is difficult to debug. I can't repeat your issue, below code works for me:

proc export data=sashelp.class

outfile="h:\temp\class_pipe1.txt"

dbms=dlm replace;

delimiter='|';

putnames=yes;

run;

Haikuo

Super User
Posts: 11,343

Re: proc export to txt

Another thing to look at if this data was originally imported from Excel: if the source file has HIDDEN columns you may have imported a bunch of blank columns that would have names like Var1 Var2 Var3. Export would produce a delimiter between each of those fields. If you don't have the PUTNAMES=YES as part of the proc export you won't notice as no column headings would appear.

Ask a Question
Discussion stats
  • 4 replies
  • 432 views
  • 0 likes
  • 4 in conversation