Importing data to Epidata analysis
Dear all,
I would like to import data from the clipboard to Epidata analysis but it is not working.
The data is in excel; I select and copy the range of cells that I need to import to Epidata analysis
With Epidata analysis I select import from clipboard in the file drop down menu but i get the message below:
"Separators: (tab: 7153)(semicolon: 0)(comma: 0)(space: 0) Lines: 14753 Cannot define number of variables"
What could I be doing wrong?
WK
To import data from spreadsheets the following is a good rule: 1. change first line to indicate contents of each column e.g. : v1 v2 v3 age sex ...... etc
2 in each data column make sure to format correctly, e.g.: for a given column if this contains integers, format as no decimals
3 make sure you do not have a combination of string and numbers in a given column
4 if you have dates make sure they are entered in same format, e.g. 23-12-2012
5 make sure that right most column is complete with one number in all rows otherwise add a column containing a 0 or 1 in the right most column in all rows.
6 make sure you have at least two columns (one is too little)
7 if you have decimal numbers use period and not comma as delimiter. This problem it seems you do not have since the output shows no "," - but tabs as delimiters
if you still experience problems send us a few lines of the data here on the list and we can maybe see the reason.
regards
Jens Lauritsen EpiData Association
epidata-list@lists.umanitoba.ca skrev den 2013-01-09 13:46:
Dear all,
I would like to import data from the clipboard to Epidata analysis but it is not working.
The data is in excel; I select and copy the range of cells that I need to import to Epidata analysis
With Epidata analysis I select import from clipboard in the file drop down menu but i get the message below:
"Separators: (tab: 7153)(semicolon: 0)(comma: 0)(space: 0) Lines: 14753 Cannot define number of variables"
What could I be doing wrong?
WK _______________________________________________ EpiData-list mailing list EpiData-list@lists.umanitoba.ca http://lists.umanitoba.ca/mailman/listinfo/epidata-list
You should have legal epidata field names in the first row of you range. I've also got this error when trying to import text fields with commas in them. The first and last rows of your data should have no missing values. I have in the past inserted dummy data in these rows to help Analysis know what kind of data I have.
Sometimes this is an iterative process - you may get an error at a particular row and the import stops. Fix that row and so on.
The error-free strategy for messy data is to create a new worksheet and use formulas in all the cells to copy and/or fix the raw data. It is certainly worth doing if you will be repeating the process with future data sets.
Jamie
On 2013-01-09, at 7:46 AM, epidata-list@lists.umanitoba.ca wrote:
Dear all,
I would like to import data from the clipboard to Epidata analysis but it is not working.
The data is in excel; I select and copy the range of cells that I need to import to Epidata analysis
With Epidata analysis I select import from clipboard in the file drop down menu but i get the message below:
"Separators: (tab: 7153)(semicolon: 0)(comma: 0)(space: 0) Lines: 14753 Cannot define number of variables"
participants (1)
-
epidata-list＠lists.umanitoba.ca