BookmarkSubscribeRSS Feed
jithuzoom
Obsidian | Level 7
ifrs_idreport_dateeadeclperiod_idcrr_stage_identifierstage_movement 
X120161231877current period2stage 1 to stage 2
X220161231655current period1stage 3 to stage 1
X120161130645previous period1 
X220161130434previous period3 

 

Hi folks,

 

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.

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

I think the fastes and easiest way is to do some dataprep in a data step before you load the data into VA.

Then you can handle for example time gaps and other "defects" in your data.

With retain and firs/last you will get full control 🙂

//Fredrik

SAS INNOVATE 2024

Innovate_SAS_Blue.png

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. 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 820 views
  • 2 likes
  • 2 in conversation