Thanks for the links Cynthia. I'll give it a go. ... View more

You have the TIMEPART function and also possibly the LAG function to consider using, however I would expect that you have some other "BY variable list" to consider for each "item" with your analysis - that's not shown in your Excel file. Scott Barry SBBWorks, Inc. Suggested Google advanced search arguments, this topic/post: timepart function site:sas.com lag function site:sas.com by group processing site:sas.com ... View more

Thanks Doc@Duke for the help, that was exactly what i was looking for and thanks for the links Cynthia@sas. ... View more