*Economena Data: Dubai Airport Monthly Passenger Traffic

clear
cd "C:\Users\Georges\Dropbox (Work)\Data Bank\Economena\UAE\Data for Analysis"
import excel "C:\Users\Georges\Dropbox (Work)\Data Bank\Economena\UAE\Data for Analysis\Dubai Airport Data.xlsx", sheet("Sheet1") firstrow

keep if passenger_transit!=.

*Separating the month and year from date*
gen year=year(date)
label variable year "Year"
gen month=month(date)
label variable month "Month"
label define tag 1 "January" 2 "February" 3 "March" 4 "April" 5 "May" 6 "June" ///
7 "July" 8 "August" 9 "September" 10 "October" 11 "November" 12 "December"
label values month tag

*Create a variable for the total airport traffic*
gen total_traffic = passenger_arrivals + passenger_departure + passenger_transit 
label variable total_traffic "Total number of passengers at Dubai Airport"
su total_traffic

*Graph Pie*
graph pie passenger_arrivals passenger_departure passenger_transit, plabel(_all percent, format("%2.0f") size(large) color(white)) ///
plabel(1 "Arrival", gap(-15) size(medium) color(black) ) ///
plabel(2 "Departure", alignment(baseline) gap(-17) size(medium) color(black)) ///
plabel(3 "Transit", gap(7) size(medium) color(black)) ///
legend(off) title(Share of Passengers by Type) subtitle(Dubai International Airport) ///
note(Source: Economena Analytics Online Databases)

gen arrival_share=passenger_arrival/total_traffic
gen departure_share=passenger_departure/total_traffic 
gen transit_share=passenger_transit/total_traffic 

preserve

collapse (mean) Arrival=arrival_share Departure=departure_share Transit=transit_share, by(year)
label variable Arrival Arrival
label variable Departure Departure 
label variable Transit Transit

replace Arrival = Arrival *100
replace Departure = Departure * 100
replace Transit = Transit * 100

*Line Plots*
twoway (connected Arrival year, msymbol(0h)) (connected Departure year, msymbol(t)) (connected Transit year, yaxis(2) msymbol(s)), legend(on) ///
title("Mean Share of Passengers as Arrivals, Departures or Transit") subtitle(Dubai International Airport) ///
note(Source: Economena Analytics Online Databases) ///
xline(2008 2012, lcolor(red) lpattern(dash)) xlabel(2000 (2) 2014) ///
ytitle(Arrival or Departure)

restore