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