New Contributor
Posts: 2

# Creating new variables

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?

Super User
Posts: 23,776

## Re: Creating new variables

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

New Contributor
Posts: 2

## Re: Creating new variables

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).

IF _2_MONTH_ASQ='Yes' THEN ASQ2=1;
ELSE IF _2_MONTH_ASQ='No' THEN ASQ2=0;
ELSE ASQ2=.;

IF _4_MONTH_ASQ='Yes' THEN ASQ4=1;
ELSE IF _4_MONTH_ASQ='No' THEN ASQ4=0;
ELSE ASQ4=.;

IF _8_MONTH_ASQ='Yes' THEN ASQ8=1;
ELSE IF _8_MONTH_ASQ='No' THEN ASQ8=0;
ELSE ASQ8=.;

IF _12_MONTH_ASQ='Yes' THEN ASQ12=1;
ELSE IF _12_MONTH_ASQ='No' THEN ASQ12=0;
ELSE ASQ12=.;
Posts: 1,147

## Re: Creating new variables

[ Edited ]

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';
``````

Thanks,
Jag
Posts: 5,541

## Re: Creating new variables

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.

PG
Discussion stats
• 4 replies
• 378 views
• 1 like
• 4 in conversation