topic Re: dividing observations based on dates in SAS Programming

dividing observations based on dates

lone0708 — Wed, 14 Sep 2022 06:20:16 GMT

Hello all,

I am working with a dataset containing information about women with sample dates before, during and after last pregnancy, and i want to give them a flag describing when the sample is taken. The part teasing me is the timing between pregnancies. How can program that?

data have;

input woman pregnancy_start pregnancy_end sample_date;

1 01-01-2016 01-09-2016 01-01-2015

1 01-01-2016 01-09-2016 01-01-2017

1 01-02-2017 01-10-2017 01-01-2017

1 01-02-2017 01-10-2017 01-01-2018

2 01-01-2016 01-09-2016 01-05-2016

3 01-01-2016 01-09-2016 01-01-2018

4 01-01-2016 01-09-2016 01-01-2015

;

run;

;

run;

data want:

data want;

input woman pregnancy_start pregnancy_end sample_date timing;

datalines;

1 01-01-2016 01-09-2016 01-01-2015 before pregnancy

1 01-01-2016 01-09-2016 01-01-2017 between pregnancies

1 01-02-2017 01-10-2017 01-01-2017 between pregnancies

1 01-02-2017 01-10-2017 01-01-2018 after last pregnancy

2 01-01-2016 01-09-2016 01-05-2016 during pregnancy

3 01-01-2016 01-09-2016 01-01-2018 after last pregnancy

4 01-01-2016 01-09-2016 01-01-2015 before pregnancy

;

run;

Re: dividing observations based on dates

PaigeMiller — Tue, 13 Sep 2022 19:19:11 GMT

Is this a complete set of possible outcomes? Could woman 1 have a sample date during her first pregnancy? Could woman 1 have a sample date during her second pregnancy? Could woman 1 have a sample date during both pregnancies, or after both pregnancies, or before both pregnancies?

Re: dividing observations based on dates

lone0708 — Tue, 13 Sep 2022 19:29:19 GMT

No, you are right, all the outcomes you mention are possible outcomes. Every possible combination of samples is possible

Re: dividing observations based on dates

PaigeMiller — Tue, 13 Sep 2022 19:33:41 GMT

So, if woman 1 had sample date during her first pregnancy, would the desired outcome be "During 1st Pregnancy"? or just "During Pregnancy"?

If a woman had three pregnancies, would you want "Between 2nd and 3rd Pregnancy"?

Don't make us guess what you want. Don't make us try to enumerate all the possible outcomes. Please give an example which illustrates all possible examples and what outcome you want.

Re: dividing observations based on dates

lone0708 — Tue, 13 Sep 2022 19:38:46 GMT

No, it is fine with just "during pregnancy" and "between pregnancies" 🙂

Re: dividing observations based on dates

PaigeMiller — Tue, 13 Sep 2022 19:45:14 GMT

Example data showing all possible combinations and outcomes is requested.

Re: dividing observations based on dates

lone0708 — Wed, 14 Sep 2022 05:45:43 GMT

data want:

woman pregnancy_start pregnancy_end sample_date timing

1 01-01-2016 01-09-2016 01-01-2015 before pregnancy

1 01-01-2016 01-09-2016 01-01-2017 between pregnancies

1 01-02-2017 01-10-2017 01-01-2017 between pregnancies

1 01-02-2017 01-10-2017 01-01-2018 after last pregnancy

2 01-01-2016 01-09-2016 01-05-2016 during pregnancy

3 01-01-2016 01-09-2016 01-01-2018 after last pregnancy

4 01-01-2016 01-09-2016 01-01-2015 before pregnancy

Re: dividing observations based on dates

andreas_lds — Wed, 14 Sep 2022 05:50:09 GMT

Please post data in usable form with all possible combinations included.

Re: dividing observations based on dates

lone0708 — Wed, 14 Sep 2022 06:20:55 GMT

I have tried to update the post now, sorry for the in convinience