About JHE

JHE · ‎01-17-2024

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

JHE · ‎01-17-2024

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

JHE · ‎01-17-2024

output need to add ID column: Output three columns as: ID, Month, MN, how to add ID ?

JHE · ‎01-17-2024

thank you , I will try and update with you !

JHE · ‎01-17-2024

Month , MM ( member count of the month)

JHE · ‎01-17-2024

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

JHE · ‎10-31-2022

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

JHE · ‎10-31-2022

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

JHE · ‎08-24-2021

I go it, YYYMMDDSD10.

JHE · ‎08-24-2021

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

JHE · ‎08-23-2021

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 ?

JHE · ‎08-21-2021

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

JHE · ‎08-21-2021

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

JHE · ‎06-25-2021

ok, thank you !! I might change paid to character to see if it can work...

JHE · ‎06-25-2021

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 ...

Online Status	Offline
Date Last Visited	‎01-18-2024 01:58 AM

Calculation of member enrollment by month -- member month MM

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Member enrollment month

Re: Count monthly disenrollment

Count monthly disenrollment

Re: Date format

Re: Date format

Re: integrate rows

Re: Dollar format

Re: Merge or cancandinate the row with same ID

Re: Dynamic Varible in the table

Re: how to check if a variable not exists in a dataset first then proc...

Re: Dynamic Varible in the table

Calculation of member enrollment by month -- member month MM

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Re: Member enrollment month

Member enrollment month

Re: Count monthly disenrollment

Count monthly disenrollment

Re: Date format

Re: Date format

Date format

Re: date format

Re: date format

Re: Proc Report

Re: Proc Report