where the data sles is the data merged for the two periods time (1/11/2009 – 14/11/2009) & (15/11/2009 – 28/11/2009). This code gives me the no. sold over entire month , but I want to have a braekdown for every week of the month.
A prior post / reply recommended you consider SAS techniques (function like INTNX) to derive a start-of-week variable from which you can generate this type of analysis. With the new week-start variable, you can app
Another pair of functions would be to use the YEAR and WEEK functions to extract these two components from a date-variable to use with your analysis.