08-26-2014 03:03 PM
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
Instead I get this
I get extra | and the word jump to the next line. The Loan number should always begin the proc export.
08-26-2014 03:23 PM
input LOAN $ CLOSING_DATE $10. DEFAULT_REASON $ LAST_NAME $ EMAIL$25. ;
111111119 05/15/2014 Layoff Shelton firstname.lastname@example.org
proc export data=have
08-26-2014 03:24 PM
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.
08-26-2014 03:25 PM
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
08-26-2014 06:53 PM
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.