Desktop productivity for business analysts and programmers

Changing records by id and occurrence

Reply
Contributor
Posts: 54

Changing records by id and occurrence

Folks,

 

I'm having an issue with something at the moment which I'd be grateful for some assistance on.  

 

I've a dataset at the moment which has a number of 0 for variable occurrence.

 

What I would like to do is change where there is a 0 to 1 and subsequently change the 1 to 2 and so on. Below gives a better idea.

 

Data in current format;

 

IDOccurrenceValue
63045
63165
63298
221100
231125
241130
251130
45196
45288
45344

 

What I would like to occur;

 

IDOccurrenceValue
63145
63265
63398
221100
231125
241130
251130
45196
45288
45344
Super User
Posts: 6,543

Re: Changing records by id and occurrence

Posted in reply to Sean_OConnor

If there is an instance of occurrence=0, will it always be for the first observation for an ID?

 

Here's an approach that makes a reasonable guess about how to handle that question:

 

data want;

set have;

by ID;

if first.ID then increment=0;

retain increment;

if occurrence=0 then increment=1;

occurrence = occurrence + increment;

run;

Ask a Question
Discussion stats
  • 1 reply
  • 123 views
  • 0 likes
  • 2 in conversation