Hello People,
I am trying to plot unconditional probabilities cohort wise. I have two variables mother and child with 5 cohorts. I want to plot upward mobility and downward mobility (unconditional probability) over cohorts. Just for the sake of example upward will be if child > mother (which is education years) downward will be if mother > child. So these two trends should be shown in the plot on ax-axis i will have 5 cohorts. I have already omitted few if mother education is maximum possible or minimum because in that case upward or downward probability is zero. here is the example data for 3 cohorts. I will be grateful if you can tell me how to perform this task.
I am trying to plot unconditional probabilities cohort wise. I have two variables mother and child with 5 cohorts. I want to plot upward mobility and downward mobility (unconditional probability) over cohorts. Just for the sake of example upward will be if child > mother (which is education years) downward will be if mother > child. So these two trends should be shown in the plot on ax-axis i will have 5 cohorts. I have already omitted few if mother education is maximum possible or minimum because in that case upward or downward probability is zero. here is the example data for 3 cohorts. I will be grateful if you can tell me how to perform this task.
Code:
input str9 hhid str10 pidlink float(mother child child_birth cohort) "320611407" "114070001" 6 16 1928 1 "1740100" "174010003" 6 9 1928 1 "1871300" "187130001" 6 6 1928 1 "3081500" "308150002" 6 6 1928 1 "1660700" "166070001" 6 6 1928 1 "1141000" "114100002" 6 6 1928 1 "0292300" "029230001" 6 12 1928 1 "1521200" "152120001" 12 12 1928 1 "0311900" "031190001" 12 9 1928 1 "1182100" "118210001" 6 9 1928 1 "317409620" "096200005" 6 6 1928 1 "1962531" "196250001" 6 9 1928 1 "337319204" "192040001" 6 12 1928 1 "2932000" "293200001" 6 6 1928 1 "2371800" "237180001" 6 6 1928 1 "1041200" "104120001" 6 6 1928 1 "1111800" "111180001" 6 6 1928 1 "1182100" "118210001" 6 6 1928 1 "0764200" "076420002" 6 6 1928 1 "1102800" "110280002" 6 6 1928 1 "2481200" "248120002" 6 6 1928 1 "0490700" "049070005" 6 6 1928 1 "2150200" "215020001" 6 16 1928 1 "1360500" "136050001" 6 6 1928 1 "187106515" "065150001" 6 6 1928 1 "180306203" "062030001" 6 6 1928 1 "1150400" "115040001" 6 6 1928 1 "2130500" "213050001" 6 6 1928 1 "320811519" "115190002" 6 6 1928 1 "0361011" "036100001" 6 6 1928 1 "2141700" "214170001" 12 12 1928 1 "120400413" "004130001" 6 12 1928 1 "2220300" "222030001" 6 6 1928 1 "0152000" "015200002" 6 12 1928 1 "1870900" "187090001" 6 6 1928 1 "1452700" "145270001" 9 6 1928 1 "127201807" "018070002" 9 9 1928 1 "1842531" "184250001" 6 6 1928 1 "2620700" "262070001" 6 6 1928 1 "1701400" "170140005" 6 16 1928 1 "160304515" "045150001" 6 6 1928 1 "1910200" "191020001" 6 6 1928 1 "2701100" "270110002" 6 16 1928 1 "1531600" "153160001" 6 9 1928 1 "0911100" "091110001" 6 6 1928 1 "0380500" "038050001" 9 12 1928 1 "1182100" "118210002" 6 6 1928 1 "0521000" "052100001" 6 16 1928 1 "1291600" "129160006" 9 9 1928 1 "1100300" "110030010" 6 6 1928 1 "0301000" "030100001" 6 9 1929 1 "1991300" "199130001" 12 9 1929 1 "327114703" "147030001" 6 6 1929 1 "1211300" "121130001" 6 6 1929 1 "2151000" "215100001" 6 9 1929 1 "0140900" "014090001" 6 9 1929 1 "0612900" "061290002" 6 6 1929 1 "1981100" "198110002" 9 6 1929 1 "321112407" "124070001" 6 6 1929 1 "1992000" "199200002" 6 6 1929 1 "0422700" "042270002" 6 6 1929 1 "1470600" "147060002" 9 12 1929 1 "0774100" "077410002" 6 12 1929 1 "3081800" "308180001" 6 9 1929 1 "1942000" "194200001" 9 12 1929 1 "0211500" "021150002" 6 6 1929 1 "1541100" "154110002" 12 12 1929 1 "3031100" "303110009" 6 6 1929 1 "1521200" "152120001" 12 12 1929 1 "1662200" "166220001" 6 6 1929 1 "0622100" "062210001" 6 9 1929 1 "0621700" "062170001" 6 6 1929 1 "2231900" "223190001" 9 9 1929 1 "0490400" "049040002" 6 6 1929 1 "2551000" "255100001" 6 9 1929 1 "2810200" "281020001" 9 6 1929 1 "0070400" "007040001" 6 9 1929 1 "1231400" "123140001" 6 6 1929 1 "2241600" "224160001" 6 6 1929 1 "1841831" "184180001" 6 6 1929 1 "187106520" "065200001" 6 9 1929 1 "630229401" "294010001" 6 6 1929 1 "127602606" "026060001" 6 6 1929 1 "0610300" "061030001" 6 6 1929 1 "0651600" "065160001" 9 12 1929 1 "1820300" "182030001" 6 6 1929 1 "1240300" "124030001" 6 6 1929 1 "3212500" "321250001" 6 12 1930 1 "0622100" "062210002" 6 6 1930 1 "317308319" "083190005" 6 6 1930 1 "1150400" "115040001" 6 12 1930 1 "0181700" "018170007" 6 6 1930 1 "0380500" "038050002" 6 6 1930 1 "737132113" "321130001" 6 6 1930 1 "1940200" "194020001" 6 12 1930 1 "1610900" "161090001" 6 6 1930 1 "1531500" "153150002" 6 12 1930 1 "2350611" "235061101" 6 6 1930 1 "0162000" "016200001" 6 6 1930 1 "1601300" "160130001" 9 16 1930 1 "2422500" "242250005" 6 6 1934 2 "0751600" "075160001" 6 12 1934 2 "2634111" "263410004" 6 6 1934 2 "2341500" "234150001" 6 9 1934 2 "0461000" "046100001" 6 12 1934 2 "0292900" "029290009" 9 12 1934 2 "0361600" "036160001" 6 9 1934 2 "0623000" "062300001" 6 6 1934 2 "2580200" "258020001" 12 9 1934 2 "737132113" "321130001" 6 6 1934 2 "1671700" "167170001" 6 6 1934 2 "0380900" "038090001" 9 9 1934 2 "0360100" "036010004" 6 6 1934 2 "0751800" "075180001" 12 12 1934 2 "0541600" "054160001" 9 16 1934 2 "1102800" "110280002" 6 6 1934 2 "1891200" "189120002" 6 6 1934 2 "2414100" "241410001" 6 6 1934 2 "1150300" "115030001" 6 6 1934 2 "1161400" "116140003" 6 6 1934 2 "630229401" "294010001" 6 6 1934 2 "120700703" "007030001" 6 6 1934 2 "1713000" "171300002" 6 9 1934 2 "0490700" "049070005" 6 6 1934 2 "1841800" "184180001" 6 6 1934 2 "1121000" "112100001" 6 12 1934 2 "317409620" "096200005" 6 9 1934 2 "0831300" "083130001" 6 6 1934 2 "1531600" "153160001" 6 16 1934 2 "2780300" "278030001" 6 6 1934 2 "2991031" "299100001" 6 6 1934 2 "1810400" "181040002" 6 6 1934 2 "0333011" "033300001" 6 9 1934 2 "1161700" "116170001" 6 6 1934 2 "0072800" "007280001" 6 6 1934 2 "0750600" "075060002" 6 6 1934 2 "2412241" "241220001" 6 6 1934 2 "2242500" "224250001" 6 9 1934 2 "0090500" "009050001" 6 6 1934 2 "1321300" "132130001" 6 6 1934 2 "2971000" "297100001" 6 6 1935 2 "137103406" "034060006" 6 6 1935 2 "1241900" "124190001" 6 6 1935 2 "0281000" "028100002" 6 6 1935 2 "2150200" "215020001" 6 16 1935 2 "2831111" "283110001" 6 6 1935 2 "2430200" "243020002" 6 9 1935 2 "1031400" "103140001" 9 16 1935 2 "2381600" "238160001" 6 12 1935 2 "1810200" "181020001" 6 6 1935 2 "2441100" "244110005" 6 16 1935 2 "2011300" "201130002" 9 16 1935 2 "317308113" "081130008" 9 9 1935 2 "1521100" "152110002" 6 6 1935 2 "322014416" "144160001" 6 6 1935 2 "2531300" "253130003" 6 6 1935 2 "127502305" "023050002" 6 6 1935 2 "1581100" "158110002" 6 6 1935 2 "1641800" "164180001" 6 6 1935 2 "1081900" "108190001" 12 6 1935 2 "0260400" "026040001" 9 9 1935 2 "2632600" "263260002" 6 6 1935 2 "1830400" "183040001" 6 6 1935 2 "0462000" "046200001" 6 6 1935 2 "2990800" "299080001" 6 9 1935 2 "2990800" "299080001" 6 6 1935 2 "0761900" "076190001" 6 6 1935 2 "2351900" "235190002" 6 6 1935 2 "1332511" "133251102" 6 6 1935 2 "1152200" "115220004" 6 6 1935 2 "0701600" "070160001" 6 6 1935 2 "0140900" "014090001" 6 12 1935 2 "1751700" "175170001" 6 6 1935 2 "1350500" "135050001" 6 6 1935 2 "0284200" "028420001" 6 6 1935 2 "347121713" "217130001" 6 16 1935 2 "2041000" "204100002" 6 6 1935 2 "2411800" "241180001" 6 6 1935 2 "0500900" "050090002" 9 12 1935 2 "0520800" "052080002" 9 12 1935 2 "0280400" "028040001" 6 6 1935 2 "167205519" "055190001" 6 6 1935 2 "0811300" "081130002" 9 12 1935 2 "1560700" "156070001" 6 16 1935 2 "2940600" "294060005" 6 6 1935 2 "0292400" "029240002" 6 12 1935 2 "2050900" "205090002" 6 6 1935 2 "2960900" "296090001" 6 6 1935 2 "2170200" "217020001" 6 6 1935 2 "1470500" "147050001" 6 12 1935 2 "0751600" "075160001" 6 6 1935 2 "130603202" "032020001" 6 6 1935 2 "0490500" "049050001" 6 6 1935 2 "1141000" "114100001" 6 6 1935 2 "0801200" "080120001" 12 16 1935 2 "1381900" "138190002" 6 6 1935 2 "1911200" "191120002" 12 16 1935 2 "0292500" "029250001" 6 6 1935 2 "0100300" "010030001" 6 6 1935 2 "180105701" "057010001" 6 6 1935 2 "0450600" "045060002" 6 12 1940 3 "2041000" "204100002" 6 6 1940 3 "2940600" "294060005" 6 6 1940 3 "0881900" "088190001" 9 16 1940 3 "0670200" "067020002" 6 6 1940 3 "3210200" "321020001" 6 16 1940 3 "0460500" "046050002" 6 9 1940 3 "0040600" "004060002" 6 9 1940 3 "0880300" "088030002" 6 6 1940 3 "0541700" "054170002" 6 16 1940 3 "1990311" "199031103" 6 6 1940 3 "317107044" "070440001" 9 9 1940 3 "1842031" "184203102" 6 6 1940 3 "0751900" "075190001" 9 16 1940 3 "2781200" "278120001" 6 12 1940 3 "2191800" "219180005" 6 9 1940 3 "0432600" "043260002" 6 6 1940 3 "2021000" "202100001" 9 12 1940 3 "2561900" "256190004" 6 9 1940 3 "2031800" "203180001" 6 16 1940 3 "0621500" "062150004" 6 12 1940 3 "1672300" "167230001" 6 6 1940 3 "0441500" "044150001" 6 6 1940 3 "0981800" "098180001" 6 9 1940 3 "0700200" "070020001" 6 12 1940 3 "1110100" "111010005" 12 12 1940 3 "0491200" "049120001" 6 9 1940 3 "0971500" "097150001" 6 9 1940 3 "3152800" "315280002" 6 9 1940 3 "0601400" "060140001" 6 6 1940 3 "0541700" "054170002" 6 6 1940 3 "0432200" "043220001" 6 6 1940 3 "2611400" "261140005" 6 9 1940 3 "1004400" "100440001" 6 6 1940 3 "1980200" "198020001" 6 16 1940 3 "2240800" "224080001" 6 6 1940 3 "0540700" "054070001" 6 12 1940 3 "1061600" "106160002" 6 12 1940 3 "2190500" "219050001" 6 6 1940 3 "0461500" "046150001" 9 16 1940 3 "2601300" "260130001" 6 9 1940 3 "0801100" "080110001" 12 16 1940 3 "1250200" "125020001" 6 6 1940 3 "1071300" "107130002" 6 6 1940 3 "1150300" "115030001" 6 6 1940 3 "317106906" "069060001" 12 16 1940 3 "0201000" "020100001" 6 12 1940 3 "0700300" "070030001" 6 12 1940 3 "1611000" "161100007" 6 9 1940 3 "0090200" "009020002" 6 6 1940 3 "2100900" "210090003" 9 16 1940 3 "0770200" "077020001" 9 9 1940 3 "1240300" "124030002" 6 6 1940 3 "0333011" "033300001" 6 6 1940 3 "0881300" "088130001" 6 6 1940 3 "1960300" "196030002" 6 6 1940 3 "0780500" "078050001" 6 9 1940 3 "1580900" "158090001" 9 16 1940 3 "1320900" "132090001" 6 12 1940 3 "2010900" "201090001" 9 12 1940 3 "0670900" "067090002" 12 12 1940 3 "0151600" "015160002" 12 12 1940 3 "1802200" "180220001" 6 6 1940 3 "2581600" "258160001" 6 6 1940 3 "2801000" "280100005" 6 16 1940 3 "1780131" "178010001" 6 6 1940 3 "0701000" "070100002" 6 9 1940 3 "0390400" "039040001" 6 12 1940 3 "1280700" "128070001" 6 12 1940 3 "2610500" "261050002" 6 6 1940 3 "2361331" "236130001" 6 16 1940 3 "0714200" "071420002" 6 6 1940 3 "0810612" "081060007" 6 6 1940 3 "1800600" "180060002" 6 9 1940 3 "2831111" "283110001" 6 6 1940 3 "1610900" "161090001" 6 6 1940 3 "1131900" "113190002" 6 12 1940 3 "0831500" "083150001" 12 12 1940 3 "1140300" "114030001" 9 16 1940 3 "0900200" "090020002" 9 12 1940 3 "1860631" "186063102" 6 6 1940 3 "1911200" "191120002" 12 16 1940 3 "0680500" "068050001" 6 9 1940 3 "2291400" "229140002" 6 6 1940 3 "0110400" "011040001" 12 6 1940 3 "1851700" "185170006" 6 6 1940 3 "1901200" "190120001" 6 6 1940 3 "0422800" "042280002" 6 6 1940 3 "0150100" "015010002" 6 16 1940 3 "1332700" "133270001" 6 6 1940 3 "0791200" "079120002" 6 9 1940 3 "0861200" "086120002" 9 16 1940 3 "0801100" "080110003" 12 16 1940 3 "3070800" "307080001" 6 6 1940 3 "167105211" "052110002" 9 12 1940 3 "737132113" "321130001" 6 9 1940 3 "2050800" "205080001" 6 6 1940 3 "2430100" "243010001" 6 9 1940 3 "1070700" "107070001" 6 6 1940 3 "2320600" "232060002" 6 6 1940 3 end
