Hi Guys,
I m trying to import attached data into sas from txt file.
It reads first name but not the full name and i cannot get it to read
numeric value forexample 7(10).
Thanks for the help.
Data manu;
infile "/folders/myshortcuts/Myfolder/manu.txt"
firstobs=3
dlm=' ' ;
input J_no POS_ $ F_Name : $ Le_Goals LE_Apps FA_Goal
FA_Apps LC_Goals LC_Apps Total_Goal
Yellow Red_ Diciplines;
Run;
Proc Print data=manu;
Run;
Your data appears to be TAB delimited, set the dlm='09'x instead of space.
SAS probably won't read the values 9(1) as numeric, since it has characters in the field, so you may want to read them all as character and then covert them in a data step. How would you expect it to interpret 9(1) anyways?
Thank you
Try this:
data want;
infile "d:\temp\manu.txt" truncover dlm='09'x firstobs=3 ;
input J_no $ POS_ $ F_Name : $25. Le_Goals $ LE_Apps $ FA_Goal $
FA_Apps $ LC_Goals $ LC_Apps $ Total_Goal $
Yellow Red_ Diciplines;
run;
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.