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

topic Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text? in SAS Data Science https://communities.sas.com/t5/SAS-Data-Science/Fama-French-25-Portfolio-Returns-How-can-I-get-SAS-or-Excel/m-p/207555#M2819 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to get the Fama French 25 Portfolio Returns, but on Fama French's Data Library website:<A href="http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html#Research" title="http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html#Research">Kenneth R. French - Data Library</A></P><P></P><P>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!</P></BODY></HTML> Mon, 23 Mar 2015 00:10:46 GMT MR_Xishuai 2015-03-23T00:10:46Z Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text? https://communities.sas.com/t5/SAS-Data-Science/Fama-French-25-Portfolio-Returns-How-can-I-get-SAS-or-Excel/m-p/207555#M2819 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I am trying to get the Fama French 25 Portfolio Returns, but on Fama French's Data Library website:<A href="http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html#Research" title="http://mba.tuck.dartmouth.edu/pages/faculty/ken.french/data_library.html#Research">Kenneth R. French - Data Library</A></P><P></P><P>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!</P></BODY></HTML> Mon, 23 Mar 2015 00:10:46 GMT https://communities.sas.com/t5/SAS-Data-Science/Fama-French-25-Portfolio-Returns-How-can-I-get-SAS-or-Excel/m-p/207555#M2819 MR_Xishuai 2015-03-23T00:10:46Z Re: Fama French 25 Portfolio Returns: How can I get SAS or Excel files rather than text? https://communities.sas.com/t5/SAS-Data-Science/Fama-French-25-Portfolio-Returns-How-can-I-get-SAS-or-Excel/m-p/207556#M2820 <HTML><HEAD></HEAD><BODY><P>When you have your data in Excel - the single row, highlight the rows, click on the DATA table then Text to Columns.</P><P></P><P><A href="https://support.microsoft.com/en-us/kb/214261" title="https://support.microsoft.com/en-us/kb/214261">How to parse data using the Text To Columns command in Excel</title>  <link href="//az623152.vo.msecnd.net/cdnresources/1.70/content/smccss.css" rel="stylesheet" /> <link href="//az623152.vo.msecnd.net/cdnresources/1.70/content/pdf/css/pdf.dgps-1.0.0.css" rel="stylesheet" />   <script src="//ajax.aspnetcdn.com/ajax/jQuery/jquery-1.9.1.min.js"> </script> <script src="//ajax.aspnetcdn.com/ajax/jquery.migrate/jquery-migrate-1.2.1.min.js"> </script> <script type="text/javascript">var PersonalizationInfo = '';</script> <script type="text/javascript"> window.showDgpsInHeader = true; </script> <script type="text/javascript" src="//az623152.vo.msecnd.net/cdnresources/1.70/common/script/gsfx/ac.js"></script> <script type="text/javascript" src="//az623152.vo.msecnd.net/cdnresources/1.70/common/script/gsfx/default.js"></script> <script type="text/javascript" src="//az623152.vo.msecnd.net/cdnresources/1.70/scripts/ssbbannerandads.js"></script> <script type="text/javascript" src="//az623152.vo.msecnd.net/cdnresources/1.70/common/script/gsfx/stickypanel.js"></script><link rel="stylesheet" type="text/css" href=//az623152.vo.msecnd.net/cdnresources/1.70/common/css/default/xmlcontent.classic.css><script type="text/javascript" src="//az623152.vo.msecnd.net/cdnresources/1.70/common/script/gsfx/kb.classic.js"></script><link rel="stylesheet" type="text/css" href=//az623152.vo.msecnd.net/cdnresources/1.70/common/css/default/branding.css> <div id="skip" class="hidden"> <input type="button" value="Skip Navigation" onclick="SkipNav()" /> </div> <script type="text/javascript"> function SkipNav() { document.getElementById('NavigatorLabel').focus(); } </script> <script type="text/javascript"> window.appInsights = { queue: [], applicationInsightsId: null, accountId: null, appUserId: null, configUrl: null, start: function (n) { function u(n, t) { n<T> = function () { var i = arguments; n.queue.push(function () { n<T>.apply(n, i) }) } } function f(n) { var t = document.createElement("script"); return t.type = "text/javascript", t.src = n, t.async = !0, t } function r() { i.appendChild(f("//az416426.vo.msecnd.net/scripts/ai.0.js")) } var i, t; this.applicationInsightsId = n; u(this, "logEvent"); u(this, "logPageView"); i = document.getElementsByTagName("script")[0].parentNode; this.configUrl === null ? r() : (t = f(this.configUrl), t.onload = r, t.onerror = r, i.appendChild(t)); this.start = function () { } } }; appInsights.start("d4daff9c-f6cd-4a99-a9a5-1d81baae8e0b"); appInsights.logPageView(); </script></head><body> <div class="Header"> <head id="ctl00_Head1"><title> Home Page</T></T></A></P></BODY></HTML> Mon, 23 Mar 2015 01:59:06 GMT https://communities.sas.com/t5/SAS-Data-Science/Fama-French-25-Portfolio-Returns-How-can-I-get-SAS-or-Excel/m-p/207556#M2820 Reeza 2015-03-23T01:59:06Z