topic Creating new variables in SAS Programming

Creating new variables

apatter3 — Thu, 28 Apr 2016 00:38:12 GMT

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?

Re: Creating new variables

Reeza — Thu, 28 Apr 2016 00:57:47 GMT

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 🙂

Re: Creating new variables

apatter3 — Thu, 28 Apr 2016 01:04:57 GMT

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=.;

Re: Creating new variables

Jagadishkatam — Thu, 28 Apr 2016 01:32:41 GMT

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

Re: Creating new variables

PGStats — Thu, 28 Apr 2016 02:50:44 GMT

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.