Can someone tell me why the variable "WEIGHT_Actual" is not populated

[zimcom]

data exex1; set exex;
	if EXWGTMD_DEC = 'Estimated' then 
		do;
			if EXRWGTU_DEC = 'kgs' then WEIGHT_Estimated = EXRWGT;
			else if EXRWGTU_DEC = 'lbs' then WEIGHT_Estimated = EXRWGT*0.45359237;
		end;
	if EXWGTMD_DEC = 'Actual' then 
		do;
			if EXMWGTU_DEC = 'kgs' then WEIGHT_Actual = EXMWGT;
			else if EXMWGTU_DEC = 'lbs' then WEIGHT_Actual = EXMWGT*0.45359237;
		end;
run;

SUBNUM	EXRWGT	EXRWGTU_DEC	EXWGTMD_DEC	EXMWGT	EXMWGTU_DEC
01001	70.0	kgs	Estimated	72.5	kgs
01002	86.0	kgs	Estimated	85.1	kgs
01003	180.0	lbs	Estimated	70.8	kgs
01004	70.0	kgs	Estimated	61.1	kgs
01005	65.0	kgs	Estimated	63.5	kgs
01006	85.0	kgs	Estimated	83.4	kgs
01007	65.0	kgs	Estimated	84.8	kgs
01008	60.0	kgs	Estimated	99.9	kgs
01009	240.0	lbs	Estimated	101.7	kgs
01010	65.0	kgs	Estimated	66.9	kgs
01011	60.0	kgs	Estimated	64.8	kgs
01012	95.0	kgs	Estimated	93.3	kgs
12001	97.0	kgs	Actual
12002	61.0	kgs	Estimated	68.0	kgs
01013	75.0	kgs	Estimated	80.0	kgs
12003	75.0	kgs	Actual
12004	72.0	kgs	Actual
01014	115.0	kgs	Estimated	109.4	kgs
28001	103.0	kgs	Actual
01015	95.0	kgs	Estimated	105.9	kgs
12005	89.0	kgs	Actual
01016	75.0	kgs	Estimated	56.5	kgs
88001	80.0	kgs	Estimated	80.0	kgs
01017	85.0	kgs	Estimated	70.5	kgs
01018	80.0	kgs	Estimated	77.0	kgs
12006	104.0	kgs	Actual
88002	70.0	kgs	Estimated	70.0	kgs
28002	234.0	lbs	Actual
12007	72.0	kgs	Actual
12008	55.0	kgs	Estimated	44.0	kgs
28003	89.0	kgs	Actual
37001	72.0	kgs	Actual
28004	111.0	kgs	Actual
12009	107.0	lbs	Actual
37002	59.0	kgs	Actual
12010	86.0	kgs	Actual
74001	80.0	kgs	Estimated	80.0	kgs
28005	68.0	kgs	Actual
28006	91.0	kgs	Actual
37003	71.0	kgs	Actual
74002	75.0	kgs	Estimated	75.0	kgs
28007	72.0	kgs	Actual
12011	47.0	kgs	Actual
12012	75.0	kgs	Estimated	63.5	kgs
37004	81.0	kgs	Estimated	81.0	kgs
14001	89.0	kgs	Estimated	88.9	kgs
01019	75.0	kgs	Estimated	54.0	kgs
14002	77.0	kgs	Actual
01020	70.0	kgs	Estimated	88.3	kgs
01021	60.0	kgs	Estimated	66.6	kgs

Given the code and data in above.

Thanks!!

[japelin]

The data you are presenting is exex1 or exex?

[japelin · Accepted solution]

Isn't it because the value of EXMWGTU_DEC for the observation EXWGTMD_DEC = 'Actual' is empty?