<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 12pt;
font-family:Calibri
}
--></style></head>
<body class='hmmessage'><div dir='ltr'><p abp="158">Hi everyone,</p><p abp="159"> </p><p abp="160">I would want to replace only the "missing" characters in <em>date</em> column by "2002-06-30" character (I will make the change to date format in future):</p><p abp="163"> </p><p abp="164"><font face="Courier New" abp="165">DT <- data.table(id=c(1,1,4,4,4), </font></p><p abp="164"><font face="Courier New" size="2" abp="167"><font size="3"> date=as.character(c("1997-04-26","missing","1998-08-25","missing","1998-11-07")))</font><br abp="168"><font size="3">DT</font></font></p><p abp="169"><font face="Courier New" abp="170"></font> </p><p abp="171"><font face="Courier New" abp="172"> id date<br abp="173">1: 1 1997-04-26<br abp="174">2: 1 NA<br abp="175">3: 4 1998-08-25<br abp="176">4: 4 NA<br abp="177">5: 4 1998-11-07</font></p><p abp="178"> </p><p abp="179"> </p><p abp="180"><font face="Courier New">DT[,list(id, date=if(variable==NA) {"2002-06-30"} else date)]</font></p><p abp="181"> </p><p abp="182">But I get an error message.</p><p abp="183"> </p><p abp="184">Is it posible to do it under data table format?</p><p abp="185"> </p><p abp="186">Many thanks to all the data.table help members!!</p> </div></body>
</html>