A SAS macro to compute HUI summary and utility scores: An application to the Fit Blue study

Figures & data

Figure 1. Algorithm to compute the final scores for ambulation in HUI3. (Y = Yes, N = No, LVL = Level).

Table 1. HUI Test data. The first column represents participants and columns are their responses to the HUI questions (y = Yes, n = No).

id	Q1	Q2	Q3	Q4	Q5	Q6	Q7	Q8	Q9	Q10	Q11	Q12	Q13	Q14	Q15	Q16	Q17	Q18	Q19	Q20	Q21
001	y	-	-	y	-	y	-	-	-	-	y	-	-	-	-	y	-	-	-	-	-
002	n	y	-	n	y	y	-	-	-	-	y	-	-	-	-	y	-	-	-	-	-
003	y	-	-	y	-	n	y	-	y	-	y	-	-	-	-	y	-	-	-	-	-
004	y	-	-	y	-	y	-	-	-	-	n	y	y	-	-	y	-	-	-	-	-
005	y	-	-	y	-	y	-	-	-	-	y	-	-	-	-	n	n	y	-	-	-
006	y	-	-	y	-	y	-	-	-	-	y	-	-	-	-	n	y	-	-	-	-
007	y	-	-	y	-	y	-	-	-	-	y	-	-	-	-	n	y	-	-	-	-
008	y	-	-	y	-	y	-	-	-	-	y	-	-	-	-	n	y	-	-	-	-
009	y	-	-	y	-	y	-	-	-	-	y	-	-	-	-	n	y	-	-	-	-
010	y	-	-	n	y	n	y	-	y	-	n	y	y	-	-	n	n	y	-	-	-
011	n	y	-	n	n	n	y	-	n	y	n	y	n	y	-	n	n	n	y	y	n
012	n	n	y	y	-	n	n	y	y	-	n	n	n	y	-	n	n	n	y	y	n
013	n	n	y	n	n	n	n	y	n	y	n	y	n	n	y	n	n	n	y	y	y
014	n	n	n	-	-	n	n	n	-	-	n	n	n	n	n	n	n	n	n	-	-
015	y	-	-	n	n	n	y	-	y	-	y	-	-	-	-	n	n	y	-	-	-

Table 2. HUI Test data (continued). The first column represents participants and columns are their responses to the HUI questions (y = Yes, n = No, h = happy, u = unhappy).

id	Q22	Q23	Q24	Q25	Q26	Q27	Q28	Q29	Q30	Q31	Q32	Q33	Q34	Q35	Q36	Q37	Q38	Q39	Q40
001	-	-	y	-	-	-	y	-	-	h	a	-	y	ra	n	a	a	n	-
002	-	-	y	-	-	-	y	-	-	h	a	-	n	-	-	a	a	n	-
003	-	-	y	-	-	-	y	-	-	h	a	-	y	ra	n	a	a	n	-
004	-	-	y	-	-	-	y	-	-	h	a	-	n	-	-	a	a	n	-
005	-	-	y	-	-	-	y	-	-	h	a	-	y	ra	n	a	a	n	-
006	-	-	n	n	-	n	n	n	n	h	a	-	y	ra	n	a	a	n	-
007	-	-	y	-	-	-	y	-	-	h	b	-	y	oc	n	a	a	n	-
008	-	-	y	-	-	-	y	-	-	h	a	-	y	ra	n	b	a	n	-
009	-	-	y	-	-	-	y	-	-	h	a	-	y	ra	n	a	a	y	n
010	-	-	n	n	-	n	n	n	n	h	b	-	y	oc	n	a	b	y	n
011	n	y	n	n	-	y	n	n	n	u	-	a	y	of	n	b	a	y	f
012	y	n	n	y	s	y	n	n	y	u	-	b	y	aa	n	b	c	y	s
013	y	n	n	y	m	n	n	y	y	u	-	c	y	ra	y	c	d	y	m
014	n	y	n	y	a	y	n	y	n	u	-	c	y	oc	y	d	e	y	a
015	-	-	n	n	-	n	y	-	-	u	-	a	y	of	n	a	c	y	f
Abbreviations:
Q32	a) happy and interested in life, b) somewhat happy?
Q33	a) somewhat unhappy, b) very unhappy, c) so unhappy that life is not worthwhile
Q35	ra) Rarely, oc) Occasionally, of) Often, aa) Almost always, do) Don’t know, re) Refused
Q37	a) able to remember most things, b) somewhat forgetful, c) very forgetful, d) unable to remember anything at all
Q38	a) able to think clearly and solve problems, b) had a little difficulty, c) had some difficulty, d) had a great deal of difficulty, e) unable to think or solve problems
Q40	n) None, f) Afew, s) Some, m) Most, a) All

Table 3. An example of the output from SAS COMPARE procedure: Here comparing the HUI version and our version of the HUI2 domains from the test data

The COMPARE procedure

