/* Lucas Zhou */

/* Project: Earth Day */
/* Output the Earth Day Festival Revenue Report */
/* from the dataset earthdayfinal.sas7bdat */

/* March 22 2019 */

title1 'Earth Day Festival';
title3 'Sierra Club';
title4 'Apex High School Chapter';
title6 'Full Event Report';

ods pdf file='/home/lucaszhou0/Earth_Day_Project.pdf' style=grayscaleprinter;

proc sort data = '/home/lucaszhou0/earthdayfinal.sas7bdat' (encoding=wlatin1) out = work.earthdayrev;
by descending DonColct;
run;

options nodate;

proc print data = earthdayrev split = ' ' noobs;
by descending DonColct;
pageby DonColct;
sum donamt;
label Sponsor = 'Sponsor Name'
donamt = 'Donation Amount Pledged'
DonColct = 'Pledge Collected';
var Sponsor donamt;
format donamt dollar11.2;
run;

proc sort data = '/home/lucaszhou0/earthdayfinal.sas7bdat' (encoding=wlatin1) out = work.earthdaygift;
by donamt;
run;

proc format;
value gearned 0-300 = 'No Gift'
301-500 = 'Free Newspaper Ad'
501-1000 = 'Arts Program Sponsorship'
1001-2000 = 'Athletic Program Sponsorship';
run;

proc print data = earthdaygift split = ' ' noobs;
var Sponsor;
var donamt / style(header)={just=l};
label Sponsor = 'Sponsor Name' donamt = 'Gift Earned';
format donamt gearned.;
run;

ods pdf close;