Example I am using the 2021 National Financial Capabilities Study Y2 is Financial Wellbeing. I define financial well-being using thequestions below. Responses 98 and 99 are I don't know & I prefer not to say. Q34 - How confident are you that you could come up with $2000 if an unexpected need arose with the next month? Responses: 1 - I am certain I could come up with the full $2000 to 4 - I am certain I could not come up with the $2000. 98 & 99 Q48 thru Q52 - How well do these statements describe your situation? Q48 - I feel like I will never have the things I want in life. Responses: 1 - Does not describe me at all; 2 - Describes me very little; 3 - describes me somewhat; 4 - describes me very well; 5 - describes me completely; 98 & 99 Q49 - I am just getting by financially. Responses: 1 - Does not describe me at all; 2 - Describes me very little; 3 - describes me somewhat; 4 - describes me very well; 5 - describes me completely; 98 & 99 Q50 - I am concerned that the money I have or will save won't last. Responses: 1 - Does not describe me at all; 2 - Describes me very little; 3 - describes me somewhat; 4 - describes me very well; 5 - describes me completely; 98 & 99 Q51 - How oftend do these statements apply to you? I have money left over at the end of the month. Responses: 1 Never; 2 Rarely; 3 Sometimes; 4 Often; 5 Always; 98 & 99 Q52 - How oftend do these statements apply to you? My finances control my life. Responses: 1 Never; 2 Rarely; 3 Sometimes; 4 Often; 5 Always; 98 & 99 In SAS Enterprise, I was able to create the variable "Well-being" by identifying the data variable responses (I have labled the columns using the question number in the code book). The database is coded to provide a numeric value for each excluding responses 98 & 99. I put the question to GPChat and it suggested using catx. Programming looks like this: /* Using CATX function */ data new_dataset; set existing_dataset; new_variable = catx(' ', var1, var2, var3); /* Space delimiter, trims spaces */ run; Does this look right? If i am reading this correctly, the new category or label would be "Wellbeing" with an over all score of the numeric values for each respondent. Thank you for responding.
... View more