Most efficient way to find a change in data

dlazer1 — Mon, 27 May 2019 20:05:03 GMT

Hi,

I am working with data and want to make sure I have it coded correctly. I have a company ID and partner ID and date. I want to see when the partner ID changes for each company ID. How would I do that?

Thank you!

Re: Most efficient way to find a change in data

Reeza — Mon, 27 May 2019 20:17:02 GMT

It depends a bit, are you expecting it to never change? If so you can easily detect that by looking at the max/min values via SQL which operate on character variables as well. If you want to just identify changes you can use BY group processing.

Try this to get you started - note the NOTSORTED option because I'm assuming your data is in order of date, but not necessarily in order by partnerID.

data want;
set have;
by companyID partnerID notsorted;

if first.partnerID and not first.companyID then flag=1;
else flag=0;

run;

@dlazer1 wrote:

Hi,

I am working with data and want to make sure I have it coded correctly. I have a company ID and partner ID and date. I want to see when the partner ID changes for each company ID. How would I do that?

Thank you!

topic Re: Most efficient way to find a change in data in SAS Programming

Most efficient way to find a change in data

Re: Most efficient way to find a change in data