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!
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.
It's finally time to hack! Remember to visit the SAS Hacker's Hub regularly for news and updates.
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.
Ready to level-up your skills? Choose your own adventure.