BookmarkSubscribeRSS Feed
weiwei2392
Fluorite | Level 6

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 :S    thank you!

1 REPLY 1
Kurt_Bremser
Super User

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.

hackathon24-white-horiz.png

The 2025 SAS Hackathon has begun!

It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.

Latest Updates

How to Concatenate Values

Learn how use the CAT functions in SAS to join values from multiple variables into a single value.

Find more tutorials on the SAS Users YouTube channel.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 1210 views
  • 1 like
  • 2 in conversation