data list file ='Z:\public_html\hist5011\ruggl216.dat'/ year 1- 2 gq 3- 3 relateg 4- 5 age 6- 8 sex 9- 9 raceg 10- 10 marst 11- 11 higradeg 12- 13 educ99 14- 15 empstatg 16- 16 occ1950 17- 19 occscore 20- 21 incwage 22- 27 . variable label year 'Census year'. variable label gq 'Group quarters status'. variable label relateg 'Relationship to household head -- General'. variable label age 'Age'. variable label sex 'Sex'. variable label raceg 'Race -- General'. variable label marst 'Marital status'. variable label higradeg 'Highest grade of schooling -- General'. variable label educ99 'Educational attainment, 1990'. variable label empstatg 'Employment status -- General'. variable label occ1950 'Occupation, 1950 basis'. variable label occscore 'Occupational income score'. variable label incwage 'Wage and salary income'. value labels year 00 '2000' 85 '1850' 86 '1860' 87 '1870' 88 '1880' 90 '1900' 91 '1910' 92 '1920' 94 '1940' 95 '1950' 96 '1960' 97 '1970' 98 '1980' 99 '1990' . value labels gq 0 'Vacant unit' 1 'Households under 1970 definition' 2 'Additional households under 1990 definition' 3 'Group quarters--Institutions' 4 'Other group quarters' 5 'Additional households under 2000 definition' 6 'Fragment' . value labels relateg 01 'Head/Householder' 02 'Spouse' 03 'Child' 04 'Child-in-law' 05 'Parent' 06 'Parent-in-Law' 07 'Sibling' 08 'Sibling-in-Law' 09 'Grandchild' 10 'Other relatives' 11 'Partner, friend, visitor' 12 'Other non-relatives' 13 'Institutional inmates' . value labels age . value labels sex 1 'Male' 2 'Female' . value labels raceg 1 'White' 2 'Black/Negro' 3 'American Indian' 4 'Chinese' 5 'Japanese' 6 'Other Asian or Pacific Islander' 7 'Other race, nec' 8 'Two or more major races' . value labels marst 1 'Married, spouse present' 2 'Married, spouse absent' 3 'Separated' 4 'Divorced' 5 'Widowed' 6 'Never married/single (N/A)' . value labels higradeg 0 'N/A (or None, 1980)' 1 'None' 2 'Nursery school' 3 'Kindergarten' 4 '1st grade' 5 '2nd grade' 6 '3rd grade' 7 '4th grade' 8 '5th grade' 9 '6th grade' 10 '7th grade' 11 '8th grade' 12 '9th grade' 13 '10th grade' 14 '11th grade' 15 '12th grade' 16 '1st year' 17 '2nd year' 18 '3rd year' 19 '4th year' 20 '5th year or more (40-50)' 21 '6th year or more (60,70)' 22 '7th year' 23 '8th year or more' . value labels educ99 00 'Not applicable' 01 'No school completed' 02 'Nursery school' 03 'Kindergarten' 04 '1st-4th grade' 05 '5th-8th grade' 06 '9th grade' 07 '10th grade' 08 '11th grade' 09 '12th grade, no diploma' 10 'High school graduate, or GED' 11 'Some college, no degree' 12 'Associate degree, occupational program' 13 'Associate degree, academic program' 14 'Bachelors degree' 15 'Masters degree' 16 'Professional degree' 17 'Doctorate degree' . value labels empstatg 0 'N/A' 1 'Employed' 2 'Unemployed' 3 'Not in labor force' . value labels occ1950 0 'Accountants and auditors' 1 'Actors and actresses' 2 'Airplane pilots and navigators' 3 'Architects' 4 'Artists and art teachers' 5 'Athletes' 6 'Authors' 7 'Chemists' 8 'Chiropractors' 9 'Clergymen' 10 'College presidents and deans' 12 'Aricultural sciences-Professors and instructors' 13 'Biological sciences-Professors and instructors' 14 'Chemistry-Professors and instructors' 15 'Economics-Professors and instructors' 16 'Engineering-Professors and instructors' 17 'Geology and geophysics-Professors and instructors' 18 'Mathematics-Professors and instructors' 19 'Medical Sciences-Professors and instructors' 23 'Physics-Professors and instructors' 24 'Psychology-Professors and instructors' 25 'Statistics-Professors and instructors' 26 'Natural science (nec)-Professors and instructors' 27 'Social sciences (nec)-Professors and instructors' 28 'Nonscientific subjects-Professors and instructors' 29 'Subject not specified-Professors and instructors' 31 'Dancers and dancing teachers' 32 'Dentists' 33 'Designers' 34 'Dieticians and nutritionists' 35 'Draftsmen' 36 'Editors and reporters' 41 'Aeronautical-Engineers' 42 'Chemical-Engineers' 43 'Civil-Engineers' 44 'Electrical-Engineers' 45 'Industrial-Engineers' 46 'Mechanical-Engineers' 47 'Metallurgical, metallurgists-Engineers' 48 'Mining-Engineers' 49 'Engineers (nec)' 51 'Entertainers (nec)' 52 'Farm and home management advisors' 53 'Foresters and conservationists' 54 'Funeral directors and embalmers' 55 'Lawyers and judges' 56 'Librarians' 57 'Musicians and music teachers' 58 'Nurses, professional' 59 'Nurses, student professional' 61 'Agricultural scientists' 62 'Biological scientists' 63 'Geologists and geophysicists' 67 'Mathematicians' 68 'Physicists' 69 'Misc. natural scientists' 70 'Optometrists' 71 'Osteopaths' 72 'Personnel and labor relations workers' 73 'Pharmacists' 74 'Photographers' 75 'Physicians and surgeons' 76 'Radio operators' 77 'Recreation and group workers' 78 'Religious workers' 79 'Social and welfare workers, except group' 81 'Economists' 82 'Psychologists' 83 'Statisticians and actuaries' 84 'Misc social scientists' 91 'Sports instructors and officials' 92 'Surveyors' 93 'Teachers (n.e.c.)' 94 'Medical and dental-technicians' 95 'Testing-technicians' 96 'Technicians (nec)' 97 'Therapists and healers (nec)' 98 'Veterinarians' 99 'Professional, technical & kindred workers (nec)' 100 'Farmers (owners and tenants)' 123 'Farm managers' 200 'Buyers and dept heads, store' 201 'Buyers and shippers, farm products' 203 'Conductors, railroad' 204 'Credit men' 205 'Floormen and floor managers, store' 210 'Inspectors, public administration' 230 'Managers & superintendants, building' 240 'Officers, pilots, pursers and engineers, ship' 250 'Officials & administratators (nec), public administration' 260 'Officials, lodge, society, union, etc.' 270 'Postmasters' 280 'Purchasing agents and buyers (nec)' 290 'Managers, officials, and proprietors (nec)' 300 'Agents (nec)' 301 'Attendants and assistants, library' 302 'Attendants, physicians and dentists office' 304 'Baggagemen, transportation' 305 'Bank tellers' 310 'Bookkeepers' 320 'Cashiers' 321 'Collectors, bill and account' 322 'Dispatchers and starters, vehicle' 325 'Express messengers and railway mail clerks' 335 'Mail carriers' 340 'Messengers and office boys' 341 'Office machine operators' 342 'Shipping and receiving clerks' 350 'Stenographers, typists, and secretaries' 360 'Telegraph messengers' 365 'Telegraph operators' 370 'Telephone operators' 380 'Ticket, station, and express agents' 390 'Clerical and kindred workers (n.e.c.)' 400 'Advertising agents and salesmen' 410 'Auctioneers' 420 'Demonstrators' 430 'Hucksters and peddlers' 450 'Insurance agents and brokers' 460 'Newsboys' 470 'Real estate agents and brokers' 480 'Stock and bond salesmen' 490 'Salesmen and sales clerks (nec)' 500 'Bakers' 501 'Blacksmiths' 502 'Bookbinders' 503 'Boilermakers' 504 'Brickmasons,stonemasons, and tile setters' 505 'Cabinetmakers' 510 'Carpenters' 511 'Cement and concrete finishers' 512 'Compositors and typesetters' 513 'Cranemen,derrickmen, and hoistmen' 514 'Decorators and window dressers' 515 'Electricians' 520 'Electrotypers and stereotypers' 521 'Engravers, except engravers' 522 'Excavating, grading, and road machinery operators' 523 'Foremen (nec)' 524 'Forgemen and hammermen' 525 'Furriers' 530 'Glaziers' 531 'Heat treaters, annealers, temperers' 532 'Inspectors, scalers, and graders log and lumber' 533 'Inspectors (nec)' 534 'Jewelers, watchmakers, goldsmiths, and silversmiths' 535 'Job setters, metal' 540 'Linemen and servicemen, telegraph, telephone, & power' 541 'Locomotive engineers' 542 'Locomotive firemen' 543 'Loom fixers' 544 'Machinists' 545 'Airplane-mechanics and repairmen' 550 'Automobile-mechanics and repairmen' 551 'Office machine-mechanics and repairmen' 552 'Radio and television-mechanics and repairmen' 553 'Railroad and car shop-mechanics and repairmen' 554 'Mechanics and repairmen (nec)' 555 'Millers, grain, flour, feed, etc' 560 'Millwrights' 561 'Molders, metal' 562 'Motion picture projectionists' 563 'Opticians and lens grinders and polishers' 564 'Painters, construction and maintenance' 565 'Paperhangers' 570 'Pattern and model makers, except paper' 571 'Photoengravers & lithographers' 572 'Piano and organ tuners and repairmen' 573 'Plasterers' 574 'Plumbers and pipe fitters' 575 'Pressmen and plate printers, printing' 580 'Rollers and roll hands, metal' 581 'Roofers and slaters' 582 'Shoemakers and repairers, except factory' 583 'Stationary engineers' 584 'Stone cutters and stone carvers' 585 'Structural metal workers' 590 'Tailors and tailoresses' 591 'Tinsmiths, coppersmiths, and sheet metal workers' 592 'Tool makers, and die makers and setters' 593 'Upholsterers' 594 'Craftsmen and kindred workers (nec)' 595 'Members of the armed services' 600 'Auto mechanics apprentice' 601 'Bricklayers and masons apprentice' 602 'Carpenters apprentice' 603 'Electricians apprentice' 604 'Machinists and toolmakers apprentice' 605 'Mechanics, except auto apprentice' 610 'Plumbers and pipe fitters apprentice' 611 'Apprentices, building trades (nec)' 612 'Apprentices, metalworking trades (nec)' 613 'Apprentices, printing trades' 614 'Apprentices, other specified trades' 615 'Apprentices, trade not specified' 620 'Asbestos and insulation workers' 621 'Attendants, auto service and parking' 622 'Blasters and powdermen' 623 'Boatmen, canalmen, and lock keepers' 624 'Brakemen, railroad' 625 'Bus drivers' 630 'Chainmen, rodmen, and axmen, surveying' 631 'Conductors, bus & street railway' 632 'Deliverymen and routemen' 633 'Dressmakers and seamstresses except factory' 634 'Dyers' 635 'Filers, grinders, and polishers, metal' 640 'Fruit, nut, and vegetable graders, and packers, except facto' 641 'Furnacemen, smeltermen and pourers' 642 'Heaters, metal' 643 'Laundry and dry cleaning Operatives' 644 'Meat cutters, except slaughter and packing house' 645 'Milliners' 650 'Mine operatives and laborers' 660 'Motormen, mine, factory, logging camp, etc' 661 'Motormen, street, subway, and elevated railway' 662 'Oilers and greaser, except auto' 670 'Painters, except construction or maintenance' 671 'Photographic process workers' 672 'Power station operators' 673 'Sailors and deck hands' 674 'Sawyers' 675 'Spinners, textile' 680 'Stationary firemen' 681 'Switchmen, railroad' 682 'Taxicab drivers and chauffeurs' 683 'Truck and tractor drivers' 684 'Weavers, textile' 685 'Welders and flame cutters' 690 'Operative and kindred workers (nec)' 700 'Housekeepers, private household' 710 'Laundressses, private household' 720 'Private household workers (nec)' 730 'Attendants, hospital and other institution' 731 'Attendants, professional and personal service (nec)' 732 'Attendants, recreation and amusement' 740 'Barbers, beauticians, and manicurists' 750 'Bartenders' 751 'Bootblacks' 752 'Boarding and lodging house keepers' 753 'Charwomen and cleaners' 754 'Cooks, except private household' 760 'Counter and fountain workers' 761 'Elevator operators' 762 'Firemen, fire protection' 763 'Guards, watchmen, and doorkeepers' 764 'Housekeepers and stewards, except private household' 770 'Janitors and sextons' 771 'Marshals and constables' 772 'Midwives' 773 'Policemen and detectives' 780 'Porters' 781 'Practical nurses' 782 'Sheriffs and bailiffs' 783 'Ushers, recreation and amusement' 784 'Waiters and waitresses' 785 'Watchmen (crossing) and bridge tenders' 790 'Service workers, except private household (nec)' 810 'Farm foremen' 820 'Farm laborers, wage workers' 830 'Farm laborers, unpaid family workers' 840 'Farm service laborers, self-employed' 910 'Fishermen and oystermen' 920 'Garage laborers and car washers and greasers' 930 'Gardeners, except farm, and groundskeepers' 940 'Longshoremen and stevedores' 950 'Lumbermen, raftsmen, and woodchoppers' 960 'Teamsters' 970 'Laborers (nec)' 975 'EMPLOYED (unclassifiable)' 976 'Conductors, not specified' 977 'RR employee' 978 'Govt officials, level unknown' 980 'Keeps house/house work/housewife' 981 'Imputed keeping house (1880-1990)' 982 'At home/ helps in home' 983 'At school' 984 'Retired' 985 'Unemployed/ without occ' 986 'Invalid/sick/disabled' 987 'Inmate/prisoner' 988 'Ration Indian' 990 'Landlord' 991 'Capitalist/gentleman' 992 'Child labor-farm' 993 'Child labor-domestic' 994 'Child labor-other' 995 'Other non-occupation' 996 'Unclassifiable (employment status unk)' 997 'Occupation missing/unknown' 999 'N/A (blank)' . value labels occscore . value labels incwage . execute. weight by perwt. recode year (00=2000). if (year = 94) realwage=incwage*8.99. if (year = 97)realwage=incwage*3.39. if (year = 2000)realwage=incwage*0.71. compute recwage=trunc(realwage/1000)*1000. if (incwage = 999999)recwage=999999. missing values recwage (0, 999999). SORT CASES BY year . SPLIT FILE LAYERED BY year . freq recwage.