Re: st: Disaggregating the values taken by a Stata variable

[Sergiy Radyakin <serjradyakin@gmail.com>]

you write that you know how to do aggregation, so just do it on the
level of postal codes (extend at ellipsis with the codes) as shown
below. or if you don't have postal codes, that how do you identify the
location? merging is of course better.
Sergiy.

clear

input str6 pc str6 region
K2K0A9 Ottawa
K4K0A2 Ottawa
K4K1A4 Ottawa
K2K1A2 Ottawa
K4K1W2 Ottawa
K2W1J3 Ottawa
end

list

generate sub_reg=""
replace sub_reg="kanata" if pc=="K2K0A9" | pc=="K2K0B2" | pc=="K2K1A2"
| /*... |*/ pc=="K2W1J3"
replace sub_reg="rockland" if pc=="K4K0A2" | pc=="K4K1A4" |
pc=="K4K1A5" | /*... |*/ pc=="K4K1W2"
list

local pc_kanata " K2K0A9 K2K0B2 K2K1A2 K2K1A8 K2K1B6 K2K1C4 K2K1C8
K2K1E1 K2K1E2 K2K1E3 K2K1E5 K2K1E6 K2K1E7 K2K1G3 K2K1G8 K2K1H1 K2K1H7
K2K1H8 K2K1J2 K2K1J3 K2K1J5 K2K1J6 K2K1K1 K2K1K2 K2K1K4 K2K1K5 K2K1K6
K2K1K9 K2K1L2 K2K1L3 K2K1L7 K2K1L8 K2K1L9 K2K1M1 K2K1M3 K2K1M4 K2K1M8
K2K1M9 K2K1N1 K2K1N6 K2K1N8 K2K1P1 K2K1P3 K2K1P4 K2K1R4 K2K1S1 K2K1S4
K2K1S5 K2K1T4 K2K1V2 K2K1V3 K2K1V5 K2K1V6 K2K1V8 K2K1W1 K2K1W5 K2K1W7
K2K1X3 K2K1X6 K2K1X7 K2K1Y7 K2K1Y8 K2K1Z2 K2K1Z3 K2K2B1 K2K2B2 K2K2B6
K2K2C3 K2K2C5 K2K2C8 K2K2E1 K2K2E2 K2K2E3 K2K2E6 K2K2G2 K2K2G6 K2K2H2
K2K2H3 K2K2H4 K2K2H6 K2K2H8 K2K2J2 K2K2J8 K2K2J9 K2K2K2 K2K2K3 K2K2K4
K2K2K5 K2K2K6 K2K2K8 K2K2L1 K2K2L2 K2K2L3 K2K2L4 K2K2L5 K2K2L6 K2K2L8
K2K2L9 K2K2M1 K2K2M3 K2K2M4 K2K2M5 K2K2M6 K2K2M7 K2K2N1 K2K2N2 K2K2N3
K2K2N5 K2K2N6 K2K2N7 K2K2N8 K2K2N9 K2K2P1 K2K2P2 K2K2P4 K2K2P6 K2K2P8
K2K2P9 K2K2R2 K2K2R4 K2K2R5 K2K2R6 K2K2R7 K2K2R8 K2K2R9 K2K2S1 K2K2S2
K2K2S3 K2K2S5 K2K2S6 K2K2S7 K2K2S9 K2K2T2 K2K2T3 K2K2T4 K2K2T7 K2K2V1
K2K2V2 K2K2V4 K2K2V5 K2K2V6 K2K2V7 K2K2W1 K2K2W2 K2K2W7 K2K2W9 K2K2X2
K2K2X3 K2K2X4 K2K2X5 K2K2X7 K2K2X8 K2K2Z5 K2K2Z6 K2K2Z7 K2K3A2 K2K3A4
K2K3A6 K2K3A7 K2K3A8 K2K3A9 K2K3B1 K2K3B2 K2K3B3 K2K3B4 K2K3B5 K2K3B9
K2K3C1 K2K3C3 K2K3C4 K2K3C6 K2K3C7 K2K3E2 K2K3E3 K2K3E4 K2K3E5 K2K3E7
K2K3G1 K2K3G4 K2K3G6 K2K3G7 K2K3H1 K2K3H2 K2K3H5 K2K3H6 K2K3H7 K2K3H8
K2K3H9 K2K3J2 K2K3J4 K2K3J5 K2K3J6 K2K3J7 K2K3J8 K2K3K2 K2K3K4 K2K3K6
K2K3K8 K2K3K9 K2K3L2 K2K3L3 K2K3L4 K2K3L5 K2K3L8 K2K3L9 K2K3M1 K2K3M2
K2K3M3 K2K3M4 K2K3M5 K2K3M6 K2K3M8 K2K3M9 K2K3N2 K2K3N3 K2K3N4 K2K3N5
K2K3N6 K2K3N8 K2K3P1 K2K3P4 K2K3P8 K2K3P9 K2K3R2 K2K3R3 K2K3R5 K2K3R6
K2L1A1 K2L1A2 K2L1A3 K2L1A4 K2L1A5 K2L1B3 K2L1B9 K2L1C3 K2L1C5 K2L1C6
K2L1E3 K2L1E6 K2L1E7 K2L1E9 K2L1G2 K2L1H2 K2L1J1 K2L1J4 K2L1J5 K2L1K1
K2L1K8 K2L1L1 K2L1L2 K2L1L3 K2L1L9 K2L1M1 K2L1M4 K2L1M7 K2L1M8 K2L1N1
K2L1N3 K2L1N4 K2L1N5 K2L1N6 K2L1P6 K2L1P9 K2L1R1 K2L1R4 K2L1R9 K2L1S4
K2L1S5 K2L1S8 K2L1T3 K2L1T4 K2L1T5 K2L1V2 K2L1V3 K2L1V4 K2L1W4 K2L1W5
K2L1W9 K2L1X3 K2L1X4 K2L1X7 K2L1Y3 K2L1Y4 K2L1Z2 K2L1Z3 K2L1Z4 K2L1Z6
K2L1Z7 K2L1Z9 K2L2A1 K2L2A2 K2L2A4 K2L2A5 K2L2A7 K2L2B3 K2L2B6 K2L2B8
K2L2B9 K2L2C4 K2L2C5 K2L2C7 K2L2C8 K2L2C9 K2L2E3 K2L2E4 K2L2E6 K2L2E7
K2L2E8 K2L2G5 K2L2G6 K2L2G7 K2L2H1 K2L2H6 K2L2H7 K2L2H8 K2L2J1 K2L2J2
K2L2J3 K2L2J5 K2L2J8 K2L2J9 K2L2K1 K2L2K3 K2L2K4 K2L2K6 K2L2K7 K2L2K9
K2L2L1 K2L2L6 K2L2L7 K2L2L9 K2L2M3 K2L2N2 K2L2N4 K2L2N6 K2L2N8 K2L2N9
K2L2P3 K2L2P8 K2L2R3 K2L2R5 K2L2R7 K2L2S8 K2L2S9 K2L2T4 K2L2T5 K2L2V2
K2L2V5 K2L2W3 K2L2W4 K2L2W5 K2L2W7 K2L2W9 K2L2X1 K2L2X2 K2L2X4 K2L2Y1
K2L2Y3 K2L2Y4 K2L2Z6 K2L2Z7 K2L3A4 K2L3A5 K2L3A6 K2L3A7 K2L3A8 K2L3A9
K2L3B1 K2L3C9 K2L3E2 K2L3H1 K2L3H2 K2L3J7 K2L3J8 K2L3J9 K2L3K1 K2L3K3
K2L3K5 K2L3K7 K2L3K8 K2L3L3 K2L3L5 K2L3L8 K2L3M1 K2L3M2 K2L3M4 K2L3M5
K2L3M8 K2L3M9 K2L3N1 K2L3N5 K2L3N6 K2L3P1 K2L3P2 K2L3P3 K2L3P4 K2L3P8
K2L3R6 K2L3S2 K2L3S4 K2L3S6 K2L3T3 K2L3T5 K2L3T7 K2L3V2 K2L3V7 K2L3V8
K2L3W1 K2L3W3 K2L3W4 K2L3W5 K2L3W9 K2L3X1 K2L3X2 K2L3X7 K2L3Y5 K2L3Y6
K2L3Y9 K2L3Z2 K2L3Z6 K2L4A5 K2L4A6 K2L4A8 K2L4B5 K2L4B9 K2L4C1 K2L4C7
K2L4E1 K2L4E2 K2L4E3 K2L4E9 K2L4G1 K2L4G7 K2L4G9 K2L4H1 K2L4H2 K2L5T4
K2M0A2 K2M0A8 K2M1A2 K2M1A3 K2M1A5 K2M1A6 K2M1B1 K2M1B5 K2M1B6 K2M1B7
K2M1C2 K2M1C4 K2M1C5 K2M1C8 K2M1E8 K2M1E9 K2M1G2 K2M1G6 K2M1H7 K2M1H8
K2M1H9 K2M1K9 K2M1L1 K2M1L4 K2M1L6 K2M1L7 K2M1L8 K2M1L9 K2M1M1 K2M1M2
K2M1M5 K2M1M6 K2M1M9 K2M1N2 K2M1N3 K2M1N6 K2M1P2 K2M1P3 K2M1P8 K2M1R1
K2M1R2 K2M1R5 K2M1R8 K2M1S6 K2M1S7 K2M1T1 K2M1T2 K2M1T3 K2M1T4 K2M1T5
K2M1T6 K2M1T8 K2M1T9 K2M1V3 K2M1V4 K2M1V8 K2M1W2 K2M1W7 K2M1W8 K2M1X1
K2M1X9 K2M1Y7 K2M1Z1 K2M1Z2 K2M1Z4 K2M1Z8 K2M1Z9 K2M2A2 K2M2A3 K2M2A6
K2M2A7 K2M2A8 K2M2A9 K2M2B1 K2M2B5 K2M2B6 K2M2B9 K2M2C1 K2M2C7 K2M2C8
K2M2E2 K2M2E3 K2M2E4 K2M2E5 K2M2E6 K2M2E7 K2M2E8 K2M2G5 K2M2G6 K2M2G7
K2M2H1 K2M2H3 K2M2H4 K2M2H5 K2M2H6 K2M2H7 K2M2H8 K2M2H9 K2M2J1 K2M2J5
K2M2J6 K2M2J7 K2M2J8 K2M2J9 K2M2K1 K2M2K2 K2M2K3 K2M2K4 K2M2K5 K2M2K6
K2M2K7 K2M2K8 K2M2K9 K2M2L1 K2M2L3 K2M2L5 K2M2L6 K2M2L8 K2M2M1 K2M2M2
K2M2M4 K2M2M5 K2M2M6 K2M2M7 K2M2M9 K2M2N1 K2M2N3 K2M2N4 K2M2N6 K2M2N7
K2M2P2 K2M2P3 K2M2P6 K2M2R1 K2M2R2 K2M2R3 K2M2R6 K2M2R7 K2M2R8 K2M2R9
K2M2S1 K2M2S2 K2M2S3 K2M2S4 K2M2S5 K2M2S6 K2M2T3 K2M2T4 K2M2T6 K2M2V2
K2M2V3 K2M2V4 K2M2V5 K2M2V7 K2M2W5 K2M2W6 K2M2W7 K2M2W8 K2M2W9 K2M2X1
K2M2X2 K2M2X3 K2M2X7 K2M2X8 K2M2Y4 K2M2Y5 K2M2Y6 K2M2Y7 K2M2Y9 K2M2Z1
K2M2Z3 K2M2Z5 K2M2Z6 K2M2Z8 K2M3A1 K2M3A3 K2M3A4 K2M3A6 K2M3A8 K2M3A9
K2M3B1 K2M3B2 K2T1A9 K2T1B1 K2T1B2 K2T1B3 K2T1B4 K2T1B8 K2T1C1 K2T1C7
K2T1C8 K2T1C9 K2T1E1 K2T1E2 K2T1E4 K2T1E5 K2T1E9 K2T1G2 K2T1G4 K2T1G6
K2T1G8 K2T1G9 K2T1H2 K2T1H3 K2T1H4 K2T1J1 K2T1J2 K2T1J3 K2T1J4 K2T1J5
K2T1J6 K2T1J7 K2T1J8 K2T1J9 K2T1K1 K2T1K6 K2T1K7 K2T1K9 K2T2Z9 K2T8T8
K2V1A5 K2V1A6 K2V1B2 K2V1B5 K2V1C2 K2V1C3 K2V1C5 K2W1A2 K2W1A3 K2W1A4
K2W1A6 K2W1A7 K2W1A8 K2W1A9 K2W1B5 K2W1B6 K2W1C2 K2W1C4 K2W1C5 K2W1C6
K2W1C7 K2W1C8 K2W1E1 K2W1E2 K2W1E3 K2W1E4 K2W1E6 K2W1E7 K2W1E8 K2W1E9
K2W1G1 K2W1G2 K2W1G3 K2W1G5 K2W1G6 K2W1G7 K2W1G8 K2W1G9 K2W1H2 K2W1H3
K2W1H5 K2W1H6 K2W1H7 K2W1H9 K2W1J1 K2W1J2 K2W1J3 "
local pc_rockland " K4K0A2 K4K1A4 K4K1A5 K4K1A7 K4K1A8 K4K1B2 K4K1B3
K4K1B5 K4K1B6 K4K1B7 K4K1B8 K4K1C1 K4K1C5 K4K1C6 K4K1C8 K4K1C9 K4K1E3
K4K1E4 K4K1E5 K4K1E6 K4K1E7 K4K1G1 K4K1G2 K4K1G3 K4K1G4 K4K1G5 K4K1G7
K4K1G9 K4K1H1 K4K1H2 K4K1H3 K4K1H5 K4K1H8 K4K1H9 K4K1J4 K4K1J6 K4K1J8
K4K1J9 K4K1K3 K4K1K4 K4K1K5 K4K1K6 K4K1K7 K4K1K9 K4K1L4 K4K1L5 K4K1M4
K4K1M8 K4K1M9 K4K1N1 K4K1N2 K4K1N5 K4K1N7 K4K1N8 K4K1P8 K4K1R7 K4K1R8
K4K1R9 K4K1S1 K4K1S3 K4K1S4 K4K1T1 K4K1V1 K4K1V7 K4K1V9 K4K1W1 K4K1W2
"
local pc_nepean " K2G0A1 K2G0A3 K2G0A4 K2G0A5 K2G0B2 K2G0B3 K2G0B5
K2G0B8 K2G0B9 K2G0E8 K2G0G4 K2G0G9 K2G0H8 K2G0J3 K2G0L4 K2G0M3 K2G0M4
K2G0M7 K2G0N3 K2G0N9 K2G0P1 K2G0P7 K2G0R3 K2G0R7 K2G0R8 K2G0T5 K2G0T7
K2G0V5 K2G0W2 K2G0Z5 K2G0Z6 K2G1A0 K2G1A1 K2G1A2 K2G1A4 K2G1A7 K2G1B2
K2G1B5 K2G1B8 K2G1C5 K2G1C7 K2G1E4 K2G1G7 K2G1G9 K2G1M8 K2G1R6 K2G1T9
K2G1V1 K2G1V2 K2G1V8 K2G1W4 K2G1W8 K2G1X2 K2G1Y3 K2G1Y6 K2G1Z1 K2G1Z3
K2G2A3 K2G2A6 K2G2B6 K2G2B8 K2G2C8 K2G2E4 K2G2G7 K2G2J6 K2G2L1 K2G2M4
K2G2M6 K2G2M9 K2G2N1 K2G2N4 K2G2N5 K2G2N6 K2G2N7 K2G2P7 K2G2P8 K2G2R8
K2G2S3 K2G2T1 K2G2T5 K2G2T6 K2G2T9 K2G2V2 K2G2V5 K2G2W5 K2G2W6 K2G2X7
K2G2X9 K2G2Y5 K2G2Y6 K2G2Z2 K2G2Z3 K2G2Z5 K2G2Z6 K2G2Z9 K2G3A8 K2G3A9
K2G3B3 K2G3B6 K2G3C4 K2G3C7 K2G3C9 K2G3E5 K2G3E6 K2G3G3 K2G3G6 K2G3G7
K2G3G9 K2G3J9 K2G3K2 K2G3K8 K2G3M5 K2G3M7 K2G3N6 K2G3N7 K2G3P8 K2G3R4
K2G3R5 K2G3R6 K2G3R7 K2G3S1 K2G3S2 K2G3S8 K2G3S9 K2G3T1 K2G3T7 K2G3V1
K2G3V5 K2G3V7 K2G3V8 K2G3W2 K2G3W8 K2G3W9 K2G3X1 K2G3X4 K2G3X8 K2G3X9
K2G3Y1 K2G3Y3 K2G3Y4 K2G3Y5 K2G3Y6 K2G3Y7 K2G3Z2 K2G3Z3 K2G3Z6 K2G4A1
K2G4A8 K2G4A9 K2G4B5 K2G4B6 K2G4B8 K2G4C1 K2G4C7 K2G4C8 K2G4E4 K2G4E5
K2G4E8 K2G4G1 K2G4G3 K2G4G4 K2G4H2 K2G4H3 K2G4H4 K2G4H8 K2G4J5 K2G4K2
K2G4K8 K2G4K9 K2G4L1 K2G4L2 K2G4L4 K2G4L5 K2G4L6 K2G4L7 K2G4L8 K2G4M6
K2G4M8 K2G4M9 K2G4N1 K2G4N4 K2G4P2 K2G4V2 K2G4W1 K2G4W3 K2G4W6 K2G4W7
K2G4X2 K2G4Y1 K2G4Y2 K2G4Y4 K2G4Y9 K2G4Z2 K2G4Z4 K2G5A3 K2G5A6 K2G5A9
K2G5B1 K2G5B2 K2G5B4 K2G5B8 K2G5C6 K2G5C8 K2G5E3 K2G5E5 K2G5E6 K2G5E8
K2G5E9 K2G5G3 K2G5G9 K2G5H1 K2G5H2 K2G5H9 K2G5J1 K2G5J6 K2G5J7 K2G5L1
K2G5L2 K2G5L8 K2G5L9 K2G5M3 K2G5M9 K2G5N4 K2G5N5 K2G5N6 K2G5N7 K2G5P9
K2G5R2 K2G5R3 K2G5R4 K2G5S4 K2G5S6 K2G5S7 K2G5S9 K2G5T3 K2G5T4 K2G5T8
K2G5V1 K2G5V2 K2G5V4 K2G5V8 K2G5V9 K2G5W6 K2G5W7 K2G5W9 K2G5X3 K2G5X4
K2G5X9 K2G5Y2 K2G5Y3 K2G5Y4 K2G5Y5 K2G5Y7 K2G5Y9 K2G5Z1 K2G5Z2 K2G5Z3
K2G5Z4 K2G5Z5 K2G5Z6 K2G5Z7 K2G5Z8 K2G6A2 K2G6A3 K2G6A4 K2G6A6 K2G6A7
K2G6A8 K2G6B1 K2G6B2 K2G6B3 K2G6B4 K2G6B5 K2G6B6 K2G6B7 K2G6B9 K2G6C2
K2G6C3 K2G6C4 K2G6C5 K2G6C6 K2G6C7 K2G6C8 K2G6C9 K2G6E3 K2G6E5 K2G6E6
K2G6E7 K2G6E9 K2G6G3 K2G6G4 K2G6G5 K2G6G8 K2G6H2 K2G6H3 K2G6H5 K2G6H6
K2G6J4 K2G6J5 K2G6J6 K2G6J8 K2G6J9 K2G6K1 K2G6K2 K2G6K3 K2G6K4 K2G6K5
K2G6K6 K2G6L3 K2G6L6 K2G6L7 K2G6L9 K2G6M1 K2G6M2 K2G6M4 K2G6M6 K2G6M7
K2G6N2 K2G6N3 K2G6N5 K2G6N8 K2G6N9 K2G6P2 K2G6P4 K2G6P5 K2G6P6 K2G6R1
K2G6R2 K2G6R4 K2G6R5 K2G6R6 K2G6R7 K2G6R9 K2G6S1 K2G6S2 K2G6S3 K2G6S4
K2G6S5 K2G6S6 K2G6S7 K2G6S8 K2G6S9 K2G6T2 K2G6T3 K2G6T4 K2G6T5 K2G6T6
K2G6T7 K2G6T8 K2G6T9 K2G6V1 K2G6V4 K2G6V5 K2G6V6 K2G6V7 K2G6V8 K2G6V9
K2G6W1 K2G6W2 K2G6W5 K2G6W6 K2G6W8 K2G6W9 K2G6X1 K2G6X2 K2G6X3 K2G6X4
K2G6X5 K2G6X6 K2G6X7 K2G6X8 K2G6X9 K2G6Y3 K2G6Y4 K2G6Y5 K2G6Y6 K2G6Y7
K2G6Y8 K2G6Z2 K2G6Z4 K2G6Z5 K2G6Z6 K2G6Z9 K2G7A1 K2G7A2 K2G7A3 K2G7A7
K2G7A8 K2G7B1 K2G7B2 K2G7B3 K2G7B4 K2G7B6 K2G7B8 K2G7B9 K2G7C2 K2G7C3
K2G7C4 K2G7C5 K2G7C8 K2G7C9 K2G7E2 K2G7E4 K2G7E7 K2G7E8 K2G7G1 K2G7G3
K2J0A1 K2J0A4 K2J0A5 K2J0B1 K2J0B5 K2J0B6 K2J0B9 K2J0C1 K2J0E6 K2J0E9
K2J0H1 K2J0H5 K2J0H8 K2J1A2 K2J1A9 K2J1B2 K2J1C1 K2J1C6 K2J1C8 K2J1E2
K2J1E9 K2J1G1 K2J1G5 K2J1G8 K2J1H2 K2J1H7 K2J1J3 K2J1J4 K2J1J5 K2J1J6
K2J1J7 K2J1J8 K2J1K6 K2J1K7 K2J1K8 K2J1K9 K2J1L1 K2J1L3 K2J1L4 K2J1L5
K2J1L7 K2J1L8 K2J1M2 K2J1M8 K2J1M9 K2J1N1 K2J1N3 K2J1N9 K2J1P3 K2J1P7
K2J1P8 K2J1R6 K2J1R9 K2J1S2 K2J1S7 K2J1S8 K2J1S9 K2J1T1 K2J1T8 K2J1T9
K2J1V1 K2J1V2 K2J1V5 K2J1V6 K2J1V8 K2J1V9 K2J1X2 K2J1X4 K2J1X6 K2J1Y6
K2J1Z2 K2J1Z5 K2J1Z6 K2J2A2 K2J2A3 K2J2A5 K2J2A6 K2J2B1 K2J2B2 K2J2B4
K2J2C2 K2J2C3 K2J2C4 K2J2C6 K2J2C8 K2J2E3 K2J2E5 K2J2E7 K2J2E9 K2J2G6
K2J2H2 K2J2H3 K2J2H5 K2J2H9 K2J2J1 K2J2J2 K2J2J6 K2J2J9 K2J2K1 K2J2K4
K2J2K8 K2J2L2 K2J2L3 K2J2L4 K2J2L5 K2J2L6 K2J2L8 K2J2L9 K2J2M7 K2J2N7
K2J2N9 K2J2P1 K2J2P4 K2J2P6 K2J2P7 K2J2P9 K2J2R1 K2J2R2 K2J2R3 K2J2R6
K2J2S5 K2J2T6 K2J2T7 K2J2V7 K2J2V9 K2J2W1 K2J2X3 K2J2X4 K2J2X6 K2J2X8
K2J2X9 K2J2Y1 K2J2Y4 K2J2Y9 K2J2Z1 K2J2Z3 K2J2Z4 K2J2Z6 K2J2Z8 K2J3A1
K2J3A2 K2J3A3 K2J3A6 K2J3A7 K2J3B5 K2J3B6 K2J3B7 K2J3C2 K2J3C3 K2J3C5
K2J3C9 K2J3E5 K2J3E8 K2J3G2 K2J3G9 K2J3H8 K2J3J2 K2J3J3 K2J3K4 K2J3K9
K2J3L3 K2J3L8 K2J3L9 K2J3M1 K2J3M8 K2J3N1 K2J3N2 K2J3N4 K2J3N5 K2J3N7
K2J3N8 K2J3N9 K2J3P2 K2J3P3 K2J3P7 K2J3R3 K2J3R4 K2J3R5 K2J3R6 K2J3S1
K2J3V7 K2J3V9 K2J3W1 K2J3W5 K2J3W6 K2J3X6 K2J3X7 K2J3X9 K2J3Y3 K2J3Y4
K2J3Y7 K2J3Y8 K2J3Y9 K2J3Z1 K2J3Z2 K2J3Z3 K2J3Z5 K2J3Z7 K2J3Z8 K2J3Z9
K2J4A1 K2J4A4 K2J4A5 K2J4A6 K2J4B0 K2J4B2 K2J4B3 K2J4B4 K2J4B6 K2J4B9
K2J4C1 K2J4C3 K2J4C4 K2J4C6 K2J4C7 K2J4E2 K2J4E3 K2J4E5 K2J4E6 K2J4E7
K2J4E8 K2J4E9 K2J4G3 K2J4G6 K2J4J1 K2J4K5 K2J4K6 K2J4K7 K2J4K8 K2J4L3
K2J4L4 K2J4L5 K2J4L7 K2J4L8 K2J4L9 K2J4M2 K2J4M3 K2J4M4 K2J4M5 K2J4M8
K2J4M9 K2J4N1 K2J4N4 K2J4N5 K2J4N6 K2J4N7 K2J4N8 K2J4N9 K2J4P1 K2J4P2
K2J4P3 K2J4P4 K2J4P6 K2J4P7 K2J4R2 K2J4R3 K2J4R4 K2J4R5 K2J4R6 K2J4R7
K2J4T3 K2J4T5 K2J4T6 K2J4T8 K2J4T9 K2J4V1 K2J4V2 K2J4V3 K2J4V4 K2J4V6
K2J4V7 K2J4V9 K2J4W4 K2J4W5 K2J4W6 K2J4W7 K2J4W8 K2J4X2 K2J4X8 K2J4X9
K2J4Y1 K2J4Y3 K2J4Y4 K2J4Y7 K2J4Y8 K2J4Y9 K2J4Z1 K2J4Z2 K2J4Z3 K2J4Z4
K2J4Z7 K2J4Z8 K2J4Z9 K2J5A1 K2J5A4 K2J5A7 K2J5A8 K2J5B2 K2J5B3 K2J5B4
K2J5B5 K2J5B6 K2J5B7 K2J5B8 K2J5B9 K2J5C2 K2J5C4 K2J5C6 K2J5E1 K2J5E3
K2J5E4 K2J5E5 K2J5E7 K2J5E9 K2J5G2 K2J5G6 K2J5G7 K2J5G8 K2J5H1 K2J5H2
K2J5H3 K2J5H5 K2J5H6 K2J5H8 K2J5H9 K2J5J3 K2J5J6 K2J5J7 K2J5J9 K2J5K1
K2J5L3 K2J5L4 K2J5L5 K2J5L6 K2J5L7 K2J5L8 K2J5M1 K2J5M2 K2J5M3 K2J5M6
K2J5M7 K2J5M8 K2J5N2 K2J5N3 K2J5N4 K2J5N6 K2J5N7 K2J5N8 K2J5N9 K2J5P1
K2J5P2 K2J5P3 K2J6C4 K2J7B6 K2R1A9 K2R1B3 K2R1C2 K2R1C9 K2R1E1 K2R1G7
K2R1H4 K2H1A4 K2H1B4 K2H1B9 K2H1C3 K2H1C7 K2H1E1 K2H1E2 K2H1E4 K2H1E9
K2H1G0 K2H1G2 K2H1G3 K2H1G5 K2H1G6 K2H1G7 K2H1G8 K2H1G9 K2H1H1 K2H4G6
K2H5A1 K2H5A6 K2H5A8 K2H5B7 K2H5B8 K2H5C6 K2H5E3 K2H5E8 K2H5G6 K2H5G8
K2H5J1 K2H5J2 K2H5J9 K2H5L2 K2H5L5 K2H5L6 K2H5M1 K2H5M3 K2H5M4 K2H5N7
K2H5P3 K2H5P4 K2H5P7 K2H5R3 K2H5R4 K2H5S1 K2H5S2 K2H5S6 K2H5T3 K2H5T7
K2H5V5 K2H5V7 K2H5V9 K2H5W2 K2H5W5 K2H5W6 K2H5W7 K2H5X1 K2H5X2 K2H5Y1
K2H6A4 K2H6B1 K2H6C5 K2H6C8 K2H6G3 K2H6G5 K2H6G7 K2H6H1 K2H6H7 K2H6J1
K2H6K3 K2H6K4 K2H6N2 K2H6N4 K2H6P1 K2H6P4 K2H6R3 K2H6R9 K2H6S6 K2H6T3
K2H6V3 K2H6V6 K2H6V7 K2H6V9 K2H6W1 K2H6W3 K2H6Y2 K2H6Y6 K2H6Y9 K2H6Z1
K2H6Z8 K2H6Z9 K2H7A8 K2H7A9 K2H7B1 K2H7B4 K2H7B5 K2H7B8 K2H7B9 K2H7C1
K2H7C2 K2H7C3 K2H7C5 K2H7C7 K2H7C8 K2H7E5 K2H7E6 K2H7G2 K2H7G3 K2H7G4
K2H7G6 K2H7G7 K2H7G8 K2H7H5 K2H7H6 K2H7J1 K2H7J5 K2H7J9 K2H7K1 K2H7K5
K2H7K8 K2H7K9 K2H7L1 K2H7L2 K2H7L5 K2H7L9 K2H7M2 K2H7M7 K2H7M9 K2H7N6
K2H7N9 K2H7P2 K2H7S9 K2H7T8 K2H7V1 K2H7W5 K2H7W7 K2H7W9 K2H7X2 K2H7X5
K2H7X9 K2H7Y8 K2H7Y9 K2H7Z1 K2H8A5 K2H8A9 K2H8B3 K2H8B8 K2H8B9 K2H8C8
K2H8E1 K2H8E9 K2H8G1 K2H8G7 K2H8H1 K2H8J1 K2H8J2 K2H8J6 K2H8J7 K2H8K2
K2H8K9 K2H8L7 K2H8M2 K2H8M6 K2H8N4 K2H8N7 K2H8N9 K2H8P6 K2H8P8 K2H8R2
K2H8R6 K2H8R8 K2H8R9 K2H8S1 K2H8S2 K2H8S3 K2H8S4 K2H8S6 K2H8S7 K2H8S8
K2H8S9 K2H8T3 K2H8T4 K2H8T6 K2H8T7 K2H8T8 K2H8T9 K2H8V3 K2H8V7 K2H8W6
K2H8W7 K2H8W8 K2H8X4 K2H8X5 K2H8X7 K2H8X8 K2H8X9 K2H8Y1 K2H8Y2 K2H8Y3
K2H8Y4 K2H8Y8 K2H8Y9 K2H9A9 K2H9B6 K2H9C4 K2H9C5 K2H9C6 K2H9C9 K2H9E7
K2H9G1 K2H9G8 K2H9H1 K2H9H4 K2H9K1 K2H9K5 K2H9K8 K2H9K9 K2H9L9 K2H9N1
K2H9N5 K2H9N6 K2H9P2 K2H9P3 K2H9P5 K2H9P9 K2H9R1 K2H9R2 K2H9R3 K2H9R4
K2H9R5 "






