topic Re: proc export to txt in SAS Procedures

proc export to txt

Q1983 — Tue, 26 Aug 2014 19:03:27 GMT

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.

Re: proc export to txt

Hima — Tue, 26 Aug 2014 19:23:47 GMT

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:

Re: proc export to txt

ballardw — Tue, 26 Aug 2014 19:24:56 GMT

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.

Re: proc export to txt

Haikuo — Tue, 26 Aug 2014 19:25:51 GMT

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

Re: proc export to txt

ballardw — Tue, 26 Aug 2014 22:53:08 GMT

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.