topic Re: To get repeated value for missing value in SAS Programming https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296371#M62075 <P>I have the feeling that you miss a line after the BY ...</P><P>&nbsp; &nbsp; RETAIN SVCDATE;</P> Sun, 04 Sep 2016 07:44:48 GMT Shmuel 2016-09-04T07:44:48Z To get repeated value for missing value https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296365#M62071 <P>Hi Everyone,</P><P>&nbsp;</P><P>After trying the following codes:</P><PRE><CODE class=" language-sas">data Enrolid_SD; Set S.MS_Enrolid; By enrolid svcdate; If first. enrolid then Index_Dt = Svcdate; format Index_Dt date9.; run;</CODE></PRE><P>I am getting output like this:&nbsp;</P><TABLE><TBODY><TR><TD><P>1</P></TD><TD><P>497201</P></TD><TD><P>02MAR2011</P></TD><TD><P>1928</P></TD><TD><P>02MAR2011</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>2</P></TD><TD><P>497201</P></TD><TD><P>08JUN2011</P></TD><TD><P>1928</P></TD><TD><P>.</P></TD><TD>&nbsp;&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>3</P></TD><TD><P>497201</P></TD><TD><P>10OCT2011</P></TD><TD><P>1928</P></TD><TD><P>.</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>4</P></TD><TD><P>497201</P></TD><TD><P>10JAN2012</P></TD><TD><P>1928</P></TD><TD><P>.</P></TD><TD>&nbsp;&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>5</P></TD><TD><P>581601</P></TD><TD><P>18JUN2009</P></TD><TD><P>1934</P></TD><TD><P>18JUN2009</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>6</P></TD><TD><P>581601</P></TD><TD><P>14DEC2009</P></TD><TD><P>1934</P></TD><TD><P>.</P></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>&nbsp;</P><P>7</P></TD><TD><P>1203301</P></TD><TD><P>15MAR2011</P></TD><TD><P>1928</P></TD><TD><P>15MAR2011</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>8</P></TD><TD><P>1234801</P></TD><TD><P>20MAY2009</P></TD><TD><P>1939</P></TD><TD><P>20MAY2009</P></TD><TD>&nbsp;&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>9</P></TD><TD><P>1257301</P></TD><TD><P>09FEB2012</P></TD><TD><P>1928</P></TD><TD><P>09FEB2012</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>But I want output like this i.e. I don't want any missing index_dt value, but I want the previous index_dt there.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD><P>1</P></TD><TD><P>497201</P></TD><TD><P>02MAR2011</P></TD><TD><P>1928</P></TD><TD><P>02MAR2011</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>2</P></TD><TD><P>497201</P></TD><TD><P>08JUN2011</P></TD><TD><P>1928</P></TD><TD><P>02MAR2011</P></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>3</P></TD><TD><P>497201</P></TD><TD><P>10OCT2011</P></TD><TD><P>1928</P></TD><TD><P>02MAR2011</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>4</P></TD><TD><P>497201</P></TD><TD><P>10JAN2012</P></TD><TD><P>1928</P></TD><TD><P>02MAR2011</P></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>5</P></TD><TD><P>581601</P></TD><TD><P>18JUN2009</P></TD><TD><P>1934</P></TD><TD><P>18JUN2009</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>6</P></TD><TD><P>581601</P></TD><TD><P>14DEC2009</P></TD><TD><P>1934</P></TD><TD><P>18JUN2009</P></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>7</P></TD><TD><P>1203301</P></TD><TD><P>15MAR2011</P></TD><TD><P>1928</P></TD><TD><P>15MAR2011</P></TD><TD>&nbsp;</TD></TR><TR><TD><P>8</P></TD><TD><P>1234801</P></TD><TD><P>20MAY2009</P></TD><TD><P>1939</P></TD><TD><P>20MAY2009</P></TD><TD>&nbsp;</TD></TR></TBODY></TABLE><TABLE><TBODY><TR><TD><P>9</P></TD><TD><P>1257301</P></TD><TD><P>09FEB2012</P></TD><TD><P>1928</P></TD><TD><P>09FEB2012</P></TD></TR></TBODY></TABLE><P>&nbsp;</P><P>Someone please look into it and <STRONG>provide easy codes.</STRONG></P><P>&nbsp;</P><P><STRONG>Thanks!</STRONG></P><P>&nbsp;</P><P>&nbsp;</P> Mon, 05 Sep 2016 11:39:17 GMT https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296365#M62071 Reema 2016-09-05T11:39:17Z Re: To get repeated value for missing value https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296371#M62075 <P>I have the feeling that you miss a line after the BY ...</P><P>&nbsp; &nbsp; RETAIN SVCDATE;</P> Sun, 04 Sep 2016 07:44:48 GMT https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296371#M62075 Shmuel 2016-09-04T07:44:48Z Re: To get repeated value for missing value https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296372#M62076 <P>Sorry - it shold be:</P><P>&nbsp; &nbsp; RETAIN INDEX_DT;</P> Sun, 04 Sep 2016 07:46:53 GMT https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296372#M62076 Shmuel 2016-09-04T07:46:53Z Re: To get repeated value for missing value https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296373#M62077 Thanks Shmuel.. but actually it must be:<BR />retain index_dt; /* after by statement */<BR /><BR />I have checked.<BR /><BR />Please edit your comment, then I will mark it as a solution. Sun, 04 Sep 2016 07:56:31 GMT https://communities.sas.com/t5/SAS-Programming/To-get-repeated-value-for-missing-value/m-p/296373#M62077 Reema 2016-09-04T07:56:31Z