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: Register Now

Registration is now open for SAS Innovate 2025 , our biggest and most exciting global event of the year! Join us in Orlando, FL, May 6-9.
Sign up by Dec. 31 to get the 2024 rate of just $495.
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
  • 2 replies
  • 1191 views
  • 0 likes
  • 2 in conversation