topic Re: Incidence of a new event in SAS table in SAS Programming

Incidence of a new event in SAS table

mdeber30 — Fri, 09 Dec 2022 16:32:48 GMT

Hi everybody

I start on SAS and I want to detect the impact of a new positif test in the following data and fill the impact variable in this way :

In fact we count a new impact of positive test if the test was positive a the first time of follow-up period or negative at the precedent time. I have found how sort the data by patient number and by follow-up time. I hope my explanations are clear ...

Thank you for your help.

Marilyn

Re: Incidence of a new event in SAS table

PaigeMiller — Fri, 09 Dec 2022 16:38:27 GMT

data want;
    set have;
    by patient;
    prev_test=lag(test);
    if (first.patient and test='Positif') 
        or (not first.patient and test='Positif' and prev_test='Negatif') then incidence=1;
    else incidence=0;
    drop prev_test;
run;

Re: Incidence of a new event in SAS table

mdeber30 — Fri, 09 Dec 2022 22:40:28 GMT

Hi,

Thanks for your help, it's work but I have a new problem :

I want to replace the missing values in Tt if the Visit isn't M00 by the Tt at the next visit. For example at visit M03-M06 I want to put 2 in the variable Tt. Is it possible ?

Thanks for your help

Marilyn

Re: Incidence of a new event in SAS table

PaigeMiller — Fri, 09 Dec 2022 22:43:11 GMT

Sure its possible. But I would need a better explanation and a few more examples, because I don't seem to understand what you wrote.

Re: Incidence of a new event in SAS table

mdeber30 — Fri, 09 Dec 2022 23:09:03 GMT

I send you a new example. For each patient, at M00 the traitment is missing it's normal because the patient haven't traitment before.

But if the visits are not M00, M03,M06, M09 ... but tests between two visits as M06-M09 or M9-M12 or M3-M6. We must have the traitment the patient have indicate taked at the next visit (because we don't know the traitment actually taken). The patient indicate the traitment taked at visits M09, M12 and M9 in this case).

I want to have this result

For test at M06-M09 I put the value of M09 it's the next visit, for test at M09-M12, I put the value of M12 visit and for the test at M03-M06 I put the value of traitment of M12 visit because it's the next visit ...

I hope it's clear ...

Thanks for your help

Marilyn

Re: Incidence of a new event in SAS table

PaigeMiller — Sat, 10 Dec 2022 12:00:52 GMT

Why does M09-M12 for Patient 1 go back to treatment 1?

I realize you are new here, so please help us out. We cannot really write code on data that is in screen captures. We need working SAS data step code in order to work on your data. You can type in the SAS data step code yourself or follow these instructions. Do not attach files, do not use screen captures to share with us your data.

Re: Incidence of a new event in SAS table

mdeber30 — Sat, 10 Dec 2022 14:58:52 GMT

Hi
It's fictives data here because I can't send reals datas. To resume I have patients with ou without impact of infection at a specific visit (M00, M03 ...). At each visit a treatment is prescribed (continue or at demand) but we know exactly the traitment used at the next visit. When we have a new impact of infection we want to know which traitment the patient have followed. But when the test realised between two visit for example M03-M06 whe know the prescribed traitment but not the real followed traitment which is know at the next visit.
Is it more clear ?
Marilyn

Re: Incidence of a new event in SAS table

PaigeMiller — Sat, 10 Dec 2022 15:27:13 GMT

@mdeber30 wrote:

It's fictives data here because I can't send reals datas.

Fake data is fine. You need to provide the fake data as SAS data step code, as I explained. I am not going to try to work from a screen capture of fake data.

Re: Incidence of a new event in SAS table

mdeber30 — Sat, 10 Dec 2022 16:21:32 GMT

Hi
Ok I understand now. I'll do it !
Marilyn

Re: Incidence of a new event in SAS table

mdeber30 — Sat, 10 Dec 2022 18:21:10 GMT

data dataset;
length id_patient $ 7;
length visit $ 7;
input id_patient $ visit $ traitment time;
datalines;
Patient1 M00 . 0
Patient1 M03 1 90
Patient1 M06 1 180
Patient1 M06-M09 . 250
Patient1 M09 2 270
Patient1 M09-M12 . 290
Patient1 M09-M12 . 95
Patient1 M12 1 360
Patient1 M15 1 450
Patient2 M00 . 0 
Patient2 M03 2 90
Patient2 M03-M06 . 125
Patient2 M09 2 270
Patient2 M12 1 360
;
run;

Hi here the SAS code for the dataset

Thanks for your help

Marilyn