topic finding the last contact date within a group of dates in SAS Programming

finding the last contact date within a group of dates

Anita_n — Sat, 27 Mar 2021 14:40:51 GMT

Hi all,

I have a table with date values of two patients, see table data

I wish to out the last contact date of each patient, so that my table looks afterwards like this (see table test)

any help?

finding the last contact date within a group of dates

Anita_n — Sat, 27 Mar 2021 14:26:07 GMT

Hi all,

I have the following dates of different patients, I wish to output the last contact date in a different variable called last contact:

id	date
7	04.11.81
7	26.10.88
7	18.08.89
7	10.12.90
50	10.10.90
50	16.10.98
50	15.02.00
50	08.05.10
50	12.05.20
50	22.12.20
50	18.10.21

so that the results will look like this:

id	date	lastcontact
7	04.11.81
7	26.10.88
7	18.08.89
7	10.12.90	10.12.1990
50	10.10.90
50	16.10.98
50	15.02.00
50	08.05.10
50	12.05.20
50	22.12.20
50	18.10.21	18.10.2021

any help?

finding the last contact date within a group of dates

Anita_n — Sat, 27 Mar 2021 14:34:47 GMT

Hi all,

I have a table with date values of two patients

id	date	lastcontact
7	04.11.81
7	26.10.88
7	18.08.89
7	10.12.90
50	10.10.90
50	16.10.98
50	15.02.00
50	08.05.10
50	12.05.20
50	22.12.20
50	18.10.21

I wish to out the last contact date of each patient, so that my table looks afterwards like this

id	date	lastcontact
7	04.11.81
7	26.10.88
7	18.08.89
7	10.12.90	10.12.1990
50	10.10.90
50	16.10.98
50	15.02.00
50	08.05.10
50	12.05.20
50	22.12.20
50	18.10.21	18.10.2021

any help?

finding the last contact date within a group of dates

Anita_n — Sat, 27 Mar 2021 14:55:05 GMT

Hi all,

I have a table with date values of two patients, see table data

I wish to out the last contact date of each patient, so that my table looks afterwards like this (see table test)

any help?

Re: finding the last contact date within a group of dates

sbxkoenk — Sat, 27 Mar 2021 15:11:11 GMT

Something like this:

data want;
 set have;
 by id date;
 if last.id then lastcontact=date; 
 else            lastcontact=.   ;
 format lastcontact DDMMYY10.;
run;

Koen

Re: finding the last contact date within a group of dates

mkeintz — Sat, 27 Mar 2021 16:27:23 GMT

@Anita_n wrote:

Hi all,

I have a table with date values of two patients, see table data

I wish to out the last contact date of each patient, so that my table looks afterwards like this (see table test)

any help?

"see table data". Could you please post the data in the form of a working data step? Then we can provide real help.

Edit note: I see that this duplicate posting (related to problem behavior this AM?), actually had a data set. The topics are now merged.

Re: finding the last contact date within a group of dates

Anita_n — Sat, 27 Mar 2021 16:41:46 GMT

sorry for post so often, the data is attached in the first post

Re: finding the last contact date within a group of dates

Kurt_Bremser — Sat, 27 Mar 2021 18:42:10 GMT

@Anita_n wrote:

sorry for post so often, the data is attached in the first post

In unusual fashion (Excel files). Please provide data steps with datalines, they leave no doubt about variable attributes and contents.

Re: finding the last contact date within a group of dates

Anita_n — Sat, 27 Mar 2021 19:54:35 GMT

Thanks, it worked