03-22-2015 08:10 PM
I am trying to get the Fama French 25 Portfolio Returns, but on Fama French's Data Library website:Kenneth R. French - Data Library
I could only get the txt files. And I could not just copy it to excel as it will result in just one variable(all the observations in just one row). Is there a way that I could make them into a nice format(either SAS or Excel format)? I am wondering do they provide these data in SAS or Excel format? Or is there a way for me to create them from the .txt file they provided? Thanks so much!
03-22-2015 09:59 PM
When you have your data in Excel - the single row, highlight the rows, click on the DATA table then Text to Columns.