Building models with SAS Enterprise Miner, SAS Factory Miner, SAS Visual Data Mining and Machine Learning or just with programming

Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text?

Reply
Occasional Contributor
Posts: 8

Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text?

Hi All,

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!

Attachment
Super User
Posts: 19,855

Re: Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text?

Posted in reply to MR_Xishuai

When you have your data in Excel - the single row, highlight the rows, click on the DATA table then Text to Columns.

How to parse data using the Text To Columns command in Excel</title> <!-- integration code for PDF -...

Ask a Question
Discussion stats
  • 1 reply
  • 659 views
  • 0 likes
  • 2 in conversation