Comparison of WORK.TEST_HUI2_SCORES with WORK.ALLHUITESTDATA_SCORED

(Method = EXACT)

Data Set Summary

Dataset       Created    Modified   NVar   NObs

WORK.TEST_HUI2_SCORES 23JUN18:08:19:41 23JUN18:08:19:41 8 15

WORK.ALLHUITESTDATA_SCORED 23JUN18:08:19:41 23JUN18:08:19:41 120 15

Variables Summary

Number of Variables in Common: 8.

Number of Variables in WORK.ALLHUITESTDATA_SCORED but not in

WORK.TEST_HUI2_SCORES: 112.

Number of VAR Statement Variables: 7.

Number of WITH Statement Variables: 7.

Observation Summary

Observation Base Compare

First Obs 1 1

Last Obs 15 15

Number of Observations in Common: 15.

Total Number of Observations Read from WORK.TEST_HUI2_SCORES: 15.

Total Number of Observations Read from WORK.ALLHUITESTDATA_SCORED: 15.

Number of Observations with Some Compared Variables Unequal: 0.

Number of Observations with All Compared Variables Equal: 15.

NOTE: No unequal values were found. All values compared are exactly equal.

Table 4. Fit Blue Screening visit HUI data processed through the %HUI macro

	Screening visit
	N	Min	Median	Mean	SD	Max
HUI2 Sensation Score	354	1	1	1.2	0.5	3
HUI2 Mobility Score	354	1	1	1.1	0.3	2
HUI2 Emotion Score	345	1	1	1.3	0.7	5
HUI2 Cognition Score	355	1	1	1.3	0.5	3
HUI2 Self-Care Score	356	1	1	1	0.1	2
HUI2 Pain Score	355	1	1	1.7	0.9	5
HUI2 Fertility Score	357	1	1	1	0	1
HUI2 Sensation Single-Attribute Utility Score	354	0.7	1	1	0.1	1
HUI2 Mobility Single-Attribute Utility Score	354	0.9	1	1	0	1
HUI2 Emotion Single-Attribute Utility Score	345	0	1	0.9	0.1	1
HUI2 Cognition Single-Attribute Utility Score	355	0.7	1	1	0.1	1
HUI2 Self-Care Single-Attribute Utility Score	356	0.9	1	1	0	1
HUI2 Pain Single-Attribute Utility Score	355	0	1	0.9	0.1	1
HUI2 Fertility Single-Attribute Utility Score	357	1	1	1	0	1
HUI2 Sensation Multi-Attribute Utility Score	354	0.9	1	1	0	1
HUI2 Mobility Multi-Attribute Utility Score	354	1	1	1	0	1
HUI2 Emotion Multi-Attribute Utility Score	345	0.5	1	1	0.1	1
HUI2 Cognition Multi-Attribute Utility Score	355	0.9	1	1	0	1
HUI2 Self-Care Multi-Attribute Utility Score	356	1	1	1	0	1
HUI2 Pain Multi-Attribute Utility Score	355	0.4	1	0.9	0.1	1
HUI2 Fertility Multi-Attribute Utility Score	357	1	1	1	0	1
HUI2 Total Utility Score	334	0.3	0.9	0.9	0.1	1
HUI3 Vision Score	355	1	1	1.2	0.4	3
HUI3 Hearing Score	356	1	1	1	0.1	2
HUI3 Speech Score	356	1	1	1	0.1	2
HUI3 Ambulation Score	355	1	1	1	0.1	2
HUI3 Dexterity Score	356	1	1	1	0.1	2
HUI3 Emotion Score	349	1	1	1.2	0.5	4
HUI3 Cognition Score	355	1	1	1.6	1.1	5
HUI3 Pain Score	355	1	1	1.8	1	5
HUI3 Vision Single-Attribute Utility Score	355	0.7	1	1	0	1
HUI3 Hearing Single-Attribute Utility Score	356	0.9	1	1	0	1
HUI3 Speech Single-Attribute Utility Score	356	0.8	1	1	0	1
HUI3 Ambulation Single-Attribute Utility Score	355	0.8	1	1	0	1
HUI3 Dexterity Single-Attribute Utility Score	356	0.9	1	1	0	1
HUI3 Emotion Single-Attribute Utility Score	349	0.3	1	1	0.1	1
HUI3 Cognition Single-Attribute Utility Score	355	0.3	1	0.9	0.1	1
HUI3 Pain Single-Attribute Utility Score	355	0	1	0.9	0.2	1
HUI3 Vision Multi-Attribute Utility Score	355	0.9	1	1	0	1
HUI3 Hearing Multi-Attribute Utility Score	356	1	1	1	0	1
HUI3 Speech Multi-Attribute Utility Score	356	0.9	1	1	0	1
HUI3 Ambulation Multi-Attribute Utility Score	355	0.9	1	1	0	1
HUI3 Dexterity Multi-Attribute Utility Score	356	1	1	1	0	1
HUI3 Emotion Multi-Attribute Utility Score	349	0.6	1	1	0	1
HUI3 Cognition Multi-Attribute Utility Score	355	0.6	1	1	0.1	1
HUI3 Pain Multi-Attribute Utility Score	355	0.6	1	1	0.1	1
HUI3 Total Utility Score	339	0.1	0.9	0.9	0.2	1

