Import text file

[thdang]

Hallo, I have some text files and I would like to import them in sas. But I only get one column instead of different column. Can someone please help me with this? I attach the text file here. Thanks.

[PGStats · Accepted solution]

Assuming you only want the first portion of the file :

filename myFile "&sasforum.\datasets\F-F_Research_Data_Factors.txt";

data test;
format dt yymmn6.;
label Mkt_RF="Mkt-RF";
infile myFile missover;
input @;
if anyalpha(_infile_) = 0 and length(trimn(_infile_)) > 0 then do;
     input dttxt $ Mkt_RF SMB HML RF;
     if length(trim(dttxt)) = 6 then do;
          dt = input(dttxt, yymmn6.);
          output;
          end;
     end;
drop dttxt;
run;

PG

[thdang]

Thank you!!