https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290722#M5020 <P>It seems you want to solve your assignment posting multiple questions.</P><P>&nbsp;</P><P>Whats the problem are you facing to solve it. It's very straight forward calculation.</P><P>&nbsp;</P><P>As a hint for start date.. read about retain or lag function.</P> Wed, 10 Aug 2016 14:43:53 GMT RahulG 2016-08-10T14:43:53Z https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290691#M5019 <P>Hello gyys,</P><P>I want to create two variables Start_Period and End_Period like shown in below</P><P>Start_Period= End_Period (prev value for respective project)</P><P>End_Period = Start_Period + New_Cust - Cust_Left</P><P>&nbsp;</P><P>What I have is Month Project New_Cust Cust_Left</P><P>&nbsp;</P><P>what I need to do is Start_Period and End_Period</P><TABLE border="0" cellpadding="0" cellspacing="0"><TBODY><TR><TD>Month</TD><TD>Project</TD><TD>Start_Period</TD><TD>New_Cust</TD><TD>Cust_Left</TD><TD>End_Period</TD><TD>periodCalc</TD></TR><TR><TD>11-Apr</TD><TD>a</TD><TD>0</TD><TD>131</TD><TD>22</TD><TD>109</TD><TD>0.201835</TD></TR><TR><TD>11-May</TD><TD>a</TD><TD>109</TD><TD>70</TD><TD>85</TD><TD>94</TD><TD>0.904255</TD></TR><TR><TD>11-Jun</TD><TD>b</TD><TD>94</TD><TD>55</TD><TD>70</TD><TD>79</TD><TD>0.886076</TD></TR><TR><TD>11-Jul</TD><TD>a</TD><TD>79</TD><TD>79</TD><TD>63</TD><TD>95</TD><TD>0.663158</TD></TR><TR><TD>11-Aug</TD><TD>a</TD><TD>95</TD><TD>154</TD><TD>96</TD><TD>153</TD><TD>0.627451</TD></TR><TR><TD>11-Sep</TD><TD>b</TD><TD>153</TD><TD>185</TD><TD>90</TD><TD>248</TD><TD>0.362903</TD></TR><TR><TD>11-Oct</TD><TD>aa</TD><TD>248</TD><TD>181</TD><TD>103</TD><TD>326</TD><TD>0.315951</TD></TR><TR><TD>11-Nov</TD><TD>a</TD><TD>326</TD><TD>161</TD><TD>114</TD><TD>373</TD><TD>0.30563</TD></TR><TR><TD>11-Dec</TD><TD>s</TD><TD>373</TD><TD>231</TD><TD>97</TD><TD>507</TD><TD>0.191321</TD></TR><TR><TD>12-Jan</TD><TD>a</TD><TD>507</TD><TD>183</TD><TD>86</TD><TD>604</TD><TD>0.142384</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>&nbsp;</P><P>Any help would be highly appriciated.</P><P>Thanks in advance.</P><P>Mac</P> Wed, 10 Aug 2016 12:31:35 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290691#M5019 makarand 2016-08-10T12:31:35Z https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290722#M5020 <P>It seems you want to solve your assignment posting multiple questions.</P><P>&nbsp;</P><P>Whats the problem are you facing to solve it. It's very straight forward calculation.</P><P>&nbsp;</P><P>As a hint for start date.. read about retain or lag function.</P> Wed, 10 Aug 2016 14:43:53 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290722#M5020 RahulG 2016-08-10T14:43:53Z https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290733#M5022 Thanks RahulG,<BR />but we don't have lag or retain function in VA.. so I'm not able to do it as you helped on other question. Wed, 10 Aug 2016 15:09:37 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Start-Period-and-End-Period-Calculation/m-p/290733#M5022 makarand 2016-08-10T15:09:37Z