topic Re: combine multiple dates together in New SAS User

combine multiple dates together

knighsson — Wed, 11 May 2022 16:33:59 GMT

Hello

I want to combine the same date together and calculate how many days, could you please let me know how to do this?

The original dataset

ID	DATE	XX	YY
1	04/10/13
1	04/10/13

1	05/10/13
1	06/10/13
2	04/10/13
2	04/10/13
2	04/10/13

the ideal dataset

ID	DATE	number of same date	YY
1	04/10/13	2
1	05/10/13	1
1	06/10/13	1
2	04/10/13	3

Re: combine multiple dates together

Reeza — Wed, 11 May 2022 18:43:54 GMT

Use PROC FREQ, result will be in the WANT data set.

proc freq data=have noprint;
table id*date / out=want list;
run;

@knighsson wrote:

Hello

I want to combine the same date together and calculate how many days, could you please let me know how to do this?

The original dataset

ID DATE XX YY

1 04/10/13

1 04/10/13

1 05/10/13

1 06/10/13

2 04/10/13

2 04/10/13

2 04/10/13

the ideal dataset

ID DATE number of same date YY

1 04/10/13 2

1 05/10/13 1

1 06/10/13 1

2 04/10/13 3

Re: combine multiple dates together

knighsson — Wed, 11 May 2022 19:47:03 GMT

Thank you!