Your source example data does not include any A0 B0 C0 or D0 values. So where do they come from in the desired output?
You need to state your rules more explicitly. I cannot determine how A0 to A2 get 0.2 or A3 to A5 gets 0.2 or B3-B6 gets .03 as a "cumulative value".
We were adding observation A0, B0
It means if A1=0.1 it means A1 is completed
Means In range A0 to A1=0.1 is completed
we have to first define the A0 or B0 as an initial start range within the A1 to A4 or B1 to B5
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: