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.
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
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
Thank you!!
Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.
Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.