proc format;
value yrFmt . = " All";
value $schFmt " " = "All ";
run;
data Charity;
input School $ 1-7 Year 9-12 Name $ 14-20 moneyRaised 22-26
hoursVolunteered 28-29;
format moneyRaised dollar8.2;
format hoursVolunteered f3.0;
format Year yrFmt.;
format School schFmt.;
label School = "Schools";
label Year = "Years";
retain yearmin yearmax;
yearmin=min(yearmin,year);
yearmax=max(yearmax,year);
call symput('first_year',put(yearmin,4.));
call symput('last_year', put(yearmax,4.));
datalines;
Monroe 1992 Allison 31.65 19
Monroe 1992 Barry 23.76 16
Monroe 1992 Candace 21.11 5
Monroe 1992 Danny 6.89 23
Monroe 1992 Edward 53.76 31
Monroe 1992 Fiona 48.55 13
Monroe 1992 Gert 24.00 16
Monroe 1992 Harold 27.55 17
Monroe 1992 Ima 5.98 9
Monroe 1992 Jack 20.00 23
Monroe 1992 Katie 22.11 2
Monroe 1992 Lisa 18.34 17
Monroe 1992 Tonya 55.16 40
Monroe 1992 Max 26.77 34
Monroe 1992 Ned 28.43 22
Monroe 1992 Opal 32.66 14
Monroe 1993 Patsy 18.33 18
Monroe 1993 Quentin 16.89 15
Monroe 1993 Randall 12.98 17
Monroe 1993 Sam 15.88 5
Monroe 1993 Tyra 21.88 23
Monroe 1993 Myrtle 47.33 26
Monroe 1993 Frank 41.11 22
Monroe 1993 Cameron 65.44 14
Monroe 1993 Vern 17.89 11
Monroe 1993 Wendell 23.00 10
Monroe 1993 Bob 26.88 6
Monroe 1993 Leah 28.99 23
Monroe 1994 Becky 30.33 26
Monroe 1994 Sally 35.75 27
Monroe 1994 Edgar 27.11 12
Monroe 1994 Dawson 17.24 16
Monroe 1994 Lou 5.12 16
Monroe 1994 Damien 18.74 17
Monroe 1994 Mona 27.43 7
Monroe 1994 Della 56.78 15
Monroe 1994 Monique 29.88 19
Monroe 1994 Carl 31.12 25
Monroe 1994 Reba 35.16 22
Monroe 1994 Dax 27.65 23
Monroe 1994 Gary 23.11 15
Monroe 1994 Suzie 26.65 11
Monroe 1994 Benito 47.44 18
Monroe 1994 Thomas 21.99 23
Monroe 1994 Annie 24.99 27
Monroe 1994 Paul 27.98 22
Monroe 1994 Alex 24.00 16
Monroe 1994 Lauren 15.00 17
Monroe 1994 Julia 12.98 15
Monroe 1994 Keith 11.89 19
Monroe 1994 Jackie 26.88 22
Monroe 1994 Pablo 13.98 28
Monroe 1994 L.T. 56.87 33
Monroe 1994 Willard 78.65 24
Monroe 1994 Kathy 32.88 11
Monroe 1994 Abby 35.88 10
Kennedy 1992 Arturo 34.98 14
Kennedy 1992 Grace 27.55 25
Kennedy 1992 Winston 23.88 22
Kennedy 1992 Vince 12.88 21
Kennedy 1992 Claude 15.62 5
Kennedy 1992 Mary 28.99 34
Kennedy 1992 Abner 25.89 22
Kennedy 1992 Jay 35.89 35
Kennedy 1992 Alicia 28.77 26
Kennedy 1992 Freddy 29.00 27
Kennedy 1992 Eloise 31.67 25
Kennedy 1992 Jenny 43.89 22
Kennedy 1992 Thelma 52.63 21
Kennedy 1992 Tina 19.67 21
Kennedy 1992 Eric 24.89 12
Kennedy 1993 Bubba 37.88 12
Kennedy 1993 G.L. 25.89 21
Kennedy 1993 Bert 28.89 21
Kennedy 1993 Clay 26.44 21
Kennedy 1993 Leeann 27.17 17
Kennedy 1993 Georgia 38.90 11
Kennedy 1993 Bill 42.23 25
Kennedy 1993 Holly 18.67 27
Kennedy 1993 Benny 19.09 25
Kennedy 1993 Cammie 28.77 28
Kennedy 1993 Amy 27.08 31
Kennedy 1993 Doris 22.22 24
Kennedy 1993 Robbie 19.80 24
Kennedy 1993 Ted 27.07 25
Kennedy 1993 Sarah 24.44 12
Kennedy 1993 Megan 28.89 11
Kennedy 1993 Jeff 31.11 12
Kennedy 1993 Taz 30.55 11
Kennedy 1993 George 27.56 11
Kennedy 1993 Heather 38.67 15
Kennedy 1994 Nancy 29.90 26
Kennedy 1994 Rusty 30.55 28
Kennedy 1994 Mimi 37.67 22
Kennedy 1994 J.C. 23.33 27
Kennedy 1994 Clark 27.90 25
Kennedy 1994 Rudy 27.78 23
Kennedy 1994 Samuel 34.44 18
Kennedy 1994 Forrest 28.89 26
Kennedy 1994 Luther 72.22 24
Kennedy 1994 Trey 6.78 18
Kennedy 1994 Albert 23.33 19
Kennedy 1994 Che-Min 26.66 33
Kennedy 1994 Preston 32.22 23
Kennedy 1994 Larry 40.00 26
Kennedy 1994 Anton 35.99 28
Kennedy 1994 Sid 27.45 25
Kennedy 1994 Will 28.88 21
Kennedy 1994 Morty 34.44 25
;
run;