## 模块概览

Variable	original_vars	easylabel	1999-2000	2001-2002	2003-2004	2005-2006	2007-2008	2009-2010	2011-2012	2013-2014	2015-2016	2017-2018	2017-2020	2021-2023
Body Measures
JC_weight_kg	BMXWT	weight (kg)	9,197	9,825	9,529	9,847	9,631	10,162	9,243	9,723	9,445	8,580	14,075	8,754
JC_height_cm	BMXHT	standing height (cm)	8,464	9,363	8,690	8,962	8,873	9,420	8,615	9,067	8,769	8,016	13,157	8,499
JC_BMI_full	BMXWT, BMXHT	BMI: retain all decimal places	8,462	9,010	8,687	8,949	8,861	9,412	8,602	9,055	8,756	8,005	13,137	8,471
JC_BMI_2d	BMXBMI	BMI: rounded to two decimal places	8,462	9,010	8,687	8,949	8,861	9,412	8,602	9,055	8,756	8,005	13,137	8,471
JC_BMI_category	BMDBMIC	bmi category-children/youth							3,355	3,523	3,340		4,749	2,492
JC_recumbent_length_cm	BMXRECUM	recumbent length (cm)	1,081	1,352	1,230	1,356	1,194	1,206	1,079	1,065	1,073	894	1,470	454
JC_upper_leg_cm	BMXLEG	upper leg length (cm)	7,225	7,846	7,219	7,314	7,304	7,755	6,955	7,402	7,110	6,703	10,984	7,335
JC_upper_arm_cm	BMXARML	upper arm length (cm)	8,990	9,869	9,190	9,498	9,276	9,708	8,826	9,301	8,976	8,177	13,490	8,568
JC_head_circ_cm	BMXHEAD	head circumference (cm)	267	296	269	292	260	238	236	229	215	194	310	70
JC_arm_circ_cm	BMXARMC	arm circumference (cm)	8,985	9,868	9,187	9,494	9,281	9,699	8,826	9,301	8,976	8,173	13,484	8,562
JC_waist_circ_cm	BMXWAIST	waist circumference (cm)	8,284	9,056	8,397	8,672	8,538	8,973	8,204	8,661	8,313	7,601	12,574	8,190
JC_hip_circ_cm	BMXHIP	hip circumference (cm)										6,039	9,862	6,776
JC_maximal_calf_circ_cm	BMXCALF	maximal calf circumference (cm)	7,306	7,933	7,270	7,386
JC_thigh_circ_cm	BMXTHICR	thigh circumference (cm)	7,198	7,804	7,194	7,295
JC_triceps_skinfold_mm	BMXTRI	triceps skinfold (mm)	8,568	9,432	8,586	8,897	8,944	9,358
JC_subscapular_skinfold_mm	BMXSUB	subscapular skinfold (mm)	7,950	8,553	8,065	8,110	8,213	8,776
JC_SAD_1st_cm	BMXSAD1	sagittal abdominal diameter 1st (cm)							6,795	7,218	6,983
JC_SAD_2nd_cm	BMXSAD2	sagittal abdominal diameter 2nd (cm)							6,795	7,218	6,983
JC_SAD_3rd_cm	BMXSAD3	sagittal abdominal diameter 3rd (cm)							398	358	353
JC_SAD_4th_cm	BMXSAD4	sagittal abdominal diameter 4th (cm)							398	358	353
JC_SAD_avg_cm	BMDAVSAD	average sagittal abdominal diameter (cm)							6,795	7,218	6,983
DXA Body Composition
JC_android_gynoid_status	DXXAGST	android/gynoid region status							5,683	6,026	5,776	5,112
JC_android_fat_mass	DXXANFM	android fat mass			6,235	5,589			4,694	5,425	5,090	4,052
JC_android_lean_mass	DXXANLM	android lean mass			6,235	5,589			4,694	5,425	5,090	4,052
JC_android_total_mass	DXXANTOM	android total mass			6,235	5,589			4,694	5,425	5,090	4,052
JC_gynoid_fat_mass	DXXGYFM	gynoid fat mass			6,235	5,589			4,696	5,426	5,094	4,059
JC_gynoid_lean_mass	DXXGYLM	gynoid lean mass			6,235	5,589			4,696	5,426	5,094	4,059
JC_gynoid_total_mass	DXXGYTOM	gynoid total mass			6,235	5,589			4,696	5,426	5,094	4,059
JC_android_gynoid_ratio	DXXAGRAT	android to gynoid ratio			6,235	5,589			4,691	5,417	5,085	4,048
JC_android_pct_fat	DXXAPFAT	android percent fat			6,235	5,589			4,694	5,425	5,090	4,052
JC_gynoid_pct_fat	DXXGPFAT	gynoid percent fat			6,235	5,589			4,696	5,426	5,094	4,059
JC_subcut_fat_area	DXXSATA	subcutaneous fat area							4,696	5,427	5,095	4,055
JC_subcut_fat_mass	DXXSATM	subcutaneous fat mass							4,696	5,427	5,095	4,055
JC_subcut_fat_vol	DXXSATV	subcutaneous fat volume							4,696	5,427	5,095	4,055
JC_total_abd_fat_area	DXXTATA	total abdominal fat area							4,696	5,427	5,095	4,055
JC_total_abd_fat_mass	DXXTATM	total abdominal fat mass							4,696	5,427	5,095	4,055
JC_total_abd_fat_vol	DXXTATV	total abdominal fat volume							4,696	5,427	5,095	4,055
JC_visceral_fat_area	DXXVFATA	visceral adipose tissue area							4,693	5,427	5,095	4,055
JC_visceral_fat_mass	DXXVFATM	visceral adipose tissue mass							4,693	5,427	5,095	4,055
JC_visceral_fat_vol	DXXVFATV	visceral adipose tissue volume							4,693	5,427	5,095	4,055
JC_head_area_cm2	DXXHEA	head area (cm^2)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_BMC_g	DXXHEBMC	head bone mineral content (g)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_BMD_g_cm2	DXXHEBMD	head bone mineral density (g/cm^2)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_fat_g	DXXHEFAT	head fat (g)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_lean_excl_BMC_g	DXDHELE	head lean excl bmc (g)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_lean_incl_BMC_g	DXXHELI	head lean incl bmc (g)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_total_g	DXDHETOT	head total (g)	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_head_pct_fat	DXDHEPF	head percent fat	5,878	7,621	7,291	6,469			4,725	5,379	4,979	4,072
JC_left_arm_area_cm2	DXXLAA	left arm area (cm^2)	5,878	7,621	7,291	6,469			4,682	5,347	4,977	4,095
JC_left_arm_BMC_g	DXXLABMC	left arm bmc (g)	5,878	7,621	7,291	6,469			4,682	5,347	4,977	4,095
JC_left_arm_BMD_g_cm2	DXXLABMD	left arm bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,682	5,347	4,977	4,095
JC_left_arm_lean_incl_BMC_g	DXXLALI	left arm lean incl bmc (g)	5,878	7,621	7,291	6,469			4,682	5,347	4,977	4,095
JC_left_arm_fat_g	DXXLAFAT	left arm fat (g)	5,878	7,621	7,291	6,469			4,671	5,348	4,985	4,081
JC_left_arm_lean_excl_BMC_g	DXDLALE	left arm lean excl bmc (g)	5,878	7,621	7,291	6,469			4,671	5,348	4,985	4,081
JC_left_arm_pct_fat	DXDLAPF	left arm percent fat	5,878	7,621	7,291	6,469			4,671	5,348	4,985	4,081
JC_right_arm_area_cm2	DXXRAA	right arm area (cm^2)	5,878	7,621	7,291	6,469			4,684	5,347	4,973	4,031
JC_right_arm_BMC_g	DXXRABMC	right arm bmc (g)	5,878	7,621	7,291	6,469			4,684	5,347	4,973	4,031
JC_right_arm_BMD_g_cm2	DXXRABMD	right arm bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,684	5,347	4,973	4,031
JC_right_arm_lean_incl_BMC_g	DXXRALI	right arm lean incl bmc (g)	5,878	7,621	7,291	6,469			4,684	5,347	4,973	4,031
JC_left_arm_total_g	DXDLATOT	left arm total (g)	5,878	7,621	7,291	6,469			4,669	5,347	4,955	4,055
JC_right_arm_fat_g	DXXRAFAT	right arm fat (g)	5,878	7,621	7,291	6,469			4,669	5,348	4,961	4,008
JC_right_arm_lean_excl_BMC_g	DXDRALE	right arm lean excl bmc (g)	5,878	7,621	7,291	6,469			4,669	5,348	4,961	4,008
JC_right_arm_pct_fat	DXDRAPF	right arm percent fat	5,878	7,621	7,291	6,469			4,669	5,348	4,961	4,008
JC_right_arm_total_g	DXDRATOT	right arm total (g)	5,878	7,621	7,291	6,469			4,668	5,347	4,926	3,981
JC_left_leg_area_cm2	DXXLLA	left leg area (cm^2)	5,878	7,621	7,291	6,469			4,658	5,299	4,862	4,019
JC_left_leg_BMC_g	DXXLLBMC	left leg bmc (g)	5,878	7,621	7,291	6,469			4,658	5,299	4,862	4,019
JC_left_leg_BMD_g_cm2	DXXLLBMD	left leg bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,658	5,299	4,862	4,019
JC_left_leg_lean_incl_BMC_g	DXXLLLI	left leg lean incl bmc (g)	5,878	7,621	7,291	6,469			4,658	5,299	4,862	4,019
JC_left_leg_fat_g	DXXLLFAT	left leg fat (g)	5,878	7,621	7,291	6,469			4,651	5,290	4,865	4,004
JC_left_leg_lean_excl_BMC_g	DXDLLLE	left leg lean excl bmc (g)	5,878	7,621	7,291	6,469			4,651	5,290	4,865	4,004
JC_left_leg_pct_fat	DXDLLPF	left leg percent fat	5,878	7,621	7,291	6,469			4,651	5,290	4,865	4,004
JC_right_leg_area_cm2	DXXRLA	right leg area (cm^2)	5,878	7,621	7,291	6,469			4,660	5,295	4,861	3,988
JC_right_leg_BMC_g	DXXRLBMC	right leg bmc (g)	5,878	7,621	7,291	6,469			4,660	5,295	4,861	3,988
JC_right_leg_BMD_g_cm2	DXXRLBMD	right leg bmd(g/cm^2)	5,878	7,621	7,291	6,469			4,660	5,295	4,861	3,988
JC_right_leg_lean_incl_BMC_g	DXXRLLI	right leg lean incl bmc (g)	5,878	7,621	7,291	6,469			4,660	5,295	4,861	3,988
JC_trunk_area_cm2	DXDTRA	trunk bone area (cm^2)	5,878	7,621	7,291	6,469			4,620	5,297	4,946	3,918
JC_trunk_BMD_g_cm2	DXDTRBMD	trunk bone bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,620	5,297	4,946	3,918
JC_left_ribs_area_cm2	DXXLRA	left ribs area (cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_left_ribs_BMC_g	DXXLRBMC	left ribs bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_left_ribs_BMD_g_cm2	DXXLRBMD	left ribs bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_right_ribs_area_cm2	DXXRRA	right ribs area (cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_right_ribs_BMC_g	DXXRRBMC	right ribs bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_right_ribs_BMD_g_cm2	DXXRRBMD	right ribs bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_thoracic_spine_area_cm2	DXXTSA	thoracic spine area (cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_thoracic_spine_BMC_g	DXXTSBMC	thoracic spine bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_thoracic_spine_BMD_g_cm2	DXXTSBMD	thoracic spine bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_lumbar_spine_area_cm2	DXXLSA	lumbar spine area (cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_lumbar_spine_BMC_g	DXXLSBMC	lumbar spine bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_lumbar_spine_BMD_g_cm2	DXXLSBMD	lumbar spine bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_pelvis_area_cm2	DXXPEA	pelvis area (cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_pelvis_BMC_g	DXXPEBMC	pelvis bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_pelvis_BMD_g_cm2	DXXPEBMD	pelvis bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_trunk_BMC_g	DXDTRBMC	trunk bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_trunk_lean_incl_BMC_g	DXXTRLI	trunk lean incl bmc (g)	5,878	7,621	7,291	6,469			4,620	5,294	4,946	3,912
JC_right_leg_fat_g	DXXRLFAT	right leg fat (g)	5,878	7,621	7,291	6,469			4,646	5,296	4,853	3,966
JC_right_leg_lean_excl_BMC_g	DXDRLLE	right leg lean excl bmc (g)	5,878	7,621	7,291	6,469			4,646	5,296	4,853	3,966
JC_right_leg_pct_fat	DXDRLPF	right leg percent fat	5,878	7,621	7,291	6,469			4,646	5,296	4,853	3,966
JC_trunk_fat_g	DXXTRFAT	trunk fat (g)	5,878	7,621	7,291	6,469			4,621	5,288	4,939	3,912
JC_trunk_lean_excl_BMC_g	DXDTRLE	trunk lean excl bmc (g)	5,878	7,621	7,291	6,469			4,621	5,288	4,939	3,912
JC_trunk_pct_fat	DXDTRPF	trunk percent fat	5,878	7,621	7,291	6,469			4,621	5,288	4,939	3,912
JC_left_leg_total_g	DXDLLTOT	left leg total (g)	5,878	7,621	7,291	6,469			4,649	5,289	4,836	3,981
JC_trunk_total_g	DXDTRTOT	trunk total (g)	5,878	7,621	7,291	6,469			4,618	5,288	4,938	3,903
JC_right_leg_total_g	DXDRLTOT	right leg total (g)	5,878	7,621	7,291	6,469			4,646	5,295	4,819	3,942
JC_subtotal_fat_g	DXDSTFAT	subtotal fat (g)	5,878	7,621	7,291	6,469			4,544	5,110	4,708	3,820
JC_subtotal_lean_excl_BMC_g	DXDSTLE	subtotal lean excl bmc (g)	5,878	7,621	7,291	6,469			4,544	5,110	4,708	3,820
JC_subtotal_total_excl_head_g	DXDSTTOT	subtotal (total excl head) (g)	5,878	7,621	7,291	6,469			4,544	5,110	4,708	3,820
JC_subtotal_pct_fat	DXDSTPF	subtotal percent fat	5,878	7,621	7,291	6,469			4,544	5,110	4,708	3,820
JC_total_lean_excl_BMC_g	DXDTOLE	total lean excl bmc (g)	5,878	7,621	7,291	6,469			4,544	5,110	4,708	3,820
JC_total_area_cm2	DXDTOA	total area (cm^2)	5,878	7,621	7,291	6,469			4,524	5,068	4,613	3,669
JC_total_BMC_g	DXDTOBMC	total bone mineral content (g)	5,878	7,621	7,291	6,469			4,524	5,068	4,613	3,669
JC_total_BMD_g_cm2	DXDTOBMD	total bone mineral density (g/cm^2)	5,878	7,621	7,291	6,469			4,524	5,068	4,613	3,669
JC_total_fat_g	DXDTOFAT	total fat (g)	5,878	7,621	7,291	6,469			4,521	5,056	4,598	3,658
JC_total_lean_incl_BMC_g	DXDTOLI	total lean incl bmc (g)	5,878	7,621	7,291	6,469			4,521	5,056	4,598	3,658
JC_total_lean_fat_g	DXDTOTOT	total lean+fat (g)	5,878	7,621	7,291	6,469			4,521	5,056	4,598	3,658
JC_total_pct_fat	DXDTOPF	total percent fat	5,878	7,621	7,291	6,469			4,521	5,056	4,598	3,658
JC_subtotal_area_cm2	DXDSTA	subtotal area (cm^2)	5,878	7,621	7,291	6,469			4,445	4,992	4,602	3,569
JC_subtotal_BMC_g	DXDSTBMC	subtotal bmc (g)	5,878	7,621	7,291	6,469			4,445	4,992	4,602	3,569
JC_subtotal_BMD_g_cm2	DXDSTBMD	subtotal bmd (g/cm^2)	5,878	7,621	7,291	6,469			4,445	4,992	4,602	3,569
JC_subtotal_lean_incl_BMC_g	DXDSTLI	subtotal lean incl bmc (g)	5,878	7,621	7,291	6,469			4,441	4,983	4,586	3,563

## 变量详情

Body Measures

JC_weight_kg

← BMXWT

weight (kg)

范围:
62.87 (2.4 ~ 371)

JC_height_cm

← BMXHT

standing height (cm)

范围:
156.42 (78.3 ~ 204.5)

JC_BMI_full

← BMXWT, BMXHT

BMI: retain all decimal places

范围:
25.77 (7.99 ~ 130.21)

JC_BMI_2d

← BMXBMI

BMI: rounded to two decimal places

范围:
25.77 (7.99 ~ 130.21)

JC_BMI_category

← BMDBMIC

bmi category-children/youth

类别分布:

10646	61%	normal weight
3438	19.7%	obese
2776	15.9%	overweight
599	3.4%	underweight

JC_recumbent_length_cm

← BMXRECUM

recumbent length (cm)

范围:
81.36 (44.3 ~ 118.8)

JC_upper_leg_cm

← BMXLEG

upper leg length (cm)

范围:
38.75 (20.4 ~ 55.5)

JC_upper_arm_cm

← BMXARML

upper arm length (cm)

范围:
33.27 (9 ~ 49.9)

JC_head_circ_cm

← BMXHEAD

head circumference (cm)

范围:
41.38 (15.5 ~ 50.2)

JC_arm_circ_cm

← BMXARMC

arm circumference (cm)

范围:
28.6 (9.6 ~ 64.5)

JC_waist_circ_cm

← BMXWAIST

waist circumference (cm)

范围:
87.44 (32 ~ 187.5)

JC_hip_circ_cm

← BMXHIP

hip circumference (cm)

范围:
105.75 (62.5 ~ 187.5)

JC_maximal_calf_circ_cm

← BMXCALF

maximal calf circumference (cm)

范围:
36.94 (17.5 ~ 75.6)

JC_thigh_circ_cm

← BMXTHICR

thigh circumference (cm)

范围:
51.35 (25.1 ~ 100)

JC_triceps_skinfold_mm

← BMXTRI

triceps skinfold (mm)

范围:
16.31 (1.4 ~ 45)

JC_subscapular_skinfold_mm

← BMXSUB

subscapular skinfold (mm)

范围:
15.48 (2.2 ~ 44)

JC_SAD_1st_cm

← BMXSAD1

sagittal abdominal diameter 1st (cm)

范围:
21.14 (9.5 ~ 40.7)

JC_SAD_2nd_cm

← BMXSAD2

sagittal abdominal diameter 2nd (cm)

范围:
21.13 (9.7 ~ 40.9)

JC_SAD_3rd_cm

← BMXSAD3

sagittal abdominal diameter 3rd (cm)

范围:
22.38 (10.9 ~ 39.5)

JC_SAD_4th_cm

← BMXSAD4

sagittal abdominal diameter 4th (cm)

范围:
22.38 (11 ~ 39.8)

JC_SAD_avg_cm

← BMDAVSAD

average sagittal abdominal diameter (cm)

范围:
21.15 (9.6 ~ 40.8)

DXA Body Composition

JC_android_gynoid_status

← DXXAGST

android/gynoid region status

类别分布:

19239	85.1%	scan completed, android/gynoid region is valid
2925	12.9%	scan not completed
433	1.9%	scan completed, android/gynoid region is invalid

JC_android_fat_mass

← DXXANFM

android fat mass

范围:
1920.33 (102.9 ~ 10626.5)

JC_android_lean_mass

← DXXANLM

android lean mass

范围:
3461.24 (636.7 ~ 10793.8)

JC_android_total_mass

← DXXANTOM

android total mass

范围:
5381.57 (785.8 ~ 19994.4)

JC_gynoid_fat_mass

← DXXGYFM

gynoid fat mass

范围:
3936.68 (436 ~ 16843.6)

JC_gynoid_lean_mass

← DXXGYLM

gynoid lean mass

范围:
7280.43 (1223.5 ~ 18544.4)

JC_gynoid_total_mass

← DXXGYTOM

gynoid total mass

范围:
11217.12 (1852.5 ~ 31090.2)

JC_android_gynoid_ratio

← DXXAGRAT

android to gynoid ratio

范围:
0.95 (0.4 ~ 2)

JC_android_pct_fat

← DXXAPFAT

android percent fat

范围:
32.75 (6.6 ~ 60.4)

JC_gynoid_pct_fat

← DXXGPFAT

gynoid percent fat

范围:
34.43 (7.7 ~ 61.9)

JC_subcut_fat_area

← DXXSATA

subcutaneous fat area

范围:
290.04 (17.84 ~ 1139.58)

JC_subcut_fat_mass

← DXXSATM

subcutaneous fat mass

范围:
1398.38 (85.99 ~ 5494.25)

JC_subcut_fat_vol

← DXXSATV

subcutaneous fat volume

范围:
1511.76 (92.96 ~ 5939.73)

JC_total_abd_fat_area

← DXXTATA

total abdominal fat area

范围:
371.35 (38.75 ~ 1229.87)

JC_total_abd_fat_mass

← DXXTATM

total abdominal fat mass

范围:
1790.38 (186.81 ~ 5929.55)

JC_total_abd_fat_vol

← DXXTATV

total abdominal fat volume

范围:
1935.55 (201.95 ~ 6410.33)

JC_visceral_fat_area

← DXXVFATA

visceral adipose tissue area

范围:
81.32 (0 ~ 415.6)

JC_visceral_fat_mass

← DXXVFATM

visceral adipose tissue mass

范围:
392.06 (0 ~ 2003.75)

JC_visceral_fat_vol

← DXXVFATV

visceral adipose tissue volume

范围:
423.85 (0 ~ 2166.22)

JC_head_area_cm2

← DXXHEA

head area (cm^2)

范围:
224.63 (152.95 ~ 336.95)

JC_head_BMC_g

← DXXHEBMC

head bone mineral content (g)

范围:
456.31 (168.37 ~ 1202.39)

JC_head_BMD_g_cm2

← DXXHEBMD

head bone mineral density (g/cm^2)

范围:
2.03 (0.84 ~ 4.85)

JC_head_fat_g

← DXXHEFAT

head fat (g)

范围:
1121.97 (615.6 ~ 3007)

JC_head_lean_excl_BMC_g

← DXDHELE

head lean excl bmc (g)

范围:
3090.48 (1705 ~ 6839.4)

JC_head_lean_incl_BMC_g

← DXXHELI

head lean incl bmc (g)

范围:
3546.8 (1929.6 ~ 7492.4)

JC_head_total_g

← DXDHETOT

head total (g)

范围:
4668.78 (2545.2 ~ 10135.8)

JC_head_pct_fat

← DXDHEPF

head percent fat

范围:
24.01 (20.5 ~ 32)

JC_left_arm_area_cm2

← DXXLAA

left arm area (cm^2)

范围:
210.47 (51.97 ~ 419.43)

JC_left_arm_BMC_g

← DXXLABMC

left arm bmc (g)

范围:
160.48 (25.39 ~ 472.84)

JC_left_arm_BMD_g_cm2

← DXXLABMD

left arm bmd (g/cm^2)

范围:
0.74 (0.31 ~ 2.33)

JC_left_arm_lean_incl_BMC_g

← DXXLALI

left arm lean incl bmc (g)

范围:
2812.79 (521.9 ~ 9664.4)

JC_left_arm_fat_g

← DXXLAFAT

left arm fat (g)

范围:
1447.56 (78.4 ~ 7951.4)

JC_left_arm_lean_excl_BMC_g

← DXDLALE

left arm lean excl bmc (g)

范围:
2652.94 (485.2 ~ 9229.4)

JC_left_arm_pct_fat

← DXDLAPF

left arm percent fat

范围:
33.37 (7.8 ~ 70)

JC_right_arm_area_cm2

← DXXRAA

right arm area (cm^2)

范围:
215.06 (57.2 ~ 404.91)

JC_right_arm_BMC_g

← DXXRABMC

right arm bmc (g)

范围:
168.57 (28.67 ~ 472.09)

JC_right_arm_BMD_g_cm2

← DXXRABMD

right arm bmd (g/cm^2)

范围:
0.76 (0.3 ~ 1.75)

JC_right_arm_lean_incl_BMC_g

← DXXRALI

right arm lean incl bmc (g)

范围:
2960.28 (633 ~ 9466.4)

JC_left_arm_total_g

← DXDLATOT

left arm total (g)

范围:
4258.64 (829.2 ~ 15770.4)

JC_right_arm_fat_g

← DXXRAFAT

right arm fat (g)

范围:
1478.02 (120.5 ~ 8427.9)

JC_right_arm_lean_excl_BMC_g

← DXDRALE

right arm lean excl bmc (g)

范围:
2791.71 (597.5 ~ 9004.1)

JC_right_arm_pct_fat

← DXDRAPF

right arm percent fat

范围:
32.69 (8.2 ~ 68.1)

JC_right_arm_total_g

← DXDRATOT

right arm total (g)

范围:
4435.84 (914.4 ~ 15433)

JC_left_leg_area_cm2

← DXXLLA

left leg area (cm^2)

范围:
353.54 (68.42 ~ 719.78)

JC_left_leg_BMC_g

← DXXLLBMC

left leg bmc (g)

范围:
409.86 (57.25 ~ 1165.85)

JC_left_leg_BMD_g_cm2

← DXXLLBMD

left leg bmd (g/cm^2)

范围:
1.13 (0.47 ~ 2.9)

JC_left_leg_lean_incl_BMC_g

← DXXLLLI

left leg lean incl bmc (g)

范围:
7886.56 (1518.2 ~ 26735.5)

JC_left_leg_fat_g

← DXXLLFAT

left leg fat (g)

范围:
4351.4 (428.4 ~ 21616.5)

JC_left_leg_lean_excl_BMC_g

← DXDLLLE

left leg lean excl bmc (g)

范围:
7474.22 (1431.2 ~ 25584.4)

JC_left_leg_pct_fat

← DXDLLPF

left leg percent fat

范围:
34.85 (4.3 ~ 66.7)

JC_right_leg_area_cm2

← DXXRLA

right leg area (cm^2)

范围:
353.29 (61.62 ~ 715.23)

JC_right_leg_BMC_g

← DXXRLBMC

right leg bmc (g)

范围:
412.27 (46.03 ~ 1182.09)

JC_right_leg_BMD_g_cm2

← DXXRLBMD

right leg bmd(g/cm^2)

范围:
1.14 (0.47 ~ 2.91)

JC_right_leg_lean_incl_BMC_g

← DXXRLLI

right leg lean incl bmc (g)

范围:
8034.05 (1551.5 ~ 26697.1)

JC_trunk_area_cm2

← DXDTRA

trunk bone area (cm^2)

范围:
614.74 (239.21 ~ 1174.49)

JC_trunk_BMD_g_cm2

← DXDTRBMD

trunk bone bmd (g/cm^2)

范围:
0.88 (0.42 ~ 2.14)

JC_left_ribs_area_cm2

← DXXLRA

left ribs area (cm^2)

范围:
119.14 (31.49 ~ 267.79)

JC_left_ribs_BMC_g

← DXXLRBMC

left ribs bmc (g)

范围:
77.84 (12.98 ~ 286.1)

JC_left_ribs_BMD_g_cm2

← DXXLRBMD

left ribs bmd (g/cm^2)

范围:
0.64 (0.32 ~ 1.28)

JC_right_ribs_area_cm2

← DXXRRA

right ribs area (cm^2)

范围:
123.09 (32.23 ~ 293.54)

JC_right_ribs_BMC_g

← DXXRRBMC

right ribs bmc (g)

范围:
80.1 (13.22 ~ 299.22)

JC_right_ribs_BMD_g_cm2

← DXXRRBMD

right ribs bmd (g/cm^2)

范围:
0.64 (0.31 ~ 1.41)

JC_thoracic_spine_area_cm2

← DXXTSA

thoracic spine area (cm^2)

范围:
132.25 (19.13 ~ 283.14)

JC_thoracic_spine_BMC_g

← DXXTSBMC

thoracic spine bmc (g)

范围:
108.82 (8.16 ~ 334.96)

JC_thoracic_spine_BMD_g_cm2

← DXXTSBMD

thoracic spine bmd (g/cm^2)

范围:
0.8 (0.33 ~ 1.93)

JC_lumbar_spine_area_cm2

← DXXLSA

lumbar spine area (cm^2)

范围:
50.9 (8.39 ~ 184.51)

JC_lumbar_spine_BMC_g

← DXXLSBMC

lumbar spine bmc (g)

范围:
51.29 (4.77 ~ 204.1)

JC_lumbar_spine_BMD_g_cm2

← DXXLSBMD

lumbar spine bmd (g/cm^2)

范围:
0.98 (0.44 ~ 2.56)

JC_pelvis_area_cm2

← DXXPEA

pelvis area (cm^2)

范围:
189.37 (30.01 ~ 417.32)

JC_pelvis_BMC_g

← DXXPEBMC

pelvis bmc (g)

范围:
234.93 (22.48 ~ 1203.21)

JC_pelvis_BMD_g_cm2

← DXXPEBMD

pelvis bmd (g/cm^2)

范围:
1.21 (0.49 ~ 3.04)

JC_trunk_BMC_g

← DXDTRBMC

trunk bmc (g)

范围:
552.98 (113.06 ~ 2000.33)

JC_trunk_lean_incl_BMC_g

← DXXTRLI

trunk lean incl bmc (g)

范围:
23357.14 (5455.3 ~ 62139.5)

JC_right_leg_fat_g

← DXXRLFAT

right leg fat (g)

范围:
4457.57 (497.7 ~ 21616.5)

JC_right_leg_lean_excl_BMC_g

← DXDRLLE

right leg lean excl bmc (g)

范围:
7620.01 (1465.6 ~ 25567.2)

JC_right_leg_pct_fat

← DXDRLPF

right leg percent fat

范围:
34.94 (5.8 ~ 68.4)

JC_trunk_fat_g

← DXXTRFAT

trunk fat (g)

范围:
11265.86 (742.8 ~ 53637.4)

JC_trunk_lean_excl_BMC_g

← DXDTRLE

trunk lean excl bmc (g)

范围:
22798.31 (5327.8 ~ 60139.2)

JC_trunk_pct_fat

← DXDTRPF

trunk percent fat

范围:
30.44 (6 ~ 58.5)

JC_left_leg_total_g

← DXDLLTOT

left leg total (g)

范围:
12230.78 (2402.5 ~ 41149.3)

JC_trunk_total_g

← DXDTRTOT

trunk total (g)

范围:
34614.95 (6911.6 ~ 108660.3)

JC_right_leg_total_g

← DXDRLTOT

right leg total (g)

范围:
12483.69 (2528.2 ~ 41428.7)

JC_subtotal_fat_g

← DXDSTFAT

subtotal fat (g)

范围:
22918.62 (2380.8 ~ 106978.7)

JC_subtotal_lean_excl_BMC_g

← DXDSTLE

subtotal lean excl bmc (g)

范围:
43162.84 (9407.6 ~ 128824.4)

JC_subtotal_total_excl_head_g

← DXDSTTOT

subtotal (total excl head) (g)

范围:
67782.08 (14216.3 ~ 220496)

JC_subtotal_pct_fat

← DXDSTPF

subtotal percent fat

范围:
32.58 (8.7 ~ 59.3)

JC_total_lean_excl_BMC_g

← DXDTOLE

total lean excl bmc (g)

范围:
46246.69 (11594.7 ~ 133745.3)

JC_total_area_cm2

← DXDTOA

total area (cm^2)

范围:
1968.65 (763.65 ~ 3502.93)

JC_total_BMC_g

← DXDTOBMC

total bone mineral content (g)

范围:
2156.49 (582.91 ~ 5961.94)

JC_total_BMD_g_cm2

← DXDTOBMD

total bone mineral density (g/cm^2)

范围:
1.07 (0.55 ~ 2.26)

JC_total_fat_g

← DXDTOFAT

total fat (g)

范围:
24008.49 (3197.1 ~ 108823.2)

JC_total_lean_incl_BMC_g

← DXDTOLI

total lean incl bmc (g)

范围:
48404.56 (12177.6 ~ 139707.2)

JC_total_lean_fat_g

← DXDTOTOT

total lean+fat (g)

范围:
72413.05 (17092.9 ~ 227962.8)

JC_total_pct_fat

← DXDTOPF

total percent fat

范围:
32.03 (9.7 ~ 58.1)

JC_subtotal_area_cm2

← DXDSTA

subtotal area (cm^2)

范围:
1743.21 (585.59 ~ 3237.16)

JC_subtotal_BMC_g

← DXDSTBMC

subtotal bmc (g)

范围:
1700.26 (351.21 ~ 5216.53)

JC_subtotal_BMD_g_cm2

← DXDSTBMD

subtotal bmd (g/cm^2)

范围:
0.95 (0.42 ~ 1.98)

JC_subtotal_lean_incl_BMC_g

← DXDSTLI

subtotal lean incl bmc (g)

范围:
44818.75 (9772.6 ~ 134040.9)

## 材料 ### 1-提取变量

BMXWT=JC_weight_kg, BMXHT=JC_height_cm, BMXBMI=JC_BMI_2d, BMDBMIC=JC_BMI_category, BMXRECUM=JC_recumbent_length_cm, BMXLEG=JC_upper_leg_cm, BMXARML=JC_upper_arm_cm, BMXHEAD=JC_head_circ_cm, BMXARMC=JC_arm_circ_cm, BMXWAIST=JC_waist_circ_cm, BMXHIP=JC_hip_circ_cm, BMXCALF=JC_maximal_calf_circ_cm, BMXTHICR=JC_thigh_circ_cm, BMXTRI=JC_triceps_skinfold_mm, BMXSUB=JC_subscapular_skinfold_mm, BMXSAD1=JC_SAD_1st_cm, BMXSAD2=JC_SAD_2nd_cm, BMXSAD3=JC_SAD_3rd_cm, BMXSAD4=JC_SAD_4th_cm, BMDAVSAD=JC_SAD_avg_cm, DXXAGST=JC_android_gynoid_status, DXXANFM=JC_android_fat_mass, DXXANLM=JC_android_lean_mass, DXXANTOM=JC_android_total_mass, DXXGYFM=JC_gynoid_fat_mass, DXXGYLM=JC_gynoid_lean_mass, DXXGYTOM=JC_gynoid_total_mass, DXXAGRAT=JC_android_gynoid_ratio, DXXAPFAT=JC_android_pct_fat, DXXGPFAT=JC_gynoid_pct_fat, DXXSATA=JC_subcut_fat_area, DXXSATM=JC_subcut_fat_mass, DXXSATV=JC_subcut_fat_vol, DXXTATA=JC_total_abd_fat_area, DXXTATM=JC_total_abd_fat_mass, DXXTATV=JC_total_abd_fat_vol, DXXVFATA=JC_visceral_fat_area, DXXVFATM=JC_visceral_fat_mass, DXXVFATV=JC_visceral_fat_vol, DXXHEA=JC_head_area_cm2, DXXHEBMC=JC_head_BMC_g, DXXHEBMD=JC_head_BMD_g_cm2, DXXHEFAT=JC_head_fat_g, DXDHELE=JC_head_lean_excl_BMC_g, DXXHELI=JC_head_lean_incl_BMC_g, DXDHETOT=JC_head_total_g, DXDHEPF=JC_head_pct_fat, DXXLAA=JC_left_arm_area_cm2, DXXLABMC=JC_left_arm_BMC_g, DXXLABMD=JC_left_arm_BMD_g_cm2, DXXLALI=JC_left_arm_lean_incl_BMC_g, DXXLAFAT=JC_left_arm_fat_g, DXDLALE=JC_left_arm_lean_excl_BMC_g, DXDLAPF=JC_left_arm_pct_fat, DXXRAA=JC_right_arm_area_cm2, DXXRABMC=JC_right_arm_BMC_g, DXXRABMD=JC_right_arm_BMD_g_cm2, DXXRALI=JC_right_arm_lean_incl_BMC_g, DXDLATOT=JC_left_arm_total_g, DXXRAFAT=JC_right_arm_fat_g, DXDRALE=JC_right_arm_lean_excl_BMC_g, DXDRAPF=JC_right_arm_pct_fat, DXDRATOT=JC_right_arm_total_g, DXXLLA=JC_left_leg_area_cm2, DXXLLBMC=JC_left_leg_BMC_g, DXXLLBMD=JC_left_leg_BMD_g_cm2, DXXLLLI=JC_left_leg_lean_incl_BMC_g, DXXLLFAT=JC_left_leg_fat_g, DXDLLLE=JC_left_leg_lean_excl_BMC_g, DXDLLPF=JC_left_leg_pct_fat, DXXRLA=JC_right_leg_area_cm2, DXXRLBMC=JC_right_leg_BMC_g, DXXRLBMD=JC_right_leg_BMD_g_cm2, DXXRLLI=JC_right_leg_lean_incl_BMC_g, DXDTRA=JC_trunk_area_cm2, DXDTRBMD=JC_trunk_BMD_g_cm2, DXXLRA=JC_left_ribs_area_cm2, DXXLRBMC=JC_left_ribs_BMC_g, DXXLRBMD=JC_left_ribs_BMD_g_cm2, DXXRRA=JC_right_ribs_area_cm2, DXXRRBMC=JC_right_ribs_BMC_g, DXXRRBMD=JC_right_ribs_BMD_g_cm2, DXXTSA=JC_thoracic_spine_area_cm2, DXXTSBMC=JC_thoracic_spine_BMC_g, DXXTSBMD=JC_thoracic_spine_BMD_g_cm2, DXXLSA=JC_lumbar_spine_area_cm2, DXXLSBMC=JC_lumbar_spine_BMC_g, DXXLSBMD=JC_lumbar_spine_BMD_g_cm2, DXXPEA=JC_pelvis_area_cm2, DXXPEBMC=JC_pelvis_BMC_g, DXXPEBMD=JC_pelvis_BMD_g_cm2, DXDTRBMC=JC_trunk_BMC_g, DXXTRLI=JC_trunk_lean_incl_BMC_g, DXXRLFAT=JC_right_leg_fat_g, DXDRLLE=JC_right_leg_lean_excl_BMC_g, DXDRLPF=JC_right_leg_pct_fat, DXXTRFAT=JC_trunk_fat_g, DXDTRLE=JC_trunk_lean_excl_BMC_g, DXDTRPF=JC_trunk_pct_fat, DXDLLTOT=JC_left_leg_total_g, DXDTRTOT=JC_trunk_total_g, DXDRLTOT=JC_right_leg_total_g, DXDSTFAT=JC_subtotal_fat_g, DXDSTLE=JC_subtotal_lean_excl_BMC_g, DXDSTTOT=JC_subtotal_total_excl_head_g, DXDSTPF=JC_subtotal_pct_fat, DXDTOLE=JC_total_lean_excl_BMC_g, DXDTOA=JC_total_area_cm2, DXDTOBMC=JC_total_BMC_g, DXDTOBMD=JC_total_BMD_g_cm2, DXDTOFAT=JC_total_fat_g, DXDTOLI=JC_total_lean_incl_BMC_g, DXDTOTOT=JC_total_lean_fat_g, DXDTOPF=JC_total_pct_fat, DXDSTA=JC_subtotal_area_cm2, DXDSTBMC=JC_subtotal_BMC_g, DXDSTBMD=JC_subtotal_BMD_g_cm2, DXDSTLI=JC_subtotal_lean_incl_BMC_g

### 2-代码材料 ``` rm(list = ls()) #设置路径 # ----------- 检查并安装包 ----------- for (pkg in c("devtools", "openxlsx", "dplyr")) { if (!requireNamespace(pkg, quietly = TRUE)) { install.packages(pkg) } } library("devtools") library("openxlsx") library("dplyr") install_github("ZhidoHuang/dbCodeBookr") # 提示更新包, 选 3 回车跳过，首次使用时需要安装 library("dbCodeBookr") # ----------- 读取数据 ----------- dt <- read.csv("raw_data.csv") data <-dt # 重要！！！ data[data==""] <- NA # 重要！！！ names(data) # [1] "SEQN" "YEAR" # [3] "JC_weight_kg" "JC_height_cm" # [5] "JC_BMI_2d" "JC_BMI_category" # [7] "JC_recumbent_length_cm" "JC_upper_leg_cm" # [9] "JC_upper_arm_cm" "JC_head_circ_cm" # [11] "JC_arm_circ_cm" "JC_waist_circ_cm" # [13] "JC_hip_circ_cm" "JC_maximal_calf_circ_cm" # [15] "JC_thigh_circ_cm" "JC_triceps_skinfold_mm" # [17] "JC_subscapular_skinfold_mm" "JC_SAD_1st_cm" # [19] "JC_SAD_2nd_cm" "JC_SAD_3rd_cm" # [21] "JC_SAD_4th_cm" "JC_SAD_avg_cm" # [23] "JC_android_gynoid_status" "JC_android_fat_mass" # [25] "JC_android_lean_mass" "JC_android_total_mass" # [27] "JC_gynoid_fat_mass" "JC_gynoid_lean_mass" # [29] "JC_gynoid_total_mass" "JC_android_gynoid_ratio" # [31] "JC_android_pct_fat" "JC_gynoid_pct_fat" # [33] "JC_subcut_fat_area" "JC_subcut_fat_mass" # [35] "JC_subcut_fat_vol" "JC_total_abd_fat_area" # [37] "JC_total_abd_fat_mass" "JC_total_abd_fat_vol" # [39] "JC_visceral_fat_area" "JC_visceral_fat_mass" # [41] "JC_visceral_fat_vol" "JC_head_area_cm2" # [43] "JC_head_BMC_g" "JC_head_BMD_g_cm2" # [45] "JC_head_fat_g" "JC_head_lean_excl_BMC_g" # [47] "JC_head_lean_incl_BMC_g" "JC_head_total_g" # [49] "JC_head_pct_fat" "JC_left_arm_area_cm2" # [51] "JC_left_arm_BMC_g" "JC_left_arm_BMD_g_cm2" # [53] "JC_left_arm_lean_incl_BMC_g" "JC_left_arm_fat_g" # [55] "JC_left_arm_lean_excl_BMC_g" "JC_left_arm_pct_fat" # [57] "JC_right_arm_area_cm2" "JC_right_arm_BMC_g" # [59] "JC_right_arm_BMD_g_cm2" "JC_right_arm_lean_incl_BMC_g" # [61] "JC_left_arm_total_g" "JC_right_arm_fat_g" # [63] "JC_right_arm_lean_excl_BMC_g" "JC_right_arm_pct_fat" # [65] "JC_right_arm_total_g" "JC_left_leg_area_cm2" # [67] "JC_left_leg_BMC_g" "JC_left_leg_BMD_g_cm2" # [69] "JC_left_leg_lean_incl_BMC_g" "JC_left_leg_fat_g" # [71] "JC_left_leg_lean_excl_BMC_g" "JC_left_leg_pct_fat" # [73] "JC_right_leg_area_cm2" "JC_right_leg_BMC_g" # [75] "JC_right_leg_BMD_g_cm2" "JC_right_leg_lean_incl_BMC_g" # [77] "JC_trunk_area_cm2" "JC_trunk_BMD_g_cm2" # [79] "JC_left_ribs_area_cm2" "JC_left_ribs_BMC_g" # [81] "JC_left_ribs_BMD_g_cm2" "JC_right_ribs_area_cm2" # [83] "JC_right_ribs_BMC_g" "JC_right_ribs_BMD_g_cm2" # [85] "JC_thoracic_spine_area_cm2" "JC_thoracic_spine_BMC_g" # [87] "JC_thoracic_spine_BMD_g_cm2" "JC_lumbar_spine_area_cm2" # [89] "JC_lumbar_spine_BMC_g" "JC_lumbar_spine_BMD_g_cm2" # [91] "JC_pelvis_area_cm2" "JC_pelvis_BMC_g" # [93] "JC_pelvis_BMD_g_cm2" "JC_trunk_BMC_g" # [95] "JC_trunk_lean_incl_BMC_g" "JC_right_leg_fat_g" # [97] "JC_right_leg_lean_excl_BMC_g" "JC_right_leg_pct_fat" # [99] "JC_trunk_fat_g" "JC_trunk_lean_excl_BMC_g" # [101] "JC_trunk_pct_fat" "JC_left_leg_total_g" # [103] "JC_trunk_total_g" "JC_right_leg_total_g" # [105] "JC_subtotal_fat_g" "JC_subtotal_lean_excl_BMC_g" # [107] "JC_subtotal_total_excl_head_g" "JC_subtotal_pct_fat" # [109] "JC_total_lean_excl_BMC_g" "JC_total_area_cm2" # [111] "JC_total_BMC_g" "JC_total_BMD_g_cm2" # [113] "JC_total_fat_g" "JC_total_lean_incl_BMC_g" # [115] "JC_total_lean_fat_g" "JC_total_pct_fat" # [117] "JC_subtotal_area_cm2" "JC_subtotal_BMC_g" # [119] "JC_subtotal_BMD_g_cm2" "JC_subtotal_lean_incl_BMC_g" # ----------- 清理数据 ----------- ## 塞选不是数值型的变量 #### str(data) #查看所有变量的类型：数值型会显示num或int（整数)。 #非数值型会显示chr (字符)、Factor (因子)、logi (逻辑)等 # 获取所有非数值型变量的名称 non_numeric_vars <- names(data)[!sapply(data, is.numeric)] # 显示结果 if(length(non_numeric_vars) > 0) { cat("非数值型变量（共", length(non_numeric_vars), "个）：\n") print(non_numeric_vars) } else { cat("所有变量都是数值型\n") } # 非数值型变量（共 3 个）： # [1] "YEAR" "JC_BMI_category" # [3] "JC_android_gynoid_status" ## 计算“BMI” #### data$JC_BMI_full <- data$JC_weight_kg / (data$JC_height_cm / 100)^2 summary(data$JC_BMI_full) #计算的BMI数据，保留全部的小数位 summary(data$JC_BMI_2d) #数据库已有的BMI数据，保留两位小数 ## 清理“JC_BMI_category” #### # 数据收集对象是2岁-19岁人群，数据收集期间为2011年-2023年 table(data$JC_BMI_category,useNA = "ifany") ## 清理“JC_android_gynoid_status”，label:android/gynoid region status#### table(data$JC_android_gynoid_status,useNA = "ifany") # recode.chr(data$JC_android_gynoid_status) data$JC_android_gynoid_status <- case_when( data$JC_android_gynoid_status == "whole body scan completed; android/gynoid region is valid" ~ "scan completed, android/gynoid region is valid", data$JC_android_gynoid_status == "whole body not scanned, pregnancy" ~ "scan not completed", data$JC_android_gynoid_status == "whole body not scanned, other reason" ~ "scan not completed", data$JC_android_gynoid_status == "whole body scan completed, but android or gynoid region is invalid" ~ "scan completed, android/gynoid region is invalid", data$JC_android_gynoid_status == "whole body not scanned, height > 6'5â" ~ "scan not completed", data$JC_android_gynoid_status == "whole body not scanned, weight > 450 lbs" ~ "scan not completed", TRUE ~ NA_character_ ) table(data$JC_android_gynoid_status,useNA = "ifany") # ----------- 创建新字典 ----------- ## 读取原始变量字典文件（包含原始变量名、标签等元数据信息），将新生成的变量也加入到字典 #### name_z <- read.csv("raw_codebook.csv") names(name_z) ## 变量映射表：将新生成的变量与原始变量进行映射，便于后续生成字典 #### add_mapping <- function(map, new_var, original_var) { # 将向量转换为逗号分隔的字符串存储 original_var_str <- paste(original_var, collapse = ", ") rbind(map, data.frame(Variable = new_var, original_vars = original_var_str, stringsAsFactors = FALSE)) } map <- data.frame(Variable = character(), original_vars = character()) map <- add_mapping(map, "JC_BMI_full", c("JC_weight_kg","JC_height_cm")) ## 创建codebook字典：为每个变量（包括新生成的变量）匹配原始字典信息，生成包含变量名、原始变量名、标签等信息的字典表 #### codebook <- lapply(names(data), function(col) { col_var <- col # 获取原始变量列表（如果是映射变量） if (col %in% map$Variable) { original_vars_str <- map$original_vars[map$Variable == col] original_vars_list <- unlist(strsplit(original_vars_str, ", ")) } else { original_vars_list <- col } # 对每个原始变量查找匹配项 matches_list <- lapply(original_vars_list, function(orig_var) { name_z[grepl(orig_var, name_z$newname) & sapply(gsub(orig_var, "", name_z$newname), function(x) stringr::str_count(x, "_") <= 1), ] }) # 过滤掉空的数据框 matches_list <- matches_list[sapply(matches_list, nrow) > 0] if (length(matches_list) > 0) { matches <- do.call(rbind, matches_list) matches <- matches[!duplicated(matches), ] # 去除重复 } else { matches <- data.frame(Variable = character(), newname = character(), Label = character(), stringsAsFactors = FALSE) } data.frame( Variable = col_var, original_vars = if(nrow(matches) > 0) paste(unique(matches$Variable), collapse = ", ") else "", processed_vars = if(nrow(matches) > 0) paste(unique(matches$newname), collapse = ", ") else "", Label = if(nrow(matches) > 0) first(matches$Label) else "", count = if(nrow(matches) > 0) nrow(matches) else 0, stringsAsFactors = FALSE ) }) %>% bind_rows() View(codebook) ## 新生成的变量需要手动标注意思!!!! #### codebook$Label[codebook$Variable == "JC_BMI_full"] <- "BMI: retain all decimal places" codebook$Label[codebook$Variable == "JC_BMI_2d"] <- "BMI: rounded to two decimal places" write.xlsx(data, "analysis_db_JC_body_Measures_DXA.xlsx") write.xlsx(codebook, "analysis_codebook_JC_body_Measures_DXA.xlsx") ```

导航目录

数据库

内容目录

热门标签

数据预览