topic Fill the gap in SAS Programming https://communities.sas.com/t5/SAS-Programming/Fill-the-gap/m-p/698846#M213753 <TABLE><TBODY><TR><TD>GVKEY</TD><TD>fyear</TD><TD>EXECID</TD><TD>TITLEANN</TD></TR><TR><TD>002538</TD><TD>2007</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2008</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2009</TD><TD>02158</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2010</TD><TD>02158</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2011</TD><TD>42441</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2012</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2013</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want the following result</P><TABLE><TBODY><TR><TD>GVKEY</TD><TD>fyear</TD><TD>EXECID</TD><TD>TITLEANN</TD></TR><TR><TD>002538</TD><TD>2007</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2008</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2009</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2010</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2011</TD><TD>42441</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2012</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2013</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR></TBODY></TABLE><P>can anyone help me with this?&nbsp;</P> Sat, 14 Nov 2020 05:54:40 GMT abdulla 2020-11-14T05:54:40Z Fill the gap https://communities.sas.com/t5/SAS-Programming/Fill-the-gap/m-p/698846#M213753 <TABLE><TBODY><TR><TD>GVKEY</TD><TD>fyear</TD><TD>EXECID</TD><TD>TITLEANN</TD></TR><TR><TD>002538</TD><TD>2007</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2008</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2009</TD><TD>02158</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2010</TD><TD>02158</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2011</TD><TD>42441</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2012</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2013</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>I want the following result</P><TABLE><TBODY><TR><TD>GVKEY</TD><TD>fyear</TD><TD>EXECID</TD><TD>TITLEANN</TD></TR><TR><TD>002538</TD><TD>2007</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2008</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2009</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2010</TD><TD>02158</TD><TD>president &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2011</TD><TD>42441</TD><TD>&nbsp;</TD></TR><TR><TD>002538</TD><TD>2012</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR><TR><TD>002538</TD><TD>2013</TD><TD>42441</TD><TD>chmn. &amp; CEO</TD></TR></TBODY></TABLE><P>can anyone help me with this?&nbsp;</P> Sat, 14 Nov 2020 05:54:40 GMT https://communities.sas.com/t5/SAS-Programming/Fill-the-gap/m-p/698846#M213753 abdulla 2020-11-14T05:54:40Z Re: Fill the missing categorical variable with previous given info https://communities.sas.com/t5/SAS-Programming/Fill-the-gap/m-p/698849#M213755 <P>Standard use case for RETAIN.</P> <P>&nbsp;</P> <PRE><CODE class=" language-sas">data want; set have; by GVKEY; retain newTitle; if not missing(titleAnn) then newTitle = titleAnn; if first.GVKEY and missing(titleAnn) then call missing(newTitle); run;</CODE></PRE> <BLOCKQUOTE><HR /><a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/260675">@abdulla</a>&nbsp;wrote:<BR /> <TABLE> <TBODY> <TR> <TD>GVKEY</TD> <TD>fyear</TD> <TD>EXECID</TD> <TD>TITLEANN</TD> </TR> <TR> <TD>002538</TD> <TD>2007</TD> <TD>02158</TD> <TD>president &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2008</TD> <TD>02158</TD> <TD>president &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2009</TD> <TD>02158</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>002538</TD> <TD>2010</TD> <TD>02158</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>002538</TD> <TD>2011</TD> <TD>42441</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>002538</TD> <TD>2012</TD> <TD>42441</TD> <TD>chmn. &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2013</TD> <TD>42441</TD> <TD>chmn. &amp; CEO</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>I want the following result</P> <TABLE> <TBODY> <TR> <TD>GVKEY</TD> <TD>fyear</TD> <TD>EXECID</TD> <TD>TITLEANN</TD> </TR> <TR> <TD>002538</TD> <TD>2007</TD> <TD>02158</TD> <TD>president &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2008</TD> <TD>02158</TD> <TD>president &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2009</TD> <TD>02158</TD> <TD>president &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2010</TD> <TD>02158</TD> <TD>president &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2011</TD> <TD>42441</TD> <TD>&nbsp;</TD> </TR> <TR> <TD>002538</TD> <TD>2012</TD> <TD>42441</TD> <TD>chmn. &amp; CEO</TD> </TR> <TR> <TD>002538</TD> <TD>2013</TD> <TD>42441</TD> <TD>chmn. &amp; CEO</TD> </TR> </TBODY> </TABLE> <P>can anyone help me with this?&nbsp;</P> <HR /></BLOCKQUOTE> <P>&nbsp;</P> Sat, 14 Nov 2020 03:56:30 GMT https://communities.sas.com/t5/SAS-Programming/Fill-the-gap/m-p/698849#M213755 Reeza 2020-11-14T03:56:30Z