Hi @Shmuel, Can you still help me?   Tks!!! ... View more

Hi,] How Can I apply here?   PROC SQL; CREATE TABLE TESTE AS SELECT DISTINCT T1.* FROM TESTE_2 T1 INNER JOIN TESTE_3 T2 ON T1.NAME = T2.NAME INNER JOIN TESTE_4 T3 ON T1.NAME = T3.NAME LEFT JOIN TESTE_5 t4 ON T1.NAME = T4.NAME LEFT JOIN TESTE_6 T5 ON T1.NAME = T5.NAME WHERE T3.NAME IS MISSING AND T4.NAME IS MISSING AND T5.NAME IS MISSING ; RUN;     That is my sample, So I need to count the cases for each filter: Apply T3.NAME IS MISSING (count how many cases out for this filter) then apply the second (count again)....   It helps? Thank you so much! ... View more

PROC SQL; CREATE TABLE TESTE AS SELECT DISTINCT T1.* FROM TESTE_2 T1 INNER JOIN TESTE_3 T2 ON T1.NAME = T2.NAME INNER JOIN TESTE_4 T3 ON T1.NAME = T3.NAME LEFT JOIN TESTE_5 t4 ON T1.NAME = T4.NAME LEFT JOIN TESTE_6 T5 ON T1.NAME = T5.NAME WHERE T3.NAME IS MISSING AND T4.NAME IS MISSING AND T5.NAME IS MISSING ; RUN;     That is my sample, So I need to count the cases for each filter: Apply T3.NAME IS MISSING (count how many cases out for this filter) then apply the second (count again)....   It helps? Thank you so much! ... View more

Hi Shmuel, Can I do it into a PROC SQL statement, because I have some joins inside.   Tks ... View more