Hi Art   It worked, unfortunately there still remains lines that do not fit the criteria....the line count however is significantly less than before though. ... View more

Hi Shmuel   No I do not need the type...it was my fault for including it. I did so because I was under the impression that in order to do what I wanted to do I needed to have the 7 different tables until I learned in this forum that I didnt require it.... ... View more

hHi again Art   I was almost there but at the very end got this error message:   415 proc sql; 416 create table results (drop=rec_count comp_count) as 417 select *, count(*) as rec_count 418 from Step2 as a 419 join (select MEMNO,BEGDATE,SProv_Spec,TAXID,count(*) as comp_count 420 from Step2 421 group by MEMNO,BEGDATE,SProv_Spec,TAXID) as b 422 on a.MEMNO = b.MEMNO 423 group by MEMNO 424 having rec_count eq comp_count; ERROR: Ambiguous reference, column MEMNO is in more than one table.   (tired of writing key1 etc because that juat may be the disconnect so using the real field names)   ... View more

Thanks all   The types were used because i began the project thinking that it was best to seperate the types. The types are actually already in my dataset but thought it would be easier bumping them up against each other thats why I wanted to differentiate them but I am finding that its use is not really necessary in the grand scheme of things. ... View more

Thanks art297   First let me apologize to everyone, I am green when it comes to SAS code so forgive my naivete, but this code is confusing to me, Usint this code means I do or do not have to seperate the "TYPE"? I am also confused by the "from have as a" statement as well as the "  group by key1,key2,key3,key4) as b on a.key1 = b.key1" statement. ... View more

By the way, there are many other columns in the dataset that do not need to be identical just the 4 keys ... View more

Thanks again Schmuel   That worked, however, I am getting the same results as if i had used the 7 seperate parts. It is not eliminating lines that do not have the 4 criteria in common. For instance, in the example below, there are 7 sets of data, each set has the same KEY1. But only the set highlighted in red are the only ones I am interested in because all 4 keys are identicle where as the others may have one or two keys that are identical but the other keys are not.   KEY1 KEY2 KEY3 KEY4 XXX581800 01/05/16 34 043397450 XXX581800 01/29/16 CF 208550806 XXX585700 01/21/16 03 043397450 XXX585700 01/21/16 03 043397450 XXX589800 01/07/16 58 043397450 XXX589800 01/28/16 05 043397450 XXX591700 01/12/16 35 043397450 XXX591700 01/26/16 21 043397450 XXX618000 01/25/16 35 043397450 XXX618000 01/08/16 03 043397450 XXX624000 01/29/16 01 043584262 XXX624000 01/29/16 01 043584262     ... View more