Hi all,

I have data in the following format:

Code:
 
 * Example generated by -dataex-. For more info, type help dataex clear input long(mci cl_id) float(yearmo_call servicemonth1) 1000  992094 720 636 1000 1179866 708 707 1000 1036729 708 645 1000  854614 696 636 1000  854614 696 636 1000  864615 624 681 1000  908069 708 636 1000  871369 672 636 1000 1125496 684 636 1000  881157 600 636 1000  833150 672 636  1000  820983 588 636 1000  963879 624 636 end format %tm yearmo_call format %tm servicemonth1
You can think of mci and cl_id as a sort of identifier in the data. Yearmo_call is the year and month that a call comes in. Servicemonth1 is the month a service occurs....in my data there are variables for servicemonth1-servicemonth95. I would like to create a long data set that has an observation for each mci at the yearmonth level. So, even if they do not get a call or service in that yearmonth, I just have an observation that shows 0s for that month.

I would like something similar to this:

MCI YearMonthVariable CallOccurred ServiceOccurred
1 2014m1 0 0
1 2014m2 1 0
1 2014m3 0 0

And so on and so forth for every ID and every yearmonth. Any ideas?
--Collin