data in.indata;                 do year=2010 to year(today());                                 do month=1 to month(today());                                                 SAS_date=mdy(month,1,year);                                                                                                                      output;                                 end;                 end; run;   are you sure this is what you want?   do month=1 to month(today())   will return only the months from January to, say, June for ALL years.   To get all months, you would do better with:   SAS_date = '01JAN2010'd; do while ( SAS_date <= intnx("MONTH", Today(), 0) ); SAS_date = intnx("MONTH", SAS_date, 1); output; end;     ... View more

Hi, I have added the week function into Anca's code, after that, running a PROC MEANS (code below) I got the aggregate figures per week. data Period2; set Trans; Date = mdy(scan(period,2, "/"), scan(period, 1,"/"),2013); format Date date9.; Week_= week(Date); run; PROC SORT Data= Period2;   BY Week_; run; PROC MEANS Data=Period2 sum; var col1 - col697; class Week_; run; ... View more