Hi All, I've very new to the use of FILE PRINT to structure data prior to outputting it as a PDF file.  I've inherited this code from someone else who is not longer with the company so asking that person is not an option.  I've tried researching this on the Internet for several days now and have not been able to find a good answer as to how to control the line spacing when I use this method to create our final report.  I'm hoping that the community knows and can help me with this. The code that I run looks like this. data _null_; set rx5 end=eof; file print; if _n_=1 and eof=1 then do;   put @1 name_etc / @1 pat_addr1 / @1 pat_addr2 /// @1 product @60 'Quantity:' @68 disp_quan comma8.1 @87 'Days Supply:'       @98 days_sup 3. / @1 'Health Plan Cost:' @19 sv dollar10.2 @33 'Copay:' @40 copay dollar8.2 @52 'Health Plan Paid:'       @70 hplan_paid dollar10.2 @95 'Fill Date:' @106 fdate mmddyy10. / @1 lname @75 laddr / @1 doctor //// @1 sig ///       @1 'This is what your Health Plan paid:' @37 hplan_total dollar11.2 // @1 'Total Copayment:' @18 copay_total dollar10.2; end; The output currently comes out looking like this (sorry, masking the real output for confidentiality): Name (HRN) - DOB: LASTNAME, FIRSTNAME MI (12334567) - MM/DD/YYYY 1234 ALOHA WAY HONOLULU, HI  96817-1349 What I want to get rid of is the spacing between the lines above so that it looks like this: Name (HRN) - DOB: LASTNAME, FIRSTNAME MI (12334567) - MM/DD/YYYY 1234 ALOHA WAY HONOLULU, HI  96817-1349 If you can point me in the right direction, I would appreciate it.  Thanks. ... View more

Hi, I'm trying to create the foundation for an email which would summarize for me which reports that I've scheduled had a successful output and which ones did not.  I'm basing this all off an excel list which is uploaded daily and is my base reference for which reports should have run.  At the end of each report code, I write to a table which tells me that the report had a successful output (if there is no record in the table for the report, then its assumed that the report did not output successfully).  My end goal is for the body of the final email to look something like this: The following reports were unsuccessful: Report #3 Report #4 The following reports have run successfully: Report #1 Report #2 Report #5 My dataset for this effort looks like this: rpt_num          rpt_name               rpt_status 1                    Report #1               1 2                    Report #2               . I have been trying to do this via PROC SQL, but am stuck and not able to get the INTO statement SEPARATED BY to use a carriage return. PROC SQL NOPRINT; SELECT rpt_name INTO :good SEPARATED BY '0D'x' FROM daily_rpt_status WHERE rpt_status= 1; PROC SQL NOPRINT; SELECT rpt_name INTO :bad SEPARATED BY '0D'x' FROM daily_rpt_status WHERE rpt_status IS MISSING; Then I would use the &good and &bad to fill in the email body. Any thoughts on this would be greatly appreciated.  Also, I'm not tied to doing things this way, especially if there is a more efficient way to do it.  This is just based off what I know today. ... View more