Kyra,   It looks like you have missing data in the BMIs.  The approach Chris provided is just one way to address missingness and may or may not be appropriate.  I'd suggest also reading about the types of missing data and approaches to address it.  Perhaps start with D. A. Newman's 2014 article in Organizational Research Methods ( https://www.researchgate.net/publication/268686755_Missing_Data ).   Doc Muhlbaier Duke ... View more

Simplify.  Since SAS dates are stored as integers, just subtract the two dates.   (DATEPART(a.campaign_send_datetime) - DATEPART(b.activity_date)) <= 14 ... View more

Unless you also have access to a Windows SAS server, I think that you will need to do the copying outside of the SAS environment.    If you need to make the file copy at the beginning or end of an EGuide session, you could create a Windows batch file that does the copy and then calls eGuide (or vice versa).   If you have access to a Windows SAS server, you can switch servers within EGuide and run your X-command from the Windows Server, and then go back to your *nix server. ... View more

You didn't tell us the actual p-values.  For instance, .04 and .06 are not that different in strength of evidence.   Other things to look at:  --  Is the effect of mg linear?  A curvilinear relationship can show up as non-significant in a continuous setting.  Looks at your graphical diagnostics. --  There may be an interaction that you are not modeling.   There are a couple of good SAS Books-By-Users that can lead you through exploring the relationships.   Doc Muhlbaier ... View more