DATA Step, Macro, Functions and more

problem infile statement

Reply
Occasional Contributor
Posts: 5

problem infile statement

[ Edited ]

when i am trying to import this data into SAS.

324036.jpg

i use the following code, however......

 

data Conference;
length eat $24.;
infile 'C:\Users\user\Dropbox\SAS\SASDATA\Conference.dat' missover;
input attendee $1-20 business $21-41 attendeeID 42-46 phone1 $47-60 phone2 $61-74 phone3 $75-88
registered $89-92 contacthome $93-96 contactmobile $97-100 @101 registrationrate
Wednesday $105-108 Thursday $109-112 voluntee $113-116 @117 eat ;

run;

 

I got this result ..

 

324041.jpg

only the first word in EAT variable(the first column=the last column in last pic) is read in successfully....

could anyone help me Smiley Frustrated    thank you!

Super User
Posts: 7,771

Re: problem infile statement

Posted in reply to weiwei2392

Try this instead:

data conference;
infile 'C:\Users\user\Dropbox\SAS\SASDATA\Conference.dat' truncover;
input
  attendee $1-20
  business $21-41
  attendeeID 42-46
  phone1 $47-60
  phone2 $61-74
  phone3 $75-88
  registered $89-92
  contacthome $93-96
  contactmobile $97-100
  @101 registrationrate
  Wednesday $105-108
  Thursday $109-112
  voluntee $113-116
  @117 eat $24.
;
run;

Note the truncover option instead of missover, and the use of the $24. format to prevent the interpretation of blanks as delimiters when reading the variable eat.

---------------------------------------------------------------------------------------------
Maxims of Maximally Efficient SAS Programmers
Ask a Question
Discussion stats
  • 1 reply
  • 120 views
  • 1 like
  • 2 in conversation