Hi Guys, I use this code right now to send out an alert email once the code is done running: filename outmail email "abc@abc.com"                        subject="SAS"                        cc="abc@aaa.com" ; data _null_; file outmail; put 'Hello'; put; put 'The weekly code has completed.'; put; run; Is is possible for me to somehow include the file size and file info in this email? Something along the lines of : http://support.sas.com/kb/38/267.html Please provide the code if possible! Thanks! ... View more

Hi there, Just wondering how I can alter the following query to show date in the format I want. Existing Date format: 15MAR2011:09:05:16.000000 Format I want: 15MAR2011:09:05:16 Query I am using: proc sql; create table data.test as select       * from connection to odbc ( select     ID,              DATE AS CREATION_DATE, from         maintable ); quit; ... View more

Hi Guys, I use SAS to pull some tables from an ODBC connection. Just wondering if there is any way to make this process faster from a code side? I already use the compress function and only pull variables I need. Sample code: proc sql; connect to   odbc (dsn=&dsn uid=&uid pwd=&pwd); create table data.table1 as select       * from connection to odbc ( select    SHARED.ID,              SHARED.NAME from       SHARED.REASON ); quit; Are there any other ways to make the pull faster? ... View more

Hi guys, I have used the following macro to count the number of rows and use it in my dde: data _NULL_; if   0 then set TEST nobs=nr; index=nr+1; CALL SYMPUT('row2', PUT(index, 5.)); stop; run; usage in DDE: FILENAME dataZ13 DDE "excel|[&template.]&section2.!r2c30:r&row2.c36" notab; I am wondering how I can do the same for the number of columns? I have a dataset where we add a new variable (column) every month. I was wondering if there was some similar macro that can count the number of columns so I do not have to keep changing the column limits in DDE. Thanks. ... View more

Hi All, I have the following sample dataset: COL1      COL2     COL3 A               X          100 A               Y          250 C               Z          300 What I want to achieve is the following: When Col 1 = A and Col 2 = X or Y then add the numbers in COL3 (result should be 350 in this case) I tried SUM but this did not work. Any tips? ... View more