https://communities.sas.com/t5/SAS-Visual-Analytics/how-to-do-sas-va-comparison-with-prev-period-and-derive-a-flag/m-p/354684#M7041 <TABLE><TBODY><TR><TD>ifrs_id</TD><TD>report_date</TD><TD>ead</TD><TD>ecl</TD><TD>period_id</TD><TD>crr_stage_identifier</TD><TD><U>stage_movement&nbsp;</U></TD></TR><TR><TD>X1</TD><TD>20161231</TD><TD>8</TD><TD>77</TD><TD>current period</TD><TD>2</TD><TD>stage 1 to stage 2</TD></TR><TR><TD>X2</TD><TD>20161231</TD><TD>6</TD><TD>55</TD><TD>current period</TD><TD>1</TD><TD>stage 3 to stage 1</TD></TR><TR><TD>X1</TD><TD>20161130</TD><TD>6</TD><TD>45</TD><TD>previous period</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>X2</TD><TD>20161130</TD><TD>4</TD><TD>34</TD><TD>previous period</TD><TD>3</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Hi folks,</P><P>&nbsp;</P><P>I have all historial reords in a single lasr dataset as shown above ;I also got <STRONG>period_id</STRONG> to show period data in addtion to report_date.The <STRONG>credit rating field (crr_stage_identifier</STRONG>),<STRONG>a numeric item</STRONG> needs to be compared with previous period record and create the calculated character field, <STRONG>stage_movement</STRONG>&nbsp;with message as shown in the data above.</P><P>&nbsp;</P><P>For example, IFRS_ID,X1 moved from <STRONG>credit rating stage 1 in previous period</STRONG> &nbsp;to stage 2 in current period and hence stage_movement got value as 'stage 1 to stage 2'.</P><P>same way, I would like to create caluated fields for <STRONG>ead</STRONG> and <STRONG>ecl</STRONG> differences from previous period.</P> Sat, 29 Apr 2017 07:34:59 GMT jithuzoom 2017-04-29T07:34:59Z https://communities.sas.com/t5/SAS-Visual-Analytics/how-to-do-sas-va-comparison-with-prev-period-and-derive-a-flag/m-p/354684#M7041 <TABLE><TBODY><TR><TD>ifrs_id</TD><TD>report_date</TD><TD>ead</TD><TD>ecl</TD><TD>period_id</TD><TD>crr_stage_identifier</TD><TD><U>stage_movement&nbsp;</U></TD></TR><TR><TD>X1</TD><TD>20161231</TD><TD>8</TD><TD>77</TD><TD>current period</TD><TD>2</TD><TD>stage 1 to stage 2</TD></TR><TR><TD>X2</TD><TD>20161231</TD><TD>6</TD><TD>55</TD><TD>current period</TD><TD>1</TD><TD>stage 3 to stage 1</TD></TR><TR><TD>X1</TD><TD>20161130</TD><TD>6</TD><TD>45</TD><TD>previous period</TD><TD>1</TD><TD>&nbsp;</TD></TR><TR><TD>X2</TD><TD>20161130</TD><TD>4</TD><TD>34</TD><TD>previous period</TD><TD>3</TD><TD>&nbsp;</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Hi folks,</P><P>&nbsp;</P><P>I have all historial reords in a single lasr dataset as shown above ;I also got <STRONG>period_id</STRONG> to show period data in addtion to report_date.The <STRONG>credit rating field (crr_stage_identifier</STRONG>),<STRONG>a numeric item</STRONG> needs to be compared with previous period record and create the calculated character field, <STRONG>stage_movement</STRONG>&nbsp;with message as shown in the data above.</P><P>&nbsp;</P><P>For example, IFRS_ID,X1 moved from <STRONG>credit rating stage 1 in previous period</STRONG> &nbsp;to stage 2 in current period and hence stage_movement got value as 'stage 1 to stage 2'.</P><P>same way, I would like to create caluated fields for <STRONG>ead</STRONG> and <STRONG>ecl</STRONG> differences from previous period.</P> Sat, 29 Apr 2017 07:34:59 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/how-to-do-sas-va-comparison-with-prev-period-and-derive-a-flag/m-p/354684#M7041 jithuzoom 2017-04-29T07:34:59Z https://communities.sas.com/t5/SAS-Visual-Analytics/how-to-do-sas-va-comparison-with-prev-period-and-derive-a-flag/m-p/358947#M7181 <P>I think the fastes and easiest way is to do some dataprep in a data step before you load the data into VA.</P> <P>Then you can handle for example time gaps and other "defects" in your data.</P> <P>With retain and firs/last you will get full control <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P> <P>//Fredrik</P> Tue, 16 May 2017 08:15:50 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/how-to-do-sas-va-comparison-with-prev-period-and-derive-a-flag/m-p/358947#M7181 FredrikE 2017-05-16T08:15:50Z