https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/491991#M129214 <TABLE><TBODY><TR><TD><P><STRONG>id</STRONG></P></TD><TD><P><STRONG>sale</STRONG></P></TD></TR><TR><TD><P>101</P></TD><TD><P>5</P></TD></TR><TR><TD><P>101</P></TD><TD><P>14</P></TD></TR><TR><TD><P>101</P></TD><TD><P>.</P></TD></TR><TR><TD><P>102</P></TD><TD><P>45</P></TD></TR><TR><TD><P>102</P></TD><TD><P>78</P></TD></TR><TR><TD><P>102</P></TD><TD><P>58</P></TD></TR><TR><TD><P>102</P></TD><TD><P>69</P></TD></TR><TR><TD><P>102</P></TD><TD><P>89</P></TD></TR><TR><TD><P>102</P></TD><TD><P>.</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>assign sum id wise into missing values like see below</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>id</STRONG></P></TD><TD><P><STRONG>new</STRONG></P></TD></TR><TR><TD><P>101</P></TD><TD><P>5</P></TD></TR><TR><TD><P>101</P></TD><TD><P>14</P></TD></TR><TR><TD><P>101</P></TD><TD><P>19</P></TD></TR><TR><TD><P>102</P></TD><TD><P>45</P></TD></TR><TR><TD><P>102</P></TD><TD><P>58</P></TD></TR><TR><TD><P>102</P></TD><TD><P>69</P></TD></TR><TR><TD><P>102</P></TD><TD><P>78</P></TD></TR><TR><TD><P>102</P></TD><TD><P>89</P></TD></TR><TR><TD><P>102</P></TD><TD><P>339</P></TD></TR></TBODY></TABLE> Mon, 03 Sep 2018 07:08:07 GMT thanikondharish 2018-09-03T07:08:07Z https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/491991#M129214 <TABLE><TBODY><TR><TD><P><STRONG>id</STRONG></P></TD><TD><P><STRONG>sale</STRONG></P></TD></TR><TR><TD><P>101</P></TD><TD><P>5</P></TD></TR><TR><TD><P>101</P></TD><TD><P>14</P></TD></TR><TR><TD><P>101</P></TD><TD><P>.</P></TD></TR><TR><TD><P>102</P></TD><TD><P>45</P></TD></TR><TR><TD><P>102</P></TD><TD><P>78</P></TD></TR><TR><TD><P>102</P></TD><TD><P>58</P></TD></TR><TR><TD><P>102</P></TD><TD><P>69</P></TD></TR><TR><TD><P>102</P></TD><TD><P>89</P></TD></TR><TR><TD><P>102</P></TD><TD><P>.</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>assign sum id wise into missing values like see below</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P><STRONG>id</STRONG></P></TD><TD><P><STRONG>new</STRONG></P></TD></TR><TR><TD><P>101</P></TD><TD><P>5</P></TD></TR><TR><TD><P>101</P></TD><TD><P>14</P></TD></TR><TR><TD><P>101</P></TD><TD><P>19</P></TD></TR><TR><TD><P>102</P></TD><TD><P>45</P></TD></TR><TR><TD><P>102</P></TD><TD><P>58</P></TD></TR><TR><TD><P>102</P></TD><TD><P>69</P></TD></TR><TR><TD><P>102</P></TD><TD><P>78</P></TD></TR><TR><TD><P>102</P></TD><TD><P>89</P></TD></TR><TR><TD><P>102</P></TD><TD><P>339</P></TD></TR></TBODY></TABLE> Mon, 03 Sep 2018 07:08:07 GMT https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/491991#M129214 thanikondharish 2018-09-03T07:08:07Z https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/491994#M129216 <P>Post test data in the form of a datastep, we have asked you this time and time again.</P> <P>As such no code, retain a variable, add value to this each row, if row is . then set to retained value and then set retained value back to zero.</P> Mon, 03 Sep 2018 07:38:32 GMT https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/491994#M129216 RW9 2018-09-03T07:38:32Z https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/492014#M129225 how to assign mean value in missing places<BR /> Mon, 03 Sep 2018 09:30:31 GMT https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/492014#M129225 thanikondharish 2018-09-03T09:30:31Z https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/492016#M129226 <P>Retain sum of values and count of items, mean is sum/count</P> Mon, 03 Sep 2018 09:35:00 GMT https://communities.sas.com/t5/SAS-Programming/assign-missing-values/m-p/492016#M129226 RW9 2018-09-03T09:35:00Z