Excel data upload into EpiData
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@lists.umanitoba.cawrote:
Send EpiData-list mailing list submissions to epidata-list@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@lists.umanitoba.ca
You can reach the person managing the list at epidata-list-owner@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:
- Re: Export EpiData to Excel - is there a solution/an alternative? (epidata-list@lists.umanitoba.ca)
- relational files on epodata analysis (epidata-list@lists.umanitoba.ca)
- Re: relational files on epodata analysis (epidata-list@lists.umanitoba.ca)
Message: 1 Date: Thu, 11 Aug 2011 19:03:19 +0200 From: epidata-list@lists.umanitoba.ca Subject: Re: [EpiData-list] Export EpiData to Excel - is there a solution/an alternative? To: epidata-list@lists.umanitoba.ca Message-ID: <23065_1313082200_ZZh0y4eF~ 8kfp.00_4E440B57.4040905@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@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@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@lists.umanitoba.ca Subject: [EpiData-list] relational files on epodata analysis To: epidata-list@lists.umanitoba.ca Message-ID: 6c3a19b721250cea381f09c055a1d1f1.squirrel@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@lists.umanitoba.ca Subject: Re: [EpiData-list] relational files on epodata analysis To: epidata-list@lists.umanitoba.ca Message-ID: BLU0-SMTP24D73CD429C739981CD0C1FD220@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.
The easiest way to do this is in Analysis.
First, in Excel: At the top of each column of data, you need to have a valid EpiData field name. Format each Excel column to match the data:
Numeric (with number of decimals) Text Date (format doesn't matter, but make them all the same)
Select and copy column headings (field names) and all data.
Then in Analysis,
read /cb define idnum ##### idnum = recnumber // if you want IDNUM=record number savedata xyz
If your data are clean, your data are now in EpiData.
Caution: if you use the test version of Analysis (the one that can read .epx files), you will also se xyz.chk. DELETE IT! It has errors. No problem with the current working version of Analysis.
With EpiData, create a QES from your REC file. Edit the QES to match the layout you want (e.g. may IDNUM comes first instead of last). Save the QES and open the REC for input. Say yes to reformat the file.
There you go. I find this easier that trying to export from Excel as CSV file and importing.
Jamie
On 2011-08-12, Bijay wrote:
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
participants (1)
-
epidata-list＠lists.umanitoba.ca