topic Re: Can someone tell me why the variable &quot;WEIGHT_Actual&quot; is not populated in SAS Programming https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801821#M315594 The data you are presenting is exex1 or exex? Sat, 12 Mar 2022 16:24:23 GMT japelin 2022-03-12T16:24:23Z Can someone tell me why the variable "WEIGHT_Actual" is not populated https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801818#M315593 <PRE><CODE class="">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;</CODE></PRE><TABLE><TBODY><TR><TD>SUBNUM</TD><TD>EXRWGT</TD><TD>EXRWGTU_DEC</TD><TD>EXWGTMD_DEC</TD><TD>EXMWGT</TD><TD>EXMWGTU_DEC</TD></TR><TR><TD>01001</TD><TD>70.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>72.5</TD><TD>kgs</TD></TR><TR><TD>01002</TD><TD>86.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>85.1</TD><TD>kgs</TD></TR><TR><TD>01003</TD><TD>180.0</TD><TD>lbs</TD><TD>Estimated</TD><TD>70.8</TD><TD>kgs</TD></TR><TR><TD>01004</TD><TD>70.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>61.1</TD><TD>kgs</TD></TR><TR><TD>01005</TD><TD>65.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>63.5</TD><TD>kgs</TD></TR><TR><TD>01006</TD><TD>85.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>83.4</TD><TD>kgs</TD></TR><TR><TD>01007</TD><TD>65.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>84.8</TD><TD>kgs</TD></TR><TR><TD>01008</TD><TD>60.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>99.9</TD><TD>kgs</TD></TR><TR><TD>01009</TD><TD>240.0</TD><TD>lbs</TD><TD>Estimated</TD><TD>101.7</TD><TD>kgs</TD></TR><TR><TD>01010</TD><TD>65.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>66.9</TD><TD>kgs</TD></TR><TR><TD>01011</TD><TD>60.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>64.8</TD><TD>kgs</TD></TR><TR><TD>01012</TD><TD>95.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>93.3</TD><TD>kgs</TD></TR><TR><TD>12001</TD><TD>97.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12002</TD><TD>61.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>68.0</TD><TD>kgs</TD></TR><TR><TD>01013</TD><TD>75.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>80.0</TD><TD>kgs</TD></TR><TR><TD>12003</TD><TD>75.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12004</TD><TD>72.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>01014</TD><TD>115.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>109.4</TD><TD>kgs</TD></TR><TR><TD>28001</TD><TD>103.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>01015</TD><TD>95.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>105.9</TD><TD>kgs</TD></TR><TR><TD>12005</TD><TD>89.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>01016</TD><TD>75.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>56.5</TD><TD>kgs</TD></TR><TR><TD>88001</TD><TD>80.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>80.0</TD><TD>kgs</TD></TR><TR><TD>01017</TD><TD>85.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>70.5</TD><TD>kgs</TD></TR><TR><TD>01018</TD><TD>80.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>77.0</TD><TD>kgs</TD></TR><TR><TD>12006</TD><TD>104.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>88002</TD><TD>70.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>70.0</TD><TD>kgs</TD></TR><TR><TD>28002</TD><TD>234.0</TD><TD>lbs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12007</TD><TD>72.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12008</TD><TD>55.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>44.0</TD><TD>kgs</TD></TR><TR><TD>28003</TD><TD>89.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>37001</TD><TD>72.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28004</TD><TD>111.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12009</TD><TD>107.0</TD><TD>lbs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>37002</TD><TD>59.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12010</TD><TD>86.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>74001</TD><TD>80.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>80.0</TD><TD>kgs</TD></TR><TR><TD>28005</TD><TD>68.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>28006</TD><TD>91.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>37003</TD><TD>71.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>74002</TD><TD>75.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>75.0</TD><TD>kgs</TD></TR><TR><TD>28007</TD><TD>72.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12011</TD><TD>47.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>12012</TD><TD>75.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>63.5</TD><TD>kgs</TD></TR><TR><TD>37004</TD><TD>81.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>81.0</TD><TD>kgs</TD></TR><TR><TD>14001</TD><TD>89.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>88.9</TD><TD>kgs</TD></TR><TR><TD>01019</TD><TD>75.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>54.0</TD><TD>kgs</TD></TR><TR><TD>14002</TD><TD>77.0</TD><TD>kgs</TD><TD>Actual</TD><TD>&nbsp;</TD><TD>&nbsp;</TD></TR><TR><TD>01020</TD><TD>70.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>88.3</TD><TD>kgs</TD></TR><TR><TD>01021</TD><TD>60.0</TD><TD>kgs</TD><TD>Estimated</TD><TD>66.6</TD><TD>kgs</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Given the code and data in above.</P><P>Thanks!!</P> Sat, 12 Mar 2022 16:09:27 GMT https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801818#M315593 zimcom 2022-03-12T16:09:27Z Re: Can someone tell me why the variable "WEIGHT_Actual" is not populated https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801821#M315594 The data you are presenting is exex1 or exex? Sat, 12 Mar 2022 16:24:23 GMT https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801821#M315594 japelin 2022-03-12T16:24:23Z Re: Can someone tell me why the variable "WEIGHT_Actual" is not populated https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801823#M315595 <P>Isn't it because the value of EXMWGTU_DEC for the observation EXWGTMD_DEC = 'Actual' is empty?</P> <P>&nbsp;</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="japelin_0-1647102574512.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/69424i4D461AEBE87661AD/image-size/medium?v=v2&amp;px=400" role="button" title="japelin_0-1647102574512.png" alt="japelin_0-1647102574512.png" /></span></P> <P>&nbsp;</P> Sat, 12 Mar 2022 16:30:05 GMT https://communities.sas.com/t5/SAS-Programming/Can-someone-tell-me-why-the-variable-quot-WEIGHT-Actual-quot-is/m-p/801823#M315595 japelin 2022-03-12T16:30:05Z