My computer has 32bit SAS 9.4 and 32bit MS Office Professional Plus 2010, and am trying to set up a program to automatically email users when it is run. I have two problems: 1. If I have MS Outlook open on my computer while the program is running, I get an error message window in SAS that pops up titled "Outlook Data File" and the message is: 'The file c:\users\......\*.ost' cannot be opened'. 2. If I close MS Outlook before I run the SAS program, it creates the email. However, when I open up MS Outlook, the email is just sitting in my 'outbox' until the program sends/receives. I'd like for the email to automatically be sent without my having to open MS Outlook. One of my coworkers is able to use the exact same program and does not have either of these problems (the email is created and delivered as soon as the program is run, it does not matter if MS Outlook is open). We've checked and we have the same settings in Tools->Options->System->communications->email. I am not sure if it matters, but we can't use SMTP, only MS Exchange Server. Has anyone else had this problem? Or can anyone point me in a general direction to figure it out? This is an example of the code that I am using: filename outbox email emailsys=mapi      to=email@address.com      subject='TEST EMAIL SUBJECT'; data _null_; file outbox;      put 'BODY OF TEST EMAIL'; run; Thanks! Michelle ... View more

Hello, I am trying to create a sas dataset from a sybase database connection, and would like to figure out how to convert a date/time value to a SAS date value. The date is stored as smalldatetime in sybase. Right now, I have a proc sql followed by a data step that converts to SAS date. Does anyone know if there is way to do this within the proc sql? I am not familiar with sybase at all, and was hoping someone just happens to know how to do this... Thanks! proc sql;      connect to sybase as syb (user="&uid" password="&pwd" database="epi" server="db");      create table test as      select * from connection to syb      ( set quoted_identifier off           select date_entered,              /* would like to convert this to sas date without a data step */                a, b, c           from maintable           where date_entered between "&dtbeg" and "&dtend"      ); quit; data test2;     /* would like to get rid of this data step */ set test; dtent=datepart(date_entered); drop date_entered; run; ... View more