I have all historial reords in a single lasr dataset as shown above ;I also got period_id to show period data in addtion to report_date.The credit rating field (crr_stage_identifier),a numeric item needs to be compared with previous period record and create the calculated character field, stage_movement with message as shown in the data above.
For example, IFRS_ID,X1 moved from credit rating stage 1 in previous period to stage 2 in current period and hence stage_movement got value as 'stage 1 to stage 2'.
same way, I would like to create caluated fields for ead and ecl differences from previous period.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.