Help using Base SAS procedures

HELP, NEED Help Importing Raw Data

Reply
New Contributor
Posts: 3

HELP, NEED Help Importing Raw Data

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;

Attachment
Super User
Posts: 19,770

Re: HELP, NEED Help Importing Raw Data

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?

New Contributor
Posts: 3

Re: HELP, NEED Help Importing Raw Data

Thank you

Super Contributor
Posts: 275

Re: HELP, NEED Help Importing Raw Data

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;

Ask a Question
Discussion stats
  • 3 replies
  • 255 views
  • 6 likes
  • 3 in conversation