Good day All,   Please assist me: I am trying to convert this date format 05AUG2014:00:00:00.000 to just the day of the month in a data step, e.g from 05AUG2014:00:00:00.000 to 05 ... View more

Hi All,   Please assist me. I am trying to get all variables only at 2 points, at the earliest date (LTPR1) and at the latest date (LTPR2). I have millions of records with different starting and end dates. Current data: Arrears Balance Instalemt CD Lifetime Lifetime Period LTPR1 LTPR12 -17 7400.61 323 0 A 201911 201910 202004 -391 6380.61 323 -1 A 202001 201910 202004 -340 7400.61 323 -1 A 201910 201910 202004 -68 6057.61 323 0 C 202003 201910 202004 -384 6710.61 323 -1 A 201912 201910 202004 -68 6380.61 323 0 D 202002 201910 202004 259.64 6062.25 323 1 8 202004 201910 202004   Desired output: ID_Number Arrears @1 Arrears @12 Balance @ 1 Balance @ 12 CD @ 1 CD @ 12 Lifetime @ 1 Lifetime @ 12 Lifetime Period @ 1 Lifetime Period @ 12 LTPR1 LTPR12 12345678910 -340 259.64 7400.61 6062.25 -1 1 A 8 201910 202004 201910 202004     This is the code I currently have: proc sql; create table Sub2 as select *, min('Lifetime Payment Rating Finmonth'n) as LTPR1, max('Lifetime Payment Rating Finmonth'n) AS LTPR12 from Variables where Sub = 2 and Income_Doc_Type is not null group by ID_Number having Nett_Monthly_Income = max(Nett_Monthly_Income) and ID_Number=max(ID_Number); run; ... View more