Table

001y–y-y—-y—-y——-y—y–h a—y ran aan-

002ny-nyy—-y—-y——-y—y–h a—n—- aan-

003y–y-ny-y-y—-y——-y—y–h a—y ran aan-

004y–y-y—-nyy–y——-y—y–h a—n—- aan-

005y–y-y—-y—-nny—–y—y–h a—y ran aan-

006y–y-y—-y—-ny——nn-nnnnh a—y ran aan-

007y–y-y—-y—-ny——y—y–h b—y ocn aan-

008y–y-y—-y—-ny——y—y–h a—y ran ban-

009y–y-y—-y—-ny——y—y–h a—y ran aayn

010y–nyny-y-nyy–nny—–nn-nnnnh b—y ocn abyn

011ny-nnny-nynyny-nnnyynnynn-ynnnu—a y ofn bayf

012nnyy-nnyy-nnny-nnnyynynnysynnyu—b y aan bcys

013nnynnnnynynynnynnnyyyynnymnnyyu—c y ray cdym

014nnn–nnn–nnnnnnnnn–nynyaynynu—c y ocy deya

015y–nnny-y-y—-nny—–nn-ny–u—a y ofn acyf

Table

1	1	1	1	1	1	1	1	1
2	2	1	1	1	1	1	1	1
3	1	2	1	1	1	1	1	1
4	1	1	2	1	1	1	1	1
5	1	1	1	2	1	1	1	1
6	1	1	1	1	2	1	1	1
7	1	1	1	1	1	2	1	1
8	1	1	1	1	1	1	3	1
9	1	1	1	1	1	1	1	2
10	2	2	2	2	2	2	2	2
11	3	3	3	3	3	3	3	3
12	4	4	4	4	4	4	4	4
13	5	5	5	5	5	5	5	5
14	6	6	5	6	6	5	6	5
15	3	2	1	2	2	3	2	3

Table

1	1	1	1	1	1	1	1	1	1
2	0.95	1	1	1	1	1	1	1	0.97
3	1	0.86	1	1	1	1	1	1	0.93
4	1	1	0.82	1	1	1	1	1	0.92
5	1	1	1	0.83	1	1	1	1	0.9
6	1	1	1	1	0.88	1	1	1	0.93
7	1	1	1	1	1	0.91	1	1	0.93
8	1	1	1	1	1	1	0.92	1	0.93
9	1	1	1	1	1	1	1	0.92	0.95
10	0.95	0.86	0.82	0.83	0.88	0.91	0.86	0.92	0.52
11	0.73	0.71	0.67	0.67	0.73	0.73	0.92	0.77	0.16
12	0.59	0.48	0.41	0.36	0.45	0.33	0.7	0.48	−0.2
13	0.38	0.32	0	0.16	0.2	0	0.32	0	−0.34
14	0	0	0	0	0	0	0	0	−0.36
15	0.73	0.86	1	0.83	0.88	0.73	0.86	0.77	0.35

Table

1	1	1	1	1	1	1	1
2	2	1	1	1	1	1	1
3	2	1	1	1	1	1	1
4	3	1	1	1	1	1	1
5	1	2	1	1	1	1	1
6	1	2	1	1	2	1	1
7	1	2	2	1	1	1	1
8	1	2	1	2	1	1	1
9	1	2	1	1	1	2	1
10	3	2	2	2	2	2	1
11	3	3	3	2	2	3	1
12	3	3	4	2	3	3	1
13	4	4	5	3	4	4	1
14	4	5	5	4	4	5	1
15	3	2	3	2	1	3	1

Table

1	1	1	1	1	1	1	1	1
2	0.87	1	1	1	1	1	1	0.95
3	0.87	1	1	1	1	1	1	0.95
4	0.65	1	1	1	1	1	1	0.85
5	1	0.92	1	1	1	1	1	0.97
6	1	0.92	1	1	0.85	1	1	0.94
7	1	0.92	0.86	1	1	1	1	0.9
8	1	0.92	1	0.86	1	1	1	0.92
9	1	0.92	1	1	1	0.95	1	0.94
10	0.65	0.92	0.86	0.86	0.85	0.95	1	0.68
11	0.65	0.61	0.6	0.86	0.85	0.75	1	0.43
12	0.65	0.61	0.37	0.86	0.55	0.75	1	0.33
13	0	0.34	0	0.66	0	0.42	1	0.05
14	0	0	0	0	0	0	1	−0.02
15	0.65	0.92	0.6	0.86	1	0.75	1	0.52;