BookmarkSubscribeRSS Feed
makarand
Obsidian | Level 7

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

2 REPLIES 2
RahulG
Barite | Level 11

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.

makarand
Obsidian | Level 7
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.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 2 replies
  • 1128 views
  • 0 likes
  • 2 in conversation