## create id from a sorted visit frequency data

Solved
Occasional Contributor
Posts: 14

# create id from a sorted visit frequency data

Hi everyone,

If i have a data which is the following

data t;INPUT x;

cards;
1
2
1
2
3
1
2

This data set is merged from each person.

So, its id should be 1 1 2 2 2 3 3.

How could I get the the id I want? I have tried use the if first statement, but I failed.

Please tell me the easiest way to do it.

Accepted Solutions
Solution
‎11-15-2015 12:38 PM
Super User
Posts: 6,632

## Re: create id from a sorted visit frequency data

This would be one way:

data want;

set have;

priorx = lag(x);

if _n_=1 or x <= priorx then id + 1;

drop priorx;

run;

This assumes that when X stays the same from one observation to the next, that the ID should be different.

Good luck.

All Replies
Solution
‎11-15-2015 12:38 PM
Super User
Posts: 6,632

## Re: create id from a sorted visit frequency data

This would be one way:

data want;

set have;

priorx = lag(x);

if _n_=1 or x <= priorx then id + 1;

drop priorx;

run;

This assumes that when X stays the same from one observation to the next, that the ID should be different.

Good luck.

🔒 This topic is solved and locked.