Hello All,
I am running into an issue when I try to report all the activity for the previous month. There are 2 issues my month is not the same as the calendar month(meaning the a school_month can span between 2 calendar months) I have a table which gives me the start date and end date for each school_month with the month_number. I also have a column where I can check what the current school month is, but I am not able to filter on the data for the previous month. Here is how the data is
m_start_date m_end_date s_month curr_s_month
8/25/09 9/22/09 1
9/23/09 10/22/09 2
4/15/10 5/12/10 8
5/13/10 6/10/10 9 9 ( because today's date falls in this range)
and I want to display all records for
s_month=8 until cur_month = 9 and
s_month = 9 when cur_month = 10
Is this even possible......
I appreciate any input you have. And thanks to all of you I have been able to use SAS in a much more efficient way.
Thanks
Shri