Hi VRKiwi If there is no match, then you output the unmatched in a different output file. ... View more

Hi Andreas,    The result is below:   Obs  src   filedate 1 QTRLY_RPT 2011-01-01 2 AR 2011-01-01 3 10Q 2011-01-03 4 10Q 2011-01-03 5 10K 2011-01-03 6 QTRLY_RPT 2011-01-03 7 10Q 2011-01-03 8 QTRLY_RPT 2011-01-03 9 10K 2011-01-03 10 20F 2011-01-03 11 10Q 2011-01-03 12 NW 2011-01-03 13 10K 2011-01-03 14 QTRLY_RPT 2011-01-03 15 NW 2011-01-03 16 20F 2011-01-03 17 10K/A 2011-01-03 18 10K/A 2011-01-03 19 10K 2011-01-03 20 10K 2011-01-03 21 10Q 2011-01-03   Please note that this is from the whole sample I have (could be different from the one in the earlier post) and you see various SRC types in the output. The code that Patrick provided matched the SRC types that have the same file dates.    Thank you all, ... View more

Thank you Cynthia, OBS is part of the original data, date field is numeric, SRC is 3 characters. Your code ignores the date value. For example, if both male & female are born in the same day, then output matched, else output unmatched. ... View more

Sample data: Obs src filedate 1 NW 20070919 2 10Q 20080108 3 NW 20071218 4 10Q 20080404 5 NW 20080318 6 10K 20080711 7 NW 20080709 8 10Q 20080923 9 8K 20080917 10 NW 20080917 11 10Q 20081223 12 NW 20081216 13 10Q 20090323 14 NW 20090317 15 10K 20090716 16 NW 20090714 17 10Q 20090925 18 NW 20090922 19 10Q 20091221 20 NW 20091215 Thank you. If filedate of src='10K' and filedate of src='NW' are the same then output in a matched file. Otherwise, output in unmatched file. ... View more

The variable (SRC)  takes several values, X1, X2, X3, etc. and another variable (fdate) that has different date values per observation. If fdate of X1 equals fdate of X2 then have both in matched file. Otherwise,  variables (X1 and X2) with unmatched fdate to be in a separate output file.    Thank you ... View more