Creating multiple variable

ARAJPUT_HENRY

Hello Everyone,

Can anyone help me get to the solution of the  data shown below-

I have around 250 variables that should be summed up to 90 variables. Example- A and B are variables that need to be built. A= A1+A2+A3, B= B1+B2+B3 . I know this can be easily done by formula tool but I have to make 90 variables like that. Any dynamic solution to sum up column A 1,2, 3,4 or 5 to variable named A , B1,2,3,4 or 5 to B and likewise to create 90 variables without writing code for each variable

Thank you !

A1	A2	A3	A4	B1	B2	B3
yes				yes	Tobacco	10/17/2022
no	Diabetes			no
yes		6years	Mild	yes
yes				yes		10/17/2022
no
no	Thyroid			no
no				no
no		2 years		no
yes	Sepsis			yes	Alcohol
yes
yes				yes
yes	Heart problem			yes
yes				yes

caltang

@ARAJPUT_HENRY like so:

For Arajput_Henry.yxmd