How to code a code on calculating scores from same observation in a ultimate way?

[ydathamaharushi]

Hi All, 

How we on calculate scores from same observation without calculating total scores observation and by creating a new var named as Total_Score which has to match with total_score observation under Scores var in a ultimate way and without changing the order of the var and its values.

Pt_Id	Questions	Scores	Visit	Total_Score
1	Limitations Of Activities	1	1
1	Moderate Activities	1	1
1	Climbing Several Flights Of Stairs	1	1
1	Bending, Kneeling, Or Stooping	1	1
1	Walking More Than A Mile	1	1
1	Walking Several Blocks	0	1
1	Pain	0	1
1	Total Score	6	1	6
1	Walking One Block	1	1
1	Limitations Of Activities	1	1
2	Moderate Activities	1	2
2	Climbing Several Flights Of Stairs	2	2
2	Bending, Kneeling, Or Stooping	2	2
2	Walking More Than A Mile	1	2
2	Walking Several Blocks	1	2
2	Pain	0	2
2	Total Score	8	2	8
2	Walking One Block	1	2

Much thanks for help.

[PeterClemmensen]

Welcome to the SAS Communities 🙂

Do you want this to be in a new data set or is it for reporting purposes?