topic Re: Import text file in SAS Procedures

Import text file

thdang — Fri, 30 Nov 2012 12:23:43 GMT

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.

Re: Import text file

PGStats — Fri, 30 Nov 2012 15:49:37 GMT

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;

Re: Import text file

thdang — Fri, 30 Nov 2012 16:14:33 GMT

Thank you!!