topic proc sql distinct in SAS Procedures

proc sql distinct

Danglytics — Thu, 28 Jul 2011 17:55:20 GMT

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.

proc sql distinct

Niuniua — Thu, 28 Jul 2011 18:00:29 GMT

proc sql;

select

count (distinct transactionid ) as unique_trans,

count (distinct contactid) as unique_contact

from transaction_table

;

quit ;

proc sql distinct

Danglytics — Thu, 28 Jul 2011 18:06:24 GMT

I figured it out.

proc sql;

select

count (distinct transactionid || contactid) as unique

from transaction_table

;

quit ;