Hello,

For my PhD project, I am going to create a three category positive mental health (PMH) (Languishing, Moderate, and Flourishing) variable based on the short form of PHM scale developed by Corey Keyes. The scale contains 14 items are measured using 5 point Likert Scale as follows:

never=0,

once or twice=1,

about once a week=2,

about 2 or 3 times a week=3,

almost every day=4,

every day=5

The condition for creating the three-category PMH variable is

Flourishing requires a response of “almost every day” or “every day” to 1 or more of the 3 emotional well-being questions (first three items), and to 6 or more of the 11 positive functioning questions.

Languishing requires a response of “once or twice” or “never” to 1 or more of the 3 emotional well-being questions, and to 6 or more of the 11 positive functioning questions.

Moderate mental health refers to those who are neither flourishing or languishing.

I have been searching for the code for constructing this variable using STATA.

I have found the following code for SPSS. However replicate the count section of the code. I can replicate all the remaining codes:

count hiaff=mhc1 mhc2 mhc3(4,5).

count loaff=mhc1 mhc2 mhc3(0,1).

count hifunc=mhc4 mhc5 mhc6 mhc7 mhc8 mhc9 mhc10 mhc11 mhc12 mhc13 mhc14(4,5). count lofunc=mhc4 mhc5 mhc6 mhc7 mhc8 mhc9 mhc10 mhc11 mhc12 mhc13 mhc14(0,1). recode hiaff (1,2,3=1) (else=0) into hiaffect. recode hifunc (6,7,8,9,10,11=1) (else=0) into hifunct. recode loaff (1,2,3=1) (else=0) into loaffect. recode lofunc (6,7,8,9,10,11=1) (else=0) into lofunct. if hiaffect=1 and hifunct=1 mhc_dx=2. if loaffect=1 and lofunct=1 mhc_dx=0. if hiaffect=1 and hifunct=0 mhc_dx=1. if hiaffect=0 and hifunct=1 mhc_dx=1. if loaffect=0 and lofunct=1 mhc_dx=1. If loaffect=1 and lofunct=0 mhc_dx=1. variable labels mhc_dx 'MHC-SF Three Category Diagnosis of Positive Mental Health'. value labels mhc_dx 0 'Languishing' 1 'Moderate' 2 'Flourishing'.

I am not sure how to replicate the first four line of coding started with count in the STATA. I will appreciate if any of you help me out. It will be a great help for my PhD project.

Thank you in advance

Iqbal Chowdhury