HELP, NEED Help Importing Raw Data

[sbasne]

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;

[Reeza]

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?

[sbasne]

Thank you

[slchen]

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;