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.

[Astounding]

If I understand the question correctly, you can use:

data want;
set have;
if questions='Total Score' then
Total_Score = scores;
run;

[ydathamaharushi]

Not, I mean by addition/cumulative method - I need the all question scores in new variable under total score observation and it has to be match with the total score of the same, but not with directly assigning.

Thanks !

[Astounding]

You will need to explain what the program should count, to get the totals in your example.