Hi<br>I am relatively new to R, and now trying Amelia for health indicator data<br>I have a CSV file created from Excel with the following fields (columns):<br><br>ID - autonumber identifier field<br>Prov - name of the province (geographic area) for use as cross-section - this seems to work whether it is a string such as province acronym or whether coded to a number, although it doesn&#39;t work if I set the variable type to &#39;nominal&#39; only if I leave it as &#39;no transformation&#39;<br>
<br>Month - this field is currently formatted as ISO dates, but this is being seen by Amelia (using AmeliaView) as a factor and is not working for doing time series with cross-section analysis<br>&nbsp; eg of data <br>&nbsp; 2006-12-01<br>
2007-01-01<br>2007-02-01<br>2007-03-01<br><br>Value - the actual data values for the indicator as numbers - this is the field that has some missing data values that I want imputed.<br><br>The only way I have been able to get this to work is to get Excel to convert the Month variable to a number - you then get data that looks like this<br>
&nbsp; 39052.00<br>&nbsp; 39083.00<br>&nbsp; 39114.00<br>&nbsp; 39142.00<br>but I&#39;m not sure if this is the correct way to do it and whether Amelia will understand the date/time significance.<br><br>Otherwise how else must one format date variables so that they are correctly interpreted?<br>
<br>Regards<br>Candy<br><br>-- <br>Candy Day<br>HealthLink, Health Systems Trust<br><a href="http://www.hst.org.za">http://www.hst.org.za</a><br>Mobile: 084 960 9014<br>Fax:&nbsp;&nbsp;&nbsp;&nbsp; 086 524 9563<br>