consider the below example: Start_dt:10MAR2023:00:00:00 Asked_Term: 3 year Renew_term: 1 year In this case the expected result is End_dt: 10MAR2024 Cause always first add renew_term once if the condition didn't meet then go to the asked term and add the asked_term value until it meets the condition ... View more

Thanks for the solution tom. However, here you are just considering the 'asked_term'  as the interval value and interval type.    But what i need is first add the 'Renew_term' only once. When added, if the END_DATE doesnt increment to more than today, then only i need to consider the 'Asked_term' and offset the same value until i get the desired date (which is more than today).   Here when just considered the asked_term the end_date would not be right for all the cases. ... View more

The values i have in the data set is date time, we need to convert the datetime to date before we do our calculation. As you mentioned, they are all 00:00:00 which is why we dont need the time just convert the datetime to date and then do our calculation.   There is no variable that holds the iteration, i was just giving an example how i need the calculation to be done to get the end_date.  And the monthly is just one month. Instead of 3 years or 1 year from the second iteration we have to add 1 month everytime until the end_date is greater than today.   ... View more

It is working now, it was my mistake to have a wrong variable.. Thank you so much. Its a life saver. ... View more

Tried the solution but still having the same result( feature_1 and feature_2 are nulls as output ... View more

Yeah i am trying to generate a report...and i am storing these value in the dataset for future reference as well(history load).    And yes, it always varies....for each mobile number and B_date the features count can vary. It is so dynamic. ... View more

data want; array _charge_descr_en $60 feature_1 feature_2; do index=1 to dim(_charge_descr_en) until(last.subscriber_num); set EXTRACT_FEATURES; by billed_date subscriber_num; array _charge_descr $50 feature_1 feature_2 ; _charge_descr[index]=features; end; drop features; run; I used this one here, however, i am not getting any errors....and also i am not getting any data in feature_1 and feature_2....i am getting nulls in those two columns alone. Billed_Date Subscriber_num Feature_1 Feature_2 17DEC2022:00:00:00.000 4038353444 17DEC2022:00:00:00.000 4038353444 17DEC2022:00:00:00.000 4038353444 17DEC2022:00:00:00.000 4038353444 17DEC2022:00:00:00.000 4038353444 17DEC2022:00:00:00.000 4038353444 17DEC2022:00:00:00.000 4038353444 ... View more

Tried this, but getting the below error ERROR: The DIM, LBOUND, and HBOUND functions require an array name for the first argument. ... View more

I want to split the data into two columns as it's the requirement for reporting. However, it does have multiple dates with multiple mobile numbers ... View more