Supplementary file 3 for “ Developing Australian utility value set for MacNew-7D heart disease-specific health states.” 

############################################################################################################################
######## --- Instructions for calculating MacNew 7D utility scores from MacNew 27 items questionnaire_STATA codes --- ######
############################################################################################################################


## --------------------- Data file -------------------------------------------------------------------------##
# Data file should be in .csv format in excel format.

## --------------------- Renaming variables ----------------------------------------------------------------##
# For this code to work, it is assumed that the MacNew questionnaire results are set up as 27 columns, labelled q_1 to q_27.
# Each of the columns can take one of seven values 1-7.
# Prepare the data file as in the instructions given above.
# import data file and save.

# Variables used in MacNew 7D : q_26, q_24, q_1, q_6, q_15, q_9, q_14
# Each item in the orginal 27 item MacNew scale consists of 7 level responses (level 1 worst to level 7 best). 
# During the development of MacNew 7D, levels 2,3 and 4 combined as "Some of the time" and levels 5 and 6 combined as `hardly any.


## ------------------Recode levels-------------------------------------------------------------------------##

# Variables used in MacNew 7D : q_26, q_24, q_1, q_6, q_15, q_9, q_14
# Each item in the orginal 27 item MacNew scale consists of 7 level responses (level 1 worst to level 7 best). 
# During the development of MacNew 7D, levels 2,3 and 4 combined as "Some of the time" and levels 5 and 6 combined as `hardly any.

recode q_26 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (physical_restriction)
recode q_24 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (excluded)
recode q_1 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (frustrated)
recode q_6 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (worn_out)
recode q_15 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (self_confidence)
recode q_9 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (shortness_of_breath)
recode q_14 (1=4) (2=3) (3=3) (4=3) (5=2) (6=2) (7=1), generate (chest_pain)



## ------------------Anchoring values for each attribute level based on Conditional logit model-----------##

gen physical_restriction_du=0
replace physical_restriction_du=0.000 if physical_restriction==1
replace physical_restriction_du=-0.1087 if physical_restriction==2
replace physical_restriction_du=-0.1232 if physical_restriction==3
replace physical_restriction_du=-0.3595 if physical_restriction==4

gen excluded_du=0
replace excluded_du=0.000 if excluded==1
replace excluded_du=-0.0972 if excluded==2
replace excluded_du=-0.1055 if excluded==3
replace excluded_du=-0.1875 if excluded==4

gen worn_out_du=0
replace worn_out_du=0.000 if worn_out==1
replace worn_out_du=-0.0143 if worn_out==2
replace worn_out_du=-0.0272 if worn_out==3
replace worn_out_du=-0.0272 if worn_out==4


gen frustrated_du=0
replace frustrated_du=0.000 if frustrated==1
replace frustrated_du=-0.0337 if frustrated==2
replace frustrated_du=-0.0578 if frustrated==3
replace frustrated_du=-0.1727 if frustrated==4

gen self_confidence_du=0
replace self_confidence_du=0.000 if self_confidence==1
replace self_confidence_du=-0.000 if self_confidence==2
replace self_confidence_du=-0.0642 if self_confidence==3
replace self_confidence_du=-0.1119 if self_confidence==4

gen shortness_of_breath_du=0
replace shortness_of_breath_du=0.000 if shortness_of_breath==1
replace shortness_of_breath_du=-0.0304 if shortness_of_breath==2
replace shortness_of_breath_du=-0.0751 if shortness_of_breath==3
replace shortness_of_breath_du=-0.2707 if shortness_of_breath==4

gen chest_pain_du=0
replace chest_pain_du=0.000 if chest_pain==1
replace chest_pain_du=-0.0485 if chest_pain==2
replace chest_pain_du=-0.1257 if chest_pain==3
replace chest_pain_du=-0.2821 if chest_pain==4


## ------------------MacNew 7D utility value------------------------------------------------------##

gen MacNew_7D_utlity = 1+(physical_restriction_du + excluded_du + frustrated_du + worn_out_du +
                                 self_confidence_du + shortness_of_breath_du + chest_pain_du)
# save the data file