topic Re: How to code a code on calculating scores from same observation in a ultimate way? in SAS Programming

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

ydathamaharushi — Wed, 19 Jun 2019 08:50:39 GMT

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.

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

Astounding — Wed, 19 Jun 2019 15:27:22 GMT

If I understand the question correctly, you can use:

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

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

ydathamaharushi — Thu, 20 Jun 2019 04:54:19 GMT

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 !

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

Astounding — Thu, 20 Jun 2019 05:53:50 GMT

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