You could read it sequentially, but it gets a little code heavy and is not nearly as elegant as the solutions you already have. You set a (retained) flag for each criteria and, if something happens out of sequence, you reset them and start over. It looks ugly but is something like (using Hai.Kuo's "have"): data want (keep = Scenario1); set have end = eof; retain Scenario1 got1 got5 got8 0; select;   when (event = 'S1' and Reason = 'Reason 1')    do;     got1 = 1;   got5 = 0;   got8 = 0;    end;   when (event = 'S5' and Reason = 'Reason 1')    do;     if got1 = 1 then got5 = 1;   else do; got1 = 0; got5 = 0; got8 = 0; end;    end;   when (event = 'S8' and Reason = 'Reason 1')    do;     if got1 = 1 and got5 = 1 then got8 = 1;   else do; got1 = 0; got5 = 0; got8 = 0; end;    end;   otherwise    do;     got1 = 0; got5 = 0; got8 = 0;    end; end; if sum(got1, got5, got8) = 3 then do;   Scenario1 + 1;   got1 = 0; got5 = 0; got8 = 0; end; if eof then output; run; The advantage to this ugly thing is that you could potentially test for multiple scenarios with a single pass through the data, in which case you'd have multiple sets of "gotx" flags. (Above is not only ugly but also not fully tested. It's meant to be illustrative, not production quality.) HTH Karl ... View more

For question #2, you want the "gpath=" option on the ODS HTML statement. From the SAS 9.3 ODS User's Guide: "specifies the location for all graphics output that is generated while the destination is open. Use this option when you want to write graphics output files to a location different that specified by the PATH= option for markup files." Karl ... View more

I'm still curious as to how the program gets into the editor, but anyway: 1) assuming you're using the enhanced editor, the environment variables SAS_EXECFILENAME and SAS_EXECFILEPATH contain the name and the full path respectively of the currently running program. You'd use the %sysget() function to return those values to your program. I realize that what you really want is the fully-qualified name of the program in the editor window, but I'm not sure how to get that--again, because the program got into the window somehow, so I don't know how you wouldn't now that it's name already. 2) yeah maybe. On the other hand, do you need to save the file at all? Once you have it working in test mode, why not just write a little wrapper program that you copy the contents of the window into. It would turn your program into data, input it basically as a dataset in WORK, and then output it to filename email. Something like; data myProgram; input program_line $ 1-80; /* big enough for your longest program line */ datalines; <paste your  program here> ; run; then read myProgram into your email program. It seems to me that you're making it too complicated, but there are pieces of the puzzle I don't know. 3) I might recommend making this step a new thread to get help from somebody better able than I to handle the many details of e-mailing from SAS. I do it all the time, but it took me a while to find the right combination of EMAILHOST, EMAILAUTHPROTOCOL and EMAILSYS that reliably works with my SMTP server. Sorry I can't be more help. ... View more

I confess I'm a little confused. Your original posting indicated you had a program in the program editor. How did it get there? If you typed it in, or copy/pasted from another source, then just hit the "Save" button or type "flsvlast" into the command line. If it's already saved somewhere with a ".sas" extension, then you don't need to open it up in the editor at all. A ".sas" file is plain text. You just need a program to open it as text, read it in, and "put" the contents to the output destination with "filename email". There's no reason I can think of for "automating the editor". Am I missing something? Karl ... View more

In the DMS Enhanced Editor, if you do File-->Send Mail, a new message window opens with your current program attached as a txt file (at least in Windows). Does that work for you? If, on the other hand, your program needs to be the actual body of the e-mail message instead of an attachment, I don't think there's a point-and-click way to do that. You could, of course, save your program, then write another program which reads your program back in as text, and sends it using "filename email". HTH Karl ... View more

Are you executing the %puts after all your pass-thru statements have finished, or after each one? You mentioned your pass-thru job has multiple steps. Unless I'm mistaken, SQLXRC and SQLXMSG are reset to 0 and blank prior to the execution of any pass-thru command. So if it's an intermediate step that's generating the error (for example, one of your create table statements) AND you follow that with another statement, the second statement will clear out the messages from the first statement. Just a guess, of course, without actually looking at your code. HTH, Karl ... View more

Well, I'm a little confused by the representation of the unicode characters that you're seeing, but I'll offer my 2 cents. The format "&#n;" is, in the unicode world, called the "numeric character representation" or NCR, where "n" is a number, and the other characters are literal. In your screenshot, I'm afraid I don't know what the leading "/" or the trailing "l" are for. In any event, you should be able to  strip out those characters, and then convert what's left with the SAS unicode() function. Here's an example: data one; input wbc wbcoth_uni $; wbcoth = unicode(wbcoth_uni,'ncr'); datalines4; 3690 &#956; ;;;; run; When I open the table "one" in ViewTable, I see a mu in the wbcoth column. Please note that you do need to be running the unicode version of SAS, which may not be the default at your institution. On my Windows system, it's in the start menu-->All Programs-->SAS-->Additional Languages-->SAS 9.3 (unicode support). HTH Karl ... View more

Tushar, I think you meant mmddyy10. format, no? The OP wants "05/28/1927", not "28MAY1927". Karl ... View more

Hmm . . . Does this apply to you? 44289 - The row height for titles and footnotes might be incorrect when generated with the ExcelXP tagset ... View more