I have a sample data set to make it easy for you to look and know how the data looks like. The data has 3 fields 1.clientid 2.Date 3.Balances. The real data has information for the period July 2011-july2012, meaning Client balances data for the 13 months July 2011-july2012.
I want to calculate for clients who have a relationship<1 year (/*so should we first take clients whose balances do not run for full 12 months or 365 days*/- comment) with the bank,
Problem 1:Then for the clients who have relationship<1year, i want to do the following calculation.
Step3..step1/step2=core
step2.plug the value calculated in step1 into the blank data points between 2 dates
Can't see sample data...
I see you are a Newbee. Suggestion: Select a forum, appropriate for your request, before selecting "start a discussion". That helps the responders with organization and time management. I would think both of these would go in either of the first two forums.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.