Hello Stata users;
The first variable is the bus type or brand, the second variable is the total of buses of that brand or type in the fleet, third variable is the seating capacity (or maximul passenger load) per bus brand, fourth variable is the number of immobilized buses per type due to technical and maintenance difficulties (so they are not available for the firm, even if they are sitting in maintenace garages), and the fifth variable is the number of available buses for work.
I would love to have a table which shows the number of total buses, as well as the number of available or operational ones, and the seating capacity for the buses, all that per bus type or brand. Also, would wanna have the total of each number. I would love to have the final result in the form of a table.
With thanks!
Code:
* Example generated by -dataex-. To install: ssc install dataex clear input str21 marque int(parc_total capacit_par_bus_nombre_de_siges) byte(parc_immobilis parc_disponible) "MAN" 22 55 11 11 "Iris Bus" 7 54 7 0 "Iris Bus Van Hool" 1 56 0 1 "Iris Bus Domino" 1 56 1 0 "Temsa" 2 29 2 0 "Bova" 2 56 2 0 "Volvo B7R (49 places)" 1 49 0 1 "Volvo B7R (51 places)" 23 51 9 14 "Volvo B7R (55 places)" 2 55 0 2 "Volvo B10M" 1 47 1 0 "Volvo B11" 46 53 13 33 "Volvo B9R" 21 53 6 15 "Mini-Bus OTOKAR" 3 29 1 2 "Mini-Bus Toyota" 2 9 2 0 "Mini-Bus King Long" 1 30 0 1 "Total" 135 682 55 80 end
I would love to have a table which shows the number of total buses, as well as the number of available or operational ones, and the seating capacity for the buses, all that per bus type or brand. Also, would wanna have the total of each number. I would love to have the final result in the form of a table.
With thanks!
