Hide, There's a few ways of doing this, but here's the simplest way to debug and will work efficiently enough if your dataset isn't too big. proc sql; create table t as select a.title as title1,b.title as title2,c.title as title3,a.code from data as a inner join data as b on a.codeA = b.codeA inner join data as c on a.codeA = c.codeA where a.code=1 and b.code=2 and c.code=3 ; quit; Best, Chris
... View more