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!!
