JHE Tracker

Calculation of member enrollment by month -- member month MM

JHE — Thu, 18 Jan 2024 01:00:44 GMT

Good evening:

I have data set as:

ID	Eff_DT	TERM_DT
2987	1/1/2022	3/31/2022
2899	1/1/2022	2/28/2022
2876	1/1/2023	2/28/2022

I need to have out put as:

ID	MONTH	MM
2987	2022-01	1
2987	2022-02	1
2987	2022-03	1
2899	2022-01	1
2899	2022-02	1
2876	2022-01	1
2876	2022-02	1

Please help

Thank you

Re: Member enrollment month

JHE — Wed, 17 Jan 2024 18:30:56 GMT

Question and Answer wanted should be as :

IN PUT
ID	EFF_DT	END_DT
1304	1/1/2019	1/1/2023
1398	1/1/2019	12/31/2020

OUT PUT 1
ID	MONTH	MM
1302	2019-01	1
1302	2019-02	1	….
1302	2019-03	1
1398	2019-01	1
1398	2019-02	1
1398	2019-03	1

Final from above to have final result as:
Output 2
MONTH	MM
2019-01	2
2019-02	2
2019-03	2

Re: Member enrollment month

JHE — Wed, 17 Jan 2024 18:20:47 GMT

output need to add ID column:

Output three columns as:
ID, Month, MN,

how to add ID ?

Re: Member enrollment month

JHE — Wed, 17 Jan 2024 17:22:31 GMT

thank you , I will try and update with you !

Re: Member enrollment month

JHE — Wed, 17 Jan 2024 17:09:50 GMT

Month , MM ( member count of the month)

Member enrollment month

JHE — Wed, 17 Jan 2024 16:41:54 GMT

I have Member ID, efft_date, term_date,

I like to know members monthly enrolment count called: Member Month MM

ID	EFF_DT	END_DT
1304	3/2/2019	1/1/2023
1508	2/1/2022	12/31/2023
1907	12/1/2021	8/30/2022

Need to set up flag those members enroll month as 1 then summary month total for three of them , call member month

Re: Count monthly disenrollment

JHE — Mon, 31 Oct 2022 04:47:06 GMT

thank you. But if I want count 2021 disenrollment, the rest of the month dose not enrolled should be counted as disenroll, hwo could I do that

similar to this ..but it is disenroll. How to ?

https://communities.sas.com/t5/SAS-Programming/Finding-the-continous-and-discontinous-months-enrollment-over/td-p/614455

Count monthly disenrollment

JHE — Mon, 31 Oct 2022 04:20:46 GMT

I need count monthly disenrollment for 2022.

Data table :

MEMBER_ID	ENROLLMENT	DISENROLLEMNT
A0001	2/1/2021	3/1/2021
A0001	5/29/2021	6/24/2021
A0001	7/1/2021	8/1/2021
B0001	6/3/2021	8/2/2021
B0001	10/1/2021	11/1/2021

How do I have the monthly disenroll , and count by member_ID: as following

1. Member_ID, Disenroll_Month_Flg

A0001 202104

A0001 202107

A0001 202209

B0001 202109

B0001 202112

2. Summary: disenroll by month

month count:

202104 1

202107 1

202109 2

202112 1

3. Summery disenroll by member:

Member Count

A0001 3

B0001 2

Re: Date format

JHE — Tue, 24 Aug 2021 20:36:08 GMT

I go it, YYYMMDDSD10.

Re: Date format

JHE — Tue, 24 Aug 2021 20:20:24 GMT

thank you.

But need result as: YYYY/MM/DD, such as 2021/02/23

Date format

JHE — Mon, 23 Aug 2021 14:46:10 GMT

Date for example: 3/21/2021,

want to convert to 2021/3/21,

Is there as good way to do instead convert to Str ...?

Does SAS has date format as yyyy/mm/dd ?

Re: date format

JHE — Sun, 22 Aug 2021 03:35:23 GMT

I need convert date display:

I have date for example: 8/21/2021, customer need display this format as 2021/08/21.

What I could do?

Thank you

Re: date format

JHE — Sun, 22 Aug 2021 03:33:05 GMT

I have date is the forma such as : 8/21/2021, customer need the format as : 2021/08/21, how do I ?

Re: Proc Report

JHE — Fri, 25 Jun 2021 18:34:59 GMT

ok, thank you !!

I might change paid to character to see if it can work...

Re: Proc Report

JHE — Fri, 25 Jun 2021 18:33:24 GMT

total = sum(Count) by LOB, not need to sum the rest and showing on report , only member_count summary need to be report, leave the rest of them blank ... on the Total line ...

Re: Proc Report

JHE — Fri, 25 Jun 2021 18:25:50 GMT

$1,660, $1,750 no needed, want to be blank, only Member_count needs summarized

Re: Proc Report

JHE — Fri, 25 Jun 2021 18:24:00 GMT

thank you, after run , the result.

LOB	MEMBERCOUNT	PROGRAMNAME	PAID
MEDICAID	150	A	$300
	290	B	$600
	100	C	$760
TOTAL	540		$1,660
MEDICARE	400	A	$1,000
	350	B	$400
	180	C	$350
TOTAL	930		$1,750

I do not want paid summary or computers, want remove $1,660, %1,750 and become blank , only memer_count need summarized and leave the rest of are blank

Re: Proc Report

JHE — Fri, 25 Jun 2021 16:04:09 GMT

LOB="TOTAL"

Re: Proc Report

JHE — Fri, 25 Jun 2021 15:47:50 GMT

PROC REPORT	DATA=DATA_SAMPLE
	COLUMNS	MEMBER COUNT	PROGRAM NAME	PAID ;
	DEFINE	TOTAL/COMPUTED;
	DEFINE	LOB/ORDER;
	BREAK AFTER LOB/SUMMARIZED SUPPRESS;
	COMPUTE BEFORE LOB;
	TOB="TOTAL";
	TOTAL=SUM(MEMBER_COUNT);
	ENDCOMP;
RUN;

Proc Report

JHE — Fri, 25 Jun 2021 15:33:42 GMT

Original Data
	LOB	MEMBER COUNT	PROGRAM NAME	PAID
	MEDICAID	150	A	$300
		290	B	$600
		100	C	$760
	MEDICARE	400	A	$1,000
		350	B	$400
		180	C	$350

Want output report like this:

REPORT FORMAT
SUMMARY BY LOB	LOB	MEMBER COUNT	PROGRAM NAME	PAID
	MEDICAID	150	A	$300
		290	B	$600
		100	C	$760
	TOTAL	540
	MEDICARE	400	A	$1,000
		350	B	$400
		180	C	$350
	TOTAL	930

do not know how to