proc export to txt

[Q1983]

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.

[Hima]

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:

[ballardw]

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.

[Haikuo]

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

[ballardw]

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.