About JHE

JHE

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

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

JHE · ‎06-25-2021

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

JHE · ‎06-25-2021

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

JHE · ‎06-25-2021

LOB="TOTAL"

JHE · ‎06-25-2021

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;

JHE · ‎06-25-2021

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

JHE · ‎04-18-2020

Is there a way I can clean up my tempDB . Our SAS admin not reply to me yet

Online Status	Online
Date Last Visited	2 hours ago

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

Re: Proc Report

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

Re: Dynamic Varible in the table

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

Re: Proc Report

Re: Proc Report

Re: Proc Report

Re: Proc Report

Proc Report

Re: SQL passthrough