Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Start Period and End Period Calculation

Reply
Contributor
Posts: 25

Start Period and End Period Calculation

Hello gyys,

I want to create two variables Start_Period and End_Period like shown in below

Start_Period= End_Period (prev value for respective project)

End_Period = Start_Period + New_Cust - Cust_Left

 

What I have is Month Project New_Cust Cust_Left

 

what I need to do is Start_Period and End_Period

MonthProjectStart_PeriodNew_CustCust_LeftEnd_PeriodperiodCalc
11-Apra0131221090.201835
11-Maya1097085940.904255
11-Junb945570790.886076
11-Jula797963950.663158
11-Auga95154961530.627451
11-Sepb153185902480.362903
11-Octaa2481811033260.315951
11-Nova3261611143730.30563
11-Decs373231975070.191321
12-Jana507183866040.142384

 

 

Any help would be highly appriciated.

Thanks in advance.

Mac

Regular Contributor
Posts: 236

Re: Start Period and End Period Calculation

[ Edited ]

It seems you want to solve your assignment posting multiple questions.

 

Whats the problem are you facing to solve it. It's very straight forward calculation.

 

As a hint for start date.. read about retain or lag function.

Contributor
Posts: 25

Re: Start Period and End Period Calculation

Thanks RahulG,
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.
Ask a Question
Discussion stats
  • 2 replies
  • 190 views
  • 0 likes
  • 2 in conversation