[EpiData-list] Re: conversion from SPSS

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Wed Apr 3 08:42:28 CDT 2013

Jamie, thank you very much!

My SPSS databank is composed of 703 columns, where the first 200 are
baseline, and the other the follow-up. Each line is a case.
Every time I want to input data, I open the databank, search for the case
number and for the situation (e.g. 3rd month). After this, I fill in with
the data.
My baseline variables are different from the follow-up.
At follow-up, variables are the same, exept the variable identification:
height1m and weight1m ---> height3m and weight3m.

In other words, your idea of making a single database, using a valiable
VISIT and case number as KEY sounds great, but the VISIT variable I don't
have in my original SPSS databank! How can I merge with this difference?

I suppose I'll continue with the case numbers: 1051, 1052, 1053, ... Is it

I'm affraid if is (or not) possible to join the old data (from my 1050
subjects) with the new data from the EpiData, and how to do that? I must
maintain the same variable names/description, otherwise I'll be completelly

I was reviewing the example "Relate example - Household, Person, Visit",
and it was very interesting for me, but I want (if possible) an exemple of
how to merge SPSS databases with EpiData. Do you know one?

Once again, thank you very much!


2013/4/3 <epidata-list at lists.umanitoba.ca>

> If your data are already in SPSS, it will be simplest to use the same
> structure as you already have (probably one database).
> If you are going to be gathering data and using EpiData to input new data,
> then you have a choice. I won't offer a real answer, except to say that the
> choice of one database or RELATED databases will depend on how you want to
> analyze the data and whether there are differences in data points at the
> three visits.
> If the three visits have exactly the same variables, you can use two
> related databases:
> 1. demographics with case number as KEY
> 2. visits, using case number as KEY to allow you to related the files
> (there is an example for this in classic Epidata - household, person,
> visit at http://epidata.dk/examples.php)
> In Analysis, read the visits file first and then merge demographics based
> on case number
> If the three visits have different data, then you could have four related
> databases:
> 1. demographics as before
> 2. visit 1 with case number as KEY
> 3. visit 2
> 4. visit 3
> This arrangement makes it possible to do the data entry independently, but
> still bring all of the data together for analysis. In classic EpiData,
> people did this to keep the number of variables down in each of the files.
> However, the data are structured exactly like a single large database.
> In Analysis, ready any file first and merge based on case number
> You can make a single database and still make it easy to enter data by
> having a variable VISIT and depending on the value (1,2,3) Jump to the
> first variable for that visit. In the new EpiData (Manager, EntryClient)
> you can do this quite easily.
> Jamie
> On 2013-04-01, at 6:17 PM, epidata-list at lists.umanitoba.ca wrote:
> > I'm changing my database from SPSS to EpiData.
> > IIt's a follow-up database, with almost 1050 subjects, and three
> different
> > time points (baseline, 1fst and 3rd months). In total, I have 703
> variables.
> > I wonder if you can help me with which choice should I take to collect
> and
> > merge this kind of data?
> > Is it better to create only one database (including all time points), or
> > should I have to create three databases - one for each time point? If I
> > create 3 databases, how can I merge it? Ex: case n. 999 - merge baseline
> > data with 1fst month, and with the 3rd month...
> > Can you inform where I can find exemples?
> > T
> _______________________________________________
> EpiData-list mailing list
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list

More information about the EpiData-list mailing list