Nice that you gave more information about your problem. In merge you should state all "by" columns, like:
data combine;
merge one two;
by Name Date Time Class Route Place Arrival;
run;
For time it's simple, if you have time in HH:MM format use input function to create numeric version of TIME variable:
timenum=input(timechar,time5.);
For Arrival/Place you have to be more specific - if both are numbers, but one stored as a character, use the same input function but with different informat (like best.). If not, and there is relation like 1-Orlando etc., then it's a bigger issue.
... View more
