Loading...
Show contents
Table of Contents

Survival data requirements

Some analyses require survival data, for example Kaplan-Meier plots. Survival data is uploaded separately after a dataset has been created from uploaded TMA scores. A button labelled Attach survival is located on the dataset view, within the About this dataset panel.

Summary of main requirements:

Please note that the date-based (secondary) format is converted into time in months and event occurred by TMA Navigator, and this primary format is given for survival data downloaded from the dataset page. For the purposes of the conversion, a 'month' is taken to be 30 days.

Further detail on the survival data requirements is given below.

[Top]Example data

The following example datasets have survival data available for download. They can be opened using Excel or a text editor to look at the file layout, and re-uploaded if you wish to try out the upload facility.

Tab separated format (.tsv)

Excel format (.xls)

[Top]Input file formats

The following list summarises acceptable file formats:

[Top]Data layout one - survival and censoring

Layout one has three columns, which must be titled 'Sample', 'SurvivalMonths' and 'EventOccurred'. 'SurvivalMonths' specifies the length of time (in months) that the patient survived without an event occurring (e.g. relapse or death) since a given start date (e.g. the start date might be the date of operation). If the patient had not had an event (e.g. relapse) when last seen, 'SurvivalMonths' specifies the time up to that point. The 'EventOccurred' indicates whether the patient had experienced an event when last seen or not - indicated by a 0 for no event occurred (e.g. no relapse) or a 1 (event occurred). Therefore samples with a 'EventOccurred' value of 0 represent censored data.

Example input data:

SampleSurvivalMonthsEventOccurred
120.40
25.61
312.21

[Top]Data layout two - start, event and follow up dates

Layout two has four columns, which must be titled 'Sample', 'StartDate', 'EventDate' and 'FollowUpDate'. 'StartDate' indicates the date from which survival time is measured and is obligatory for every sample specified. 'EventDate' indicates the date an event occurred (e.g. death or relapse), or is left blank if the event had not occurred when the patient was last seen. 'FollowUpDate' refers to the date when the patient was seen.

If both 'EventDate' and 'FollowUpDate' are specified, 'EventDate' takes precedence and the follow-up date is not used. For clarity, we recommend specifying only one of 'EventDate' and 'FollowUpDate' for each sample. An upload error will be given if any sample does not have either an 'EventDate' or a 'FollowUpDate'. 'EventDate' and 'FollowUpDate' cannot be earlier that 'StartDate'.

Please note that dates should be specified in yyyy-mm-dd format (i.e. ISO-8601 format). For example, 27th May 2011 would be specified as 2011-05-27. This is to ensure dates are specified unambiguously, rather than the region-specific dd-mm-yyyy or mm-dd-yyyy, for example. Excel and most spreadsheet programs are able to convert to this format.

Example input data:

SampleStartDateEventDateFollowUpDate
11999-04-262004-02-13
21999-07-022008-10-03
31999-08-132007-01-03
Back to top