topic Re: HELP, NEED Help Importing Raw Data in SAS Procedures

HELP, NEED Help Importing Raw Data

sbasne — Sat, 13 Jun 2015 23:06:50 GMT

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;

Re: HELP, NEED Help Importing Raw Data

Reeza — Sat, 13 Jun 2015 23:19:56 GMT

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?

Re: HELP, NEED Help Importing Raw Data

slchen — Sat, 13 Jun 2015 23:51:51 GMT

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;

Re: HELP, NEED Help Importing Raw Data

sbasne — Wed, 17 Jun 2015 02:45:48 GMT

Thank you