topic Re: retain values in sequential order starting from zero by dose in SAS Programming

retain values in sequential order starting from zero by dose

chinna0369 — Tue, 21 Sep 2021 15:27:31 GMT

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

Re: retain values in sequential order starting from zero by dose

PaigeMiller — Tue, 21 Sep 2021 14:32:53 GMT


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

Re: retain values in sequential order starting from zero by dose

chinna0369 — Tue, 21 Sep 2021 15:14:25 GMT

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

Re: retain values in sequential order starting from zero by dose

PaigeMiller — Tue, 21 Sep 2021 16:20:04 GMT

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.

Re: retain values in sequential order starting from zero by dose

Kurt_Bremser — Tue, 21 Sep 2021 16:23:34 GMT

@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.

Re: retain values in sequential order starting from zero by dose

PaigeMiller — Tue, 21 Sep 2021 16:24:01 GMT

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/768687#M243836

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