retain values in sequential order starting from zero by dose

[chinna0369]

Hi, 

I am trying to create reduce variable from below data, reduce value starts from 0 and increases if any reduction in dose and retains tilll next reduction.

I have data like below

Can anyone provide the logic for this.

Thanks,

Adi

[PaigeMiller · Accepted solution]

data want;
    set have;
    by id;
    if first.id then reduce=0;
    reduce+(dif(dose)<0 and not first.id);
run;

[chinna0369]

Somehow this is not working with my data, is there any other way?

[PaigeMiller]

Providing data as a screen capture isn't helpful, as we can't run code against a screen capture. The proper way to provide data is in a SAS data step, instructions are here: https://blogs.sas.com/content/sastraining/2016/03/11/jedi-sas-tricks-data-to-data-step-macro/

Saying "it doesn't work" doesn't help either. We need details, we need your data, we need to see your code. What about it doesn't work? Is there an error in the log? We will need to see your log in order to diagnose errors in the log. Or if the output wrong, if so please show us and explain.

[PaigeMiller]

Also, please don't post the same question more than once.

From this point forward, all discussion of this question should be in your other thread at https://communities.sas.com/t5/SAS-Programming/Assign-sequence-based-dose-starting-from-zero/m-p/768...

I will not discuss this topic further in this thread, all comments should go to the other thread.

[Kurt_Bremser]

---

@chinna0369 wrote:

Somehow this is not working with my data, is there any other way?

---

Provide example data in usable form. Post your data as a data step with datalines, as I showed you here.

We cannot code and test against pictures, we need usable data. DO NOT SKIP THE ABOVE.