--------------------------------------------- Examining project: \\l73391\c$\DataSources\DonorsChoose\DonorsChoose.egp Process flows within project: Data Descriptors SASHELP VTABLE ( SAS.EG.Scripting.Data ) SASHELP VCOLUMN ( SAS.EG.Scripting.Data ) Data Description ( SAS.EG.Scripting.Report ) Data Imported from donorschoose-org-1may2011-v1-donations.csv ( SAS.EG.Scripting.Data ) Characterize Data ( SAS.EG.Scripting.Task ) Data Imported from donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.Data ) Characterize Data ( SAS.EG.Scripting.Task ) Data Imported from donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.Data ) Characterize Data ( SAS.EG.Scripting.Task ) Data Description ( SAS.EG.Scripting.Query ) Column descriptions ( SAS.EG.Scripting.Query ) Link to Data Imported from donorschoose-org-1may2011-v1-donations.csv ( SAS.EG.Scripting.Link ) Link to Data Imported from donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.Link ) Link to Data Imported from donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.Link ) Link to SASHELP VTABLE ( SAS.EG.Scripting.Link ) Link to SASHELP VCOLUMN ( SAS.EG.Scripting.Link ) About the data Normalized Data Schema ( SAS.EG.Scripting.File ) Data Schema ( SAS.EG.Scripting.File ) Data Quality ProjectCost ( SAS.EG.Scripting.Data ) Summary Statistics ( SAS.EG.Scripting.Task ) ProjectCostDetails ( SAS.EG.Scripting.Data ) COSTLESSTHANZERO ( SAS.EG.Scripting.Data ) Data Imported from donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.Data ) Data Imported from donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.Data ) P99 ( SAS.EG.Scripting.Data ) OUTLIERS ( SAS.EG.Scripting.Data ) OneProject ( SAS.EG.Scripting.Data ) Calc Project Cost ( SAS.EG.Scripting.Query ) Join with Project Details ( SAS.EG.Scripting.Query ) Check Project Cost Range ( SAS.EG.Scripting.Query ) Distribution ( SAS.EG.Scripting.Code ) Autoexec Assign DC library ( SAS.EG.Scripting.Code ) OLAP Views DONORSCHOOSE_PROJECTS_SLICE_0001 ( SAS.EG.Scripting.Data ) DonorsChoose Projects ( SAS.EG.Scripting.Cube ) Analysis Data Imported from donorschoose-org-1may2011-v1-donations.csv ( SAS.EG.Scripting.Data ) Grouped Freq of Donation Amt ( SAS.EG.Scripting.Task ) State Freq ( SAS.EG.Scripting.Task ) Dollar Amount Freq ( SAS.EG.Scripting.Task ) Cell statistics for donor_state analysis of DC.DONATIONS ( SAS.EG.Scripting.Data ) StateNames ( SAS.EG.Scripting.Data ) Chart Of Donors ( SAS.EG.Scripting.Task ) US ( SAS.EG.Scripting.Data ) Chart Of Donors ( SAS.EG.Scripting.Task ) Chart of Projects ( SAS.EG.Scripting.Task ) Data Imported from donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.Data ) ProjectsPerState ( SAS.EG.Scripting.Data ) Chart of Projects ( SAS.EG.Scripting.Task ) Map Report of Donors & Projects ( SAS.EG.Scripting.Report ) Data Imported from donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.Data ) VendorSpend ( SAS.EG.Scripting.Data ) List Report ( SAS.EG.Scripting.Task ) QUERY_FOR_PROJECTS ( SAS.EG.Scripting.Data ) Cell statistics for dollar_amount analysis of DC.DONATIONS ( SAS.EG.Scripting.Data ) Trend of amts ( SAS.EG.Scripting.Task ) MakeStateNames ( SAS.EG.Scripting.Query ) Count Projects per State ( SAS.EG.Scripting.Query ) Calc Vendor Spend ( SAS.EG.Scripting.Query ) Query Builder ( SAS.EG.Scripting.Query ) Assign Library ( SAS.EG.Scripting.Code ) Link to DONATIONS ( SAS.EG.Scripting.Link ) Link to PROJECTS ( SAS.EG.Scripting.Link ) Link to US ( SAS.EG.Scripting.Link ) Link to RESOURCES ( SAS.EG.Scripting.Link ) Import DonorsChoose CSV donorschoose-org-1may2011-v1-donations.csv ( SAS.EG.Scripting.File ) donorschoose-org-1may2011-v1-giftcards.csv ( SAS.EG.Scripting.File ) Data Imported from donorschoose-org-1may2011-v1-donations.csv ( SAS.EG.Scripting.Data ) Data Imported from donorschoose-org-1may2011-v1-giftcards.csv ( SAS.EG.Scripting.Data ) donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.File ) Data Imported from donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.Data ) donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.File ) Data Imported from donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.Data ) ESSAYS ( SAS.EG.Scripting.Data ) Assign Library ( SAS.EG.Scripting.Code ) Import Essays ( SAS.EG.Scripting.Code ) Optimize Data (LONG!) ( SAS.EG.Scripting.Code ) Link to donorschoose-org-1may2011-v1-donations.csv ( SAS.EG.Scripting.Link ) Link to donorschoose-org-1may2011-v1-giftcards.csv ( SAS.EG.Scripting.Link ) Link to donorschoose-org-1may2011-v1-projects.csv ( SAS.EG.Scripting.Link ) Link to donorschoose-org-1may2011-v1-resources.csv ( SAS.EG.Scripting.Link ) Link to Import Essays ( SAS.EG.Scripting.Link ) Link to Optimize Data ( SAS.EG.Scripting.Link ) Link to Optimize Data ( SAS.EG.Scripting.Link ) Link to Optimize Data ( SAS.EG.Scripting.Link ) Link to Optimize Data ( SAS.EG.Scripting.Link ) Link to Optimize Data ( SAS.EG.Scripting.Link ) ------------------------------------------------------ ALL Data used within project: DC.GIFTCARDS on server SASApp DC.DONATIONS on server SASApp WORK.COSTLESSTHANZERO on server SASApp DC.DONATIONS on server SASApp DC.RESOURCES on server SASApp WORK.QUERY_FOR_PROJECTS on server SASApp DC.PROJECTS on server SASApp WORK.PROJECTCOST on server SASApp SASHELP.VCOLUMN on server SASApp WORK.OUTLIERS on server SASApp DC.RESOURCES on server SASApp WORK.DONORSCHOOSE_PROJECTS_SLICE_0001 on server SASApp DC.PROJECTS on server SASApp DC.PROJECTS on server SASApp DC.PROJECTS on server SASApp WORK.VENDORSPEND on server SASApp DC.ESSAYS on server SASApp WORK.PROJECTSPERSTATE on server SASApp MAPS.US on server SASApp DC.DONATIONS on server SASApp WORK.DOLLARBYYEAR on server SASApp WORK.ONEPROJECT on server SASApp WORK.STATEFREQ on server SASApp DC.RESOURCES on server SASApp DC.RESOURCES on server SASApp WORK.STATENAMES on server SASApp WORK.P99 on server SASApp WORK.PROJECTCOSTDETAILS on server SASApp SASHELP.VTABLE on server SASApp ALL SAS programs embedded within project: " Assign DC library " runs on server SASApp " Optimize Data (LONG!) " runs on server SASApp " Assign Library " runs on server SASApp " Distribution " runs on server SASApp " Assign Library " runs on server SASApp " Import Essays " runs on server SASApp