{"id":294,"date":"2015-06-18T15:09:24","date_gmt":"2015-06-18T19:09:24","guid":{"rendered":"http:\/\/csclub.uwaterloo.ca\/~k55chen\/?p=294"},"modified":"2023-01-18T14:48:39","modified_gmt":"2023-01-18T19:48:39","slug":"handy-stata-command-to-create-fama-french-industry-classifications-based-on-sic-codes","status":"publish","type":"post","link":"https:\/\/www.kaichen.work\/?p=294","title":{"rendered":"Stata command to create Fama-French industry classifications based on SIC codes"},"content":{"rendered":"<p><strong>[Update on January 18, 2023]<\/strong> I was advised that the installation command in the original post didn&#8217;t work anymore. The author now instructed users, on his website, to find packages\u00a0<a href=\"https:\/\/drive.google.com\/drive\/folders\/1siOpyI0hiF7B4GTRzO2TEAtoi97kmLgh?usp=share_link\" target=\"_blank\" rel=\"noopener\">here<\/a>.<\/p>\n<p>You can download a package, as well as its help file, from the above link and place them in your ado directory.<\/p>\n<p>Please type `sysdir` in Stata to find your ado directory. You may have multiple ado directories, and I would recommend using either PLUS or Personal.<\/p>\n<p>Thank you Judson for creating this handy command!<\/p>\n<p><strong>[Original post]<\/strong>\u00a0See `ffind` written by Judson Caskey. Here is his website:<br \/>\n<a href=\"https:\/\/sites.google.com\/site\/judsoncaskey\/data\" target=\"_blank\" rel=\"noopener noreferrer\">https:\/\/sites.google.com\/site\/judsoncaskey\/data<\/a><\/p>\n<p>The syntax is as follows (download Help file <a href=\"https:\/\/sites.google.com\/site\/judsoncaskey\/ffind.hlp?attredirects=0&amp;d=1\" target=\"_blank\" rel=\"noopener noreferrer\">here<\/a>):<br \/>\n`ffind sic, newvar(ffi) type(30)`<\/p>\n<p>`type(30)` means Fama_French 30 industries classification.\u00a0Type must be 5, 10, 12, 17, 30, 38, 48 or 49.<\/p>\n<p>This command does not support installation using `ssc install`. Type the following in Stata to install the command:<br \/>\n`net from https:\/\/sites.google.com\/site\/judsoncaskey\/data`<br \/>\n`net install utilities.pkg`<\/p>\n<p>See here for equivalent SAS macro:<br \/>\n<a href=\"http:\/\/faculty-gsb.stanford.edu\/dehaan\/SAS.html\" target=\"_blank\" rel=\"noopener noreferrer\">http:\/\/faculty-gsb.stanford.edu\/dehaan\/SAS.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>[Update on January 18, 2023] I was advised that the installation command in the original post didn&#8217;t work anymore. The author now instructed users, on his website, to find packages\u00a0here. You can download a package, as well as its help &hellip; <a href=\"https:\/\/www.kaichen.work\/?p=294\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"_links":{"self":[{"href":"https:\/\/www.kaichen.work\/index.php?rest_route=\/wp\/v2\/posts\/294"}],"collection":[{"href":"https:\/\/www.kaichen.work\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.kaichen.work\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.kaichen.work\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.kaichen.work\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=294"}],"version-history":[{"count":23,"href":"https:\/\/www.kaichen.work\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions"}],"predecessor-version":[{"id":1626,"href":"https:\/\/www.kaichen.work\/index.php?rest_route=\/wp\/v2\/posts\/294\/revisions\/1626"}],"wp:attachment":[{"href":"https:\/\/www.kaichen.work\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=294"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.kaichen.work\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=294"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.kaichen.work\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=294"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}