Hi teri,

I am stuck with a problem using sas va .Please help me to create the below credit rating movement filter( credit_stage_movement field).I have a historical file like below which contains all fields except credit_stage_movement .My task is to create an indicator field like credit_stage_movement which shows whether crr moves from stage 1 to stage 2 by comparing crr_stage_identifier value of historical records.

Here X1 crr_stage_identifier value moves from 1 to 2 on the current period record from previous period.Hence credit_stage_movement contains 'stage 1 to stage 2'.

ifrs_id report_date ead ecl period_id crr_stage_identifier credit_stage_movement
X1 20161231 8 77 current period 2 stage 1 to stage 2
X2 20161231 6 55 current period 1 stage 3 to stage 1
X1 20161130 6 45 previous period 1
X2 20161130 4 34 previous period 3