data mydata(keep=name address city state zip phone email);
set data1;
run;
I am using a proc export
proc export data=mydata;
set mydata1;
File "/servername/report..txt"
Linesize=8000 dsd dlm='|';
run;
In some cases there may be a blank in one or more fields
Osborne 1313 E Main St Washington DC myemail@me.com (In this case we skipped the zip and phone number
In my proc export I am getting double || and sometimes I get what appear to be small boxes. The carraige returns are not working. The display should begin a new line after email however in some cases a new record will begin on the same line
Osborne 1313 E Main St Washington DC myemail@me.com Bradeley 1312 E Main
Would a trim function fix this in some way?
Likely not. The small boxes are usually unprintable characters. Proc export allows almost no control over the resulting output. You mention "carriage returns are not working". Did you try to embed them into the strings?
You get || because your delimiter is | and there is no data in that field. CSV and other delimited formats do the same thing, no data means sequential delimiters to ensure the number of columns are the same in each record.
You may want to post a few lines of input data and what you expect it to look like. Include some of the examples with blanks or other odd data.
A data _null_ step with put statements may be a solution.
Are you trying to print mailing labels?
https://support.sas.com/documentation/onlinedoc/base/91/forms.pdf
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.