proc sql distinct

[Danglytics]

Hi,

I have a transactoin table with transactionid and contactid.

There can be same transactionid for multiple contacts.

I'm trying to figure out how to get the count of unique transactionid AND contactids, but im not sure how to use the 'distinct' function correctly to get it, so far i have:

proc sql;

select

count (distinct transactionid contactid) as unique

from transaction_table

;

quit ;

im getting a syntax error on the count statement.

thanks for your help.

[Niuniua]

proc sql;

select

count (distinct transactionid ) as unique_trans,

count (distinct contactid) as unique_contact

from transaction_table

;

quit ;

[Danglytics · Accepted solution]

I figured it out.

proc sql;

select

count (distinct transactionid || contactid) as unique

from transaction_table

;

quit ;