Help using Base SAS procedures

Unique Identifier Creation

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 117
Accepted Solution

Unique Identifier Creation

Hi All,

I have the following scenario:

CLIENTINSTSENDERRECIVUNIQUE CLIENTS
1985SITE AR11
1698SITE AR10
1563SITE AR21
1785SITE AR20

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.


Accepted Solutions
Solution
‎03-13-2013 04:25 PM
Super User
Posts: 5,249

Re: Unique Identifier Creation

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.

View solution in original post


All Replies
Solution
‎03-13-2013 04:25 PM
Super User
Posts: 5,249

Re: Unique Identifier Creation

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.

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 149 views
  • 0 likes
  • 2 in conversation