Code:
* Example generated by -dataex-. To install: ssc install dataex clear input long customer_id float platform 35 1 35 1 10794785 3 12407667 3 35 1 35 1 35 1 35 1 35 1 6834617 2 35 1 7280359 2 35 1 10893468 2 1747974 2 12093434 4 35 1 9821471 3 35 1 2676426 3 35 1 35 1 35 1 35 1 35 1 35 1 35 1 8139630 4 35 1 35 1 12562025 3 35 1 11295091 2 13108472 2 35 1 35 1 9369267 3 35 1 11268838 2 6344472 2 35 1 35 1 7123191 2 11725152 2 4959683 2 35 1 35 1 35 1 11462866 2 2730348 3 35 1 35 1 35 1 11872647 2 9930565 4 35 1 35 1 8404195 3 35 1 35 1 9930565 4 35 1 35 1 35 1 35 1 35 1 35 1 35 1 1438304 2 35 1 35 1 35 1 9930565 4 5490563 3 35 1 5454891 2 3200165 4 10484546 2 11274718 2 35 1 35 1 35 1 9930565 4 10038218 3 35 1 9369267 3 35 1 4621500 3 35 1 5863677 2 35 1 35 1 35 1 9930565 4 11040634 3 35 1 35 1 35 1 35 1 35 1 end
The variable customer_id represents unique customer id. The variable platform represents the platform through which an customer ordered food. I would like to create a variable which shows the percentage of orders through platform 1 with respect to customer_id. If the customer has not ordered through platform 1, then 0. How should I proceed to create the new variable?
Comment