[EpiData-list] Excel data upload into EpiData

epidata-list at lists.umanitoba.ca epidata-list at lists.umanitoba.ca
Fri Aug 12 12:59:20 CDT 2011


Jens & Jamie,

Thank you for suggestions time to time on Epidata programming that I am
working on. We are replacing existing disease database (specific disease)
that is in Access plateform with Epidata. The access database was not stable
over the years, so lost a chunk of data few times. Hope Epidata is the
solution. I completed most programming including several calculated fields,
some are very complex assiging risk factors. The data is in MS Excel. It has
~ 2000 data with ~ 100 variables. All the data fields in both (Epiadta QES
and Excel) systems are identical except IDNUM is extra in Epidata.

I am looking the best way to migrate excel data into the blank epidata. May
be I should convert excel to .REC file first, then import, or may be .TXT is
better. I have tested with small dataset by cerating .REC file first then
import. It did work.

Any suggestion would be appriciated.

Thanks


Bijay




On Fri, Aug 12, 2011 at 11:01 AM,
<epidata-list-request at lists.umanitoba.ca>wrote:

> Send EpiData-list mailing list submissions to
>        epidata-list at lists.umanitoba.ca
>
> To subscribe or unsubscribe via the World Wide Web, visit
>        http://lists.umanitoba.ca/mailman/listinfo/epidata-list
> or, via email, send a message with subject or body 'help' to
>        epidata-list-request at lists.umanitoba.ca
>
> You can reach the person managing the list at
>        epidata-list-owner at lists.umanitoba.ca
>
> When replying, please edit your Subject line so it is more specific
> than "Re: Contents of EpiData-list digest..."
>
>
> EpiData-list mailing list
> ___________________________________
>
> Today's Topics:
>
>   1. Re: Export EpiData to Excel - is there a solution/an
>      alternative? (epidata-list at lists.umanitoba.ca)
>   2. relational files on epodata analysis
>      (epidata-list at lists.umanitoba.ca)
>   3. Re: relational files on epodata analysis
>      (epidata-list at lists.umanitoba.ca)
>
>
> ----------------------------------------------------------------------
>
> Message: 1
> Date: Thu, 11 Aug 2011 19:03:19 +0200
> From: epidata-list at lists.umanitoba.ca
> Subject: Re: [EpiData-list] Export EpiData to Excel - is there a
>        solution/an     alternative?
> To: epidata-list at lists.umanitoba.ca
> Message-ID:
>        <23065_1313082200_ZZh0y4eF~
> 8kfp.00_4E440B57.4040905 at uni-bielefeld.de>
> Content-Type: text/plain; charset=ISO-8859-1; format=flowed
>
> Hey everybody,
>
> thank your so much for your efforts and the enormous help! I need some
> time to consider your proposals and the next steps now :-)
>
> My boss has done a lot of work with Excel and she is just worried 1.
> that we have to adapt to a new system and 2. that we can't combine the
> data from the Open Office sheets with already existing Excel sheets.
>
> Thanks again and greetings,
> Nina
>
>
>
> Am 11.08.2011 17:45, schrieb epidata-list at lists.umanitoba.ca:
> > I suppose the starting point really is to answer the question, "What do I
> want to do with the data in Excel?"
> >
> > ? look at it in a spreadsheet view? - EpiData Analysis can do this
> (Browse)
> > ? do some simple calculations on some fields? - EpiData Analysis can do
> this
> > ? do some really complicated calculations on some fields? - just export
> some key identifying fields and the fields you need into Excel and merge the
> results back into your EpiData file
> > ? do some special analysis that is only available in Excel? - same idea,
> but I can't think of any that would use very many fields
> > ? create a database that will support mail-merge ? - you won't need many
> fields for this
> >
> > If your boss has a fixation on an old version of Excel, then you are
> limited to exporting 256 fields (columns). Excel 2010 or newer can handle
> over 16,000 columns
> >
> > Jamie
> >
> >> thank you very much! I tried to suggest that to my boss but she is not
> convinced yet. Are there any other possibilities available?
> >
> > _______________________________________________
> > EpiData-list mailing list
> > EpiData-list at lists.umanitoba.ca
> > http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> --
> Nina-Claire Himpe
> Wiss. Mit. von Prof. Dr. Ulrike Davy
> Lehrstuhl für öffentliches Recht, deutsches und
> internationales Sozialrecht, Rechtsvergleichung
> Fakultät für Rechtswissenschaft
> Universität Bielefeld
> Postfach 10 01 33
> 33 501 Bielefeld
>
> UHG T7-109
> Tel.: 0521 - 106 2508
>
>
> ------------------------------
>
> Message: 2
> Date: Thu, 11 Aug 2011 13:59:24 -0500
> From: epidata-list at lists.umanitoba.ca
> Subject: [EpiData-list] relational files on epodata analysis
> To: epidata-list at lists.umanitoba.ca
> Message-ID:
>        <6c3a19b721250cea381f09c055a1d1f1.squirrel at webmail.uady.mx>
> Content-Type: text/plain;charset=iso-8859-1
>
> I woul like to request a simple exaple to relate 2 files and create a new
> one using epidata analysis.
> Thank you in advance
>
> Jose Farfan
>
>
> -----------------------------------------
>   "Universidad Autónoma de Yucatán"
> http://www.uady.mx/
>
>
>
> ------------------------------
>
> Message: 3
> Date: Thu, 11 Aug 2011 16:50:49 -0400
> From: epidata-list at lists.umanitoba.ca
> Subject: Re: [EpiData-list] relational files on epodata analysis
> To: epidata-list at lists.umanitoba.ca
> Message-ID: <BLU0-SMTP24D73CD429C739981CD0C1FD220 at phx.gbl>
> Content-Type: text/plain; charset="us-ascii"
>
> This is quite simple. Please read the help for the MERGE command in
> Analysis.
> Here is a simple example in a zip file.
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: epidata_merge_example.zip
> Type: application/zip
> Size: 5688 bytes
> Desc: not available
> Url :
> http://lists.umanitoba.ca/pipermail/epidata-list/attachments/20110811/3e9b3aa9/epidata_merge_example-0001.zip
> -------------- next part --------------
>
> Jamie
>
>
> > I woul like to request a simple exaple to relate 2 files and create a new
> > one using epidata analysis.
> > Thank you in advance
> >
> > Jose Farfan
>
>
> ------------------------------
>
> ________________________________________
> EpiData-list at lists.umanitoba.ca
> http://lists.umanitoba.ca/mailman/listinfo/epidata-list
>
>
> End of EpiData-list Digest, Vol 94, Issue 6
> *******************************************
>



-- 
Regards,
ABJ

"It is not the strongest of the species that survives, nor the most
intelligent, but the one most responsive to change."  Charles Darwin


More information about the EpiData-list mailing list