data Example;
Infile datalines dlm=',';
input MonthOfService MonYY5. NumberOfYouth $ ProgramIndex $ Expenditure $;
format MonthofService MonYY5.;
datalines;
JUL13, 6, A1211, 57512.16
JUL13, 1, A1236, 2867.5
JUL13, 2, A1291, 8834
JUL13, 20, A1292, 98601.88
JUL13, 3, A1421, 410.98
JUL13, 7, A1552, 21686.49
JUL13, 1, A1841, 205.17
JUL13, 155,A1911, 179972.06
JUL13, 10, A1912, 5253.34
JUL13, 44, A1916, 17200.8
JUL13, 7, A1917, 7545.48
JUL13, 8, A1918, 4259.63
JUL13, 2, A1957, 1249.02
JUL13, 3, A1961, 3506.19
JUL13, 6, A1962, 2617.05
JUL13, 2, A1964, 1372.25
JUL13, 1, A1971, 7.03
JUL13, 17, A1975, 4398.16
JUL13, 23, A1977, 4476.84
JUL13, 1, A8811, 40
AUG13, 7, A2111, 71842.76
AUG13, 2, A2111, 8428.8
AUG13, 23, A2111, 126240.33
AUG13, 1, A2129, 1239
AUG13, 167,A2106, 191061.43
AUG13, 14, A2106, 7061.28
AUG13, 46, A2109, 18020.98
AUG13, 7, A2124, 7711.68
AUG13, 5, A2126, 903.72
AUG13, 1, A2106, 1867.5
AUG13, 1, A2129, 857.15
AUG13, 5, A2115, 6404.33
AUG13, 10, A2115, 3605.26
AUG13, 2, A2114, 1372.25
AUG13, 16, A2115, 3598.64
AUG13, 28, A2115, 5182.93
SEP13, 7, A2111, 71842.76
SEP13, 1, A2111, 5232
SEP13, 23, A2111, 119037.69
SEP13, 170, A2106, 186012.25
SEP13, 19, A2106, 10104.19
SEP13, 46, A2109, 18979.5
SEP13, 7, A2124, 6747.72
SEP13, 10, A2126, 1856.67
SEP13, 1, A2106, 2490
SEP13, 2, A2129, 1463.45
SEP13, 10, A2115, 8719.17
SEP13, 11, A2115, 3119.92
SEP13, 2, A2114, 951.2
SEP13, 12, A2115, 2337.32
SEP13, 29, A2115, 4405.32 Sorry for the delay, I had to figure out how to even do it first. Here's an example of what 3 months would look like.
... View more
