cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
BookmarkSubscribeRSS Feed
MR_Xishuai
Calcite | Level 5 MR_Xishuai
Calcite | Level 5

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

Posted 03-22-2015 08:10 PM (1813 views)

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!

25_Portfolios_5x5.txt.zip
0 Likes
Reply
1 REPLY 1
Reeza
Super User Reeza
Super User

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

Posted 03-22-2015 09:59 PM (1724 views)  |   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 -...

0 Likes
Reply

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
How to choose a machine learning algorithm

Use this tutorial as a handy guide to weigh the pros and cons of these commonly used machine learning algorithms.

Watch How to choose a machine learning algorithm on YouTube

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • ‎03-22-2015 08:10 PM
  • 1814 views
  • 0 likes
  • 2 in conversation