BookmarkSubscribeRSS Feed
sbasne
Calcite | Level 5

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;

3 REPLIES 3
Reeza
Super User

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
Calcite | Level 5

Thank you

slchen
Lapis Lazuli | Level 10

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;

sas-innovate-2024.png

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.

 

Register now!

What is Bayesian Analysis?

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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 3 replies
  • 789 views
  • 6 likes
  • 3 in conversation