05-12-2014 11:12 AM
Several of my emails created from SAS using ODS have "<TD>" inserted in what appears to be random locations in the report table. What am I missing here?
This is snipped from the code:
|ods MARKUP body=EMLOUT3 (no_top_matter no_bottom_matter)|
|proc report data=npcp nowindows;|
|column STIME SYSTEM JOB SRVCLSS USID|
|define STIME /format=time8. 'Time';|
|define SYSTEM / format=$4. 'System';|
|define JOB / format=$8. 'Job';|
|define SRVCLSS / format=$8. 'Service Class';|
|define USID / format=$8. 'User Id';|
|ods MARKUP close;|
05-12-2014 11:22 AM
<TD> = Table Deliniator. The should be resolving by the interpretor as the time to move over to the next column. Its odd that you have it just once, is there anything in the data of 8:39:15 or CPU8 which may interfere with the encoding such as special characters?
05-12-2014 11:33 AM
Not that I know of. The data looks like the rows above. The code is running on z/OS 1.13 & SAS 9.1 and sending email to MS Outlook 14...
05-12-2014 01:45 PM
I take it EMLOUT3 is a filename using the email access method? You may need to add lrecl= there.
Sometimes when debugging email problems, I find it easier to write the results to a file, so that I can review the .html in a text editor. And try opening it in a browser. That helps determine whether PROC REPORT is generating bad html, or if good html genereated by PROC REPORT is being truncated by outlook or elsewhere in the emailing process.
I've been saved by rs=none, as Chevell suggests.