Unique Identifier Creation

[vomer]

Hi All,

I have the following scenario:

CLIENT	INST	SENDER	RECIV	UNIQUE CLIENTS
1	985	SITE A	R1	1
1	698	SITE A	R1	0
1	563	SITE A	R2	1
1	785	SITE A	R2	0

The Unique clients column above is how I want SAS to compute a unique client. Basically - for every unique set of CLIENT, SENDER and RECIV I want to mark UNIQUE CLIENTS as 1.

The thinking behind what I want to identify is - "For SITE A - there were 2 UNIQUE CLIENT instances going to 2 unique RECIV".

I would like to know how to code the UNIQUE CLIENTS part if possible. Thanks.

[Astounding · Accepted solution]

Vomer,

These are tools that you absolutely will have to learn if you want to program in SAS.

proc sort data=have;

   by client reciv;

run;

data want;

   set have;

   by client reciv;

   unique_clients = first.reciv;

run;

Good luck.