Arthur - thanks, i'll give this solution a go and give some feedback. With regards to what I'm trying to acheive, this is the structure: 1. There are up to 13 historical files that require importing. (reason just the one set of files, is for the debt files, a month / year variable is required for reporting purposes, whereas the the other 13 files that are to be merged with the debt files, only three variables are required thus the temp. library is associated for the folder in my 'documents' folder. The initial code posted had a start date in July, but there were only 6 files available, hence the 'number of months's used. The next step is to sort both sets of file by the account number and then merging them together by the account number. Finally, the outputs of these (up to 13 files) can be appended together. ... View more

Take a look at the code below. I am assuming that date will be unique otherwise replace it with a unique row identifier. data temp;   input date : date9. amt;   format date date9.;   datalines; 1JAN2013 45 2JAN2013 31 3JAN2013 65   ; run; proc sql;   select a.date, a.amt, (select SUM(b.amt) from temp as b where b.date <= a.date) as running_total    from temp as a   order by a.date; quit; ... View more

Hi:   There have been a LOT of previous forums postings about creating report output with ODS and then using the FILENAME email engine to sent email with the ODS report as an attachment. There are also quite a few Tech Support notes about the various system options that you have to set (at startup time) in order for the e-mail routines to work. In addition, you may need to work with your e-mail folks to find out the server names, mail method etc.   I think if you search you will find the information you're looking for.   As a way to get started, look at "greatest hit" #2 on pages 7 and 8 in this paper: http://support.sas.com/resources/papers/proceedings11/300-2011.pdf cynthia ... View more