04-27-2016 08:38 PM
I am trying to add four variables to create a score for each person and then create a new variable that has two categories: Engaged (>1 score) and not engaged (<=1). How would I go bout this or does anyone recommend a website or book to look at?
04-27-2016 08:57 PM
Without knowing anything about your data or the rules you're trying to implement all we can kind of do is point you towards a tutorial.
In general, it's good to post what you have and what you want, we can help with the getting from A to B
04-27-2016 09:04 PM
I am looking at engagement in regards to returning ASQs. I have ASQ2, ASQ4, ASQ8, and ASQ12. I want to add the ASQs to create a score for each person and then create a new variable that has two categories: Engagement (>1 score) and not engaged (<=1).
04-27-2016 09:32 PM - edited 04-27-2016 09:32 PM
Once you have the ASQs variable created as per your previous post. Please use the sum funtion as below to get the sum of the ASQs to create a score variable
scoren=sum(of ASQ2-ASQ12); if scoren>1 then score='>1 '; else if scoren<=1 then score='<=1';
04-27-2016 10:50 PM
You could create your score directly from the _2_MONTH_ASQ etc. variables. But assuming you need the ASQ2 etc. variables for some other purpose, your score could be
if sum(ASQ2, ASQ4, ASQ8, ASQ12) <= 1 then score = "Not engaged"; else score = "Engagement";
Note that if all ASQ2 etc. variables are missing, the score will be Not engaged.