Unique Identifier Creation

vomer — Wed, 13 Mar 2013 20:11:16 GMT

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.

Re: Unique Identifier Creation

Astounding — Wed, 13 Mar 2013 20:25:13 GMT

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.

topic Unique Identifier Creation in SAS Procedures

Unique Identifier Creation

Re: Unique Identifier Creation