Stata command to create Fama-French industry classifications based on SIC codes

[hussein bataineh]

Hi,

I have a dataset with SIC codes and I want to create the 48 Fama-French industry classifications from it. I'm not sure how to proceed. I've read that there are some packages available for download that can assist with creating the 48 SIC codes.

Can anyone guide me on how to do this?

Thanks!

[George Ford]

https://ideas.repec.org/c/boc/bocode/s458381.html

[hussein bataineh]

please professor could you give me some guidance on how to apply this code, from the website you provide

the name of SIC code variable in my data base is
SIC_WRDS_1

[George Ford]

do you have 4-digit sic? it requires it.

[George Ford]

https://www.statalist.org/forums/forum/general-stata-discussion/general/1295492-fama-french-12-industries-classification-in-stata

see post #4.

I think this will do it in one shot, where the other requires you do it sic by sic.

[hussein bataineh]

yes professor i have 4-digit sic in my database but im not sure the steps to run the code ? can you give me some guidance on how to apply these code

thanks

[George Ford]

copy the ffind.ado file to you ...ado/personal folder.

destring sic, g(sicnum)  //destring the sic code if necessary
ffind sicnum , g(ffind) type(48)  // creates the 48 industries.

[hussein bataineh]

Thanks a lot prof Geroge. it work