SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

create id from a sorted visit frequency data

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 14
Accepted Solution

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: 5,516

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.

View solution in original post


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

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.

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

Discussion stats
  • 1 reply
  • 245 views
  • 1 like
  • 2 in conversation