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?
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.
http://www.ats.ucla.edu/stat/sas/modules/vars.htm
In general, it's good to post what you have and what you want, we can help with the getting from A to B 🙂
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).
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';
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.
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.