topic Re: How to create a new variable by adding the re-coded values 1-9 and then making a new binary vari in SAS Programming

How to create a new variable by adding the re-coded values 1-9 and then making a new binary variable

shridula95 — Wed, 22 Apr 2020 17:36:24 GMT

I am working on a 6 datasets and want to recode a particular variable from 1-9. Following this, I would like to create a new variable by adding up the values of the recoded variables. This variable is to be called K6SUM. Based on the K6SUM variable, I want to create a grouping variable called “SPD” as a binary variable. Any suggestions?

Thank you in advance:)

Re: How to create a new variable by adding the re-coded values 1-9 and then making a new binary vari

ballardw — Wed, 22 Apr 2020 17:40:31 GMT

Provide some example data and walk us through what you want.

How to create the recodes when we don't know the current variable type or values is pretty difficult.

Plus, since you are adding values of 1 through 9, apparently, then you can have sums all over place. So what would the rule be for creating a binary variable from those sums?

Re: How to create a new variable by adding the re-coded values 1-9 and then making a new binary vari

Reeza — Wed, 22 Apr 2020 18:02:20 GMT

You want to use an array.

Check out the examples here:

https://stats.idre.ucla.edu/sas/seminars/sas-arrays/

Re: How to create a new variable by adding the re-coded values 1-9 and then making a new binary vari

shridula95 — Wed, 22 Apr 2020 18:48:33 GMT

I am working on NHIS data sets from 2010-2015. The variable is called Serious Psychological Disorder(SPD). It has data fields as follows-

SAD, NERVOUS, RESTLESS, HOPELESS, EFFORT, WORTHLS. These variables take on values from 1 through 9. The re-coding is to be done as follows-

1 - ALL of the time (recode as 4)
2 - MOST of the time (recode as 3)
3 - SOME of the time (recode as 2)
4 - A LITTLE of the time (recode as 1)
5 - NONE of the time (recode as 0)
7 – Refused (recode as missing)
8 - Not ascertained (recode as missing)
9 - Don't know (recode as missing)
Following this, I need to create a new variable called K6SUM by taking the sum of the re-coded values as specified above. Based on the K6SUM variable, I have to create a grouping variable called “Serous psychological distress” (SPD) as follows:
SPD = 1 IF K6SUM 13+
SPD = 0 IF K6SUM 0-12
SPD = . (MISSING). IF K6SUM=.(MISSING).