Suppose you have data on year of birth, but you want to group several years together, e.g. group 1950, 1951 and 1952 births together; 1953, 1954, and 1955 together, etc.<\/p>\n
Below is some JavaScript code I wrote to generate the relevant Stata commands without much fuss. You only have to make minor adjustments: Enter the start year (e.g. 1950), the end year (e.g. 1955), and the interval length (e.g. 3 years).<\/p>\n
[sourcecode language=”javascript”]
\n<html><body><script>
\n\/\/*** Generate Stata Code to replace cohort groups *****
\n\/\/*** Enda Hargaden, Summer 2010
\n\/\/*** Just replace the following three variables and refresh the page<\/p>\n
var start_year = 1881;
\nvar end_year = 1990;
\nvar interval = 5;<\/p>\n
\/\/*** You’re done. Or at least you should be.<\/p>\n
var c;
\nvar a;
\nvar backup1 = start_year;
\nvar backup2 = end_year;
\na = end_year – start_year;
\na = a\/interval;
\na = Math.ceil(a);
\na=a+1;<\/p>\n
document.write("gen cohort_group = 0 <br \/>");
\nfor(i=1;i<a;i++)
\n{
\nc=start_year+interval;
\n document.write("replace cohort_group = " + i + " if cohort > " + (start_year-1) + " & cohort < " + c + "<br \/>");<\/p>\n
start_year = start_year+interval;<\/p>\n
}<\/p>\n
start_year = backup1;
\nend_year = backup2<\/p>\n
document.write("<br \/>recode cohort_group ");
\ndocument.write("( 0 = 0 \\"Other\\" ) \/\/\/<br \/>");
\nfor(j=1;j<a;j++)
\n{<\/p>\n
\tif(j<(a-1))
\n\t{
\n\tc=start_year+interval-1;
\n\tdocument.write("( " + j + " = " + j + " \\"" + (start_year) + " – " + c + "\\" ) \/\/\/<br \/>");
\n\tstart_year=start_year+interval;
\n\t}
\n\tif(j==a-1)
\n\t{
\n\tc=start_year+interval-1;
\n\tdocument.write("( " + j + " = " + j + " \\"" + (start_year) + " – " + c + "\\" ), gen(cohort_clean)<br \/>la var cohort_clean \\"Birth Cohort\\"<br \/>");
\n\tstart_year=start_year+interval;
\n\t}
\n}
\n<\/script><\/body><\/html>
\n[\/sourcecode]<\/p>\n
I wrote this with a five-year interval in mind so I cannot guarantee you won’t run into an integer problem with the last entry, etc. However, it should get you most of the way there.\u00a0Enjoy!<\/p>\n","protected":false},"excerpt":{"rendered":"
Suppose you have data on year of birth, but you want to group several years together, e.g. group 1950, 1951 and 1952 births together; 1953, 1954, and 1955 together, etc. Below is some JavaScript code…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-794","post","type-post","status-publish","format-standard","hentry","category-stata"],"_links":{"self":[{"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/posts\/794","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/comments?post=794"}],"version-history":[{"count":0,"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/posts\/794\/revisions"}],"wp:attachment":[{"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/media?parent=794"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/categories?post=794"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hargaden.com\/enda\/wp-json\/wp\/v2\/tags?post=794"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}