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-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

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