Probably Excel being "helpful".  I just tried this code: ods tagsets.excelxp file="S:\Temp\Rob\x.xls" options (autofilter="yes"); proc report data=sashelp.cars nowindows split='*';    compute before _page_ ;       line "aaaaa";       line ' ';    endcomp; run; ods tagsets.excelxp close; And it put the autofilter on the data, so maybe try removing bits of the program and re-running each time to see which works.  Could be the style=line statement or somewhere else in the style which is telling Excel which is row headings. ... View more

Hi, Maybe, but looking at the wanted data: 4          2/4/13           2/5/13                 0                                             1 4          2/13/13         2/18/13               8                                             1 4          4/24/13         4/27/13               68                                           1               4          6/3/13          6/10/13              108                                           2 I took this as interval increase per row based on the difference.  Each 91 block of days is to be a new group starting at 1 and then increasing each 91 block by 1.  So I think our solutions are pretty much the same (the output is the same). ... View more

Something along the lines of: proc sql;   create table WORK.DATES2 as   select  CURRENT.ID,           CURRENT.ADATE,           CURRENT.DDATE,           datdif(BASE.ADATE,CURRENT.DDATE,"ACT/ACT") as INTERVAL,           round(CALCULATED INTERVAL / 91,1) +1 as GRP   from    WORK.DATES CURRENT   left join (select ID,MIN(ADATE) as ADATE from WORK.DATES group by ID) BASE   on      CURRENT.ID=BASE.ID; quit; ... View more

Well, this is one way, checking for the existence of a record where the old transaction date is between new transaction date - 6 months and new transaction date. proc sql;   create table new_transaction_with_flag as   select  A.*, /* So if there is a record with a date between the new transaction - 6 months and new transaction    then flag it */           case  when exists(                               select  distinct THIS.CUST_ID                               from    WORK.PREVIOUS_TRANSACTIONS THIS                               where   THIS.CUST_ID=A.CUST_ID                                 and   THIS.TRAN_DATE between intnx('month',A.TRAN_DATE,-6) and A.TRAN_DATE                             ) then "Y"                 else "N" end as FLAG   from    WORK.NEW_TRANSACTIONS A; quit; ... View more

Here is some code (sorry, spacing seems a bit weird on here).  Have just done it quickly, so there is no checking done (i.e. if there are not previous transactions etc.) but it works.  There are other methods, such as datdiff if you can specify a number of days rather than months. --- /* Create some test data */ data previous_transactions;   attrib  cust_id format=8.           tran_date format=date9.;   cust_id=1; tran_date='01mar13'd; output;   cust_id=1; tran_date='06jan13'd; output;   cust_id=1; tran_date='15may13'd; output;   cust_id=2; tran_date='01mar13'd; output;   cust_id=2; tran_date='03mar13'd; output; run; data new_transactions;   attrib cust_id format=8.           tran_date format=date9.;   cust_id=1; tran_date='30may13'd; output;   cust_id=2; tran_date='10oct13'd; output; run; /* New table with flag. */ proc sql;   create table new_transaction_with_flag as   select  A.*, /* If the maximum date from previous transactions + 6 months is after the date we are looking at then we know this is within 6 months */           case  when intnx('month',B.TRAN_DATE,6)>=A.TRAN_DATE then "Y"                     else "N" end as FLAG   from    WORK.NEW_TRANSACTIONS A   /* Join on the maximum data from previous transactions */   left join (               select  distinct                       CUST_ID,                       MAX(TRAN_DATE) as TRAN_DATE               from    WORK.PREVIOUS_TRANSACTIONS               group by CUST_ID             ) B   on      A.CUST_ID=B.CUST_ID; quit; ... View more

Hi, Several ways of doing it.  First you would need to merge the last_trans_date onto your current data.  Then you could go with INTNX - this function does intervals between time points.  So if current trans date < = last trans date + 6 months then Y else N. Can run up some code tomorrow if still unclear. Rob ... View more

Can you supply some of this code that you want to move into a batch file?  If it is sysexec or cmd commands then this could be moved directly to a batch file.  If you want to execute SAS code then this needs to go through the SAS system as it gets processed, compiled and then run.  If you mean that you want a DOS program which performs some actions like a SAS program, then you would need to investigate a programming language which compiles to the OS you use (e.g. C++) or some intermediate language like Java or .NET. ... View more