The only difference between the two types of record is the number of fields, so use that:   data want; retain date time; infile datalines missover; length valueA valueB valueC $16; input valueA -- valueC; if missing(valueC) then do; date = valueA; time = valueB; end; else output; datalines; now time Fred Wilma Pebbles Gord Susy NoNoNo late time Barney Betty BamBam sure time Dino Slate Green Sam Slate Green Norm Slate Green ; ... View more

First you'll likely get better results if Name is character. Try this; DATA ONE; INPUT NAME $ NUM $ ; CARDS; FRED 1234 WILMA 4567 BARNEY 8369 BAMBAM 7894 ; RUN; DATA TWO; INPUT NAME $ NUM $ ; CARDS; FRED 1234 WILMA 8369 BETTY 7894 ; RUN; PROC SORT DATA=ONE NODUPKEY; BY NAME NUM; RUN; PROC SORT DATA=TWO NODUPKEY; BY NAME NUM; RUN; data three; merge one (in=inone) two (in=intwo); by name num; if inone and intwo; run; ... View more