On Fri, May 31, 2013 at 7:21 AM,  <arir03@uqo.ca> wrote:
> Hi,
>
> I would like to know if it is possible to assign more than one value to a Stata variable under the same condition. Here is my problem:
>
> In my dataset, I have a variable called “economic_region”. I would like to:
>
> 1) assign sub-regions to each of these economic regions
> 2) assign Postal Codes (PC) or Forward Sortation Area (FSA: the first three characters of the PC) to each of these sub-regions (in order to be able to do a "many to one" match later).
>
> In other words, I would like to disaggregate these economic regions. Note that I know the list of the sub-regions for a given economic region and I also know the list of the FSA for a given sub-region, but this information is not in my dataset and I would like to include it. If I had the reverse problem (aggregation), it would be easy for me to solve. For ex, suppose that I wanted to create the economic region named Ottawa from three sub-regions: Nepean, Kanata, Rockland, it wouldbe:
>
> gen str10 economic_region = ”Ottawa” if sub_region == “Nepean” | sub_region == “Kanata” | sub_region == “Rockland”
>
> But, I want to disaggregate instead. I have the economic region named Ottawa and I want to create three sub-regions from it: Nepean, Kanata, Rockland. I thought I could do that by assigning multiple values to the variable called sub-region. I know how to assign more than one value to a Stata variable under different conditions, but I don’t know how to assign more than one value to a Stata variable under the same condition (or if this is even possible!).  Can you tell me if it is possible to do that in Stata and how? I would appreciate your help on this matter.
>
> Best,
> Ruolz.
> *
> *   For searches and help try:
> *   http://www.stata.com/help.cgi?search
> *   http://www.stata.com/support/faqs/resources/statalist-faq/
> *   http://www.ats.ucla.edu/stat/stata/

*
*   For searches and help try:
*   http://www.stata.com/help.cgi?search
*   http://www.stata.com/support/faqs/resources/statalist-faq/
*   http://www.ats.ucla.edu/stat/stata/