New counting variable for values in a specific range (i.e. 0-33)

HBSU — Mon, 01 Nov 2021 19:00:04 GMT

I need to create a new variable that categorizes survey responses (n=5 items, scored from 0-100) into three categories based on the number of responses that fall in a certain numerical range. I.e. if at least 3 scores fall into the 0-33 range, then the category in the new variable should equal L (where L means Languishing). If at least 3 scores fall into the 66-100, then the category in the new variable should equal F (where F means Flourishing). Else, new categorical variable should equal M (where M means Moderate).

The table below illustrates the type of data I'm working with.

ID	Var1	Var2	Var3	Var4	Var5
1	22	78	56	77	98
2	12	0	22	55	63
3	88	2	87	30	73
4	14	9	55	87	45
5	15	66	53	96	54

Re: New counting variable for values in a specific range (i.e. 0-33)

Reeza — Mon, 01 Nov 2021 19:09:23 GMT

Try the following:

if largest(3, of var1-var5) >= 66 then category = "F";
else if largest(3, of var1-var5) <= 33 then category = "L";
else category = "M";

topic Re: New counting variable for values in a specific range (i.e. 0-33) in SAS Programming

New counting variable for values in a specific range (i.e. 0-33)

Re: New counting variable for values in a specific range (i.e. 0-33)