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 (2946 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 (2857 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

Catch up on SAS Innovate 2026

Nearly 200 sessions are now available on demand with the SAS Innovate Digital Pass.

Explore Now →
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
  • 2947 views
  • 0 likes
  • 2 in conversation