problem infile statement

[weiwei2392]

when i am trying to import this data into SAS.

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 ..

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

could anyone help me :S    thank you!

[Kurt_Bremser]

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.