After you have imported the DBase file, you must check whether this is the case.
The number 9999 will be used to code missing values in a field with width of 4 characters, etc. in a field with a maximum number of characters (field width) of 3, the number 999 will indicate a missing value. In DBase files missing values are often coded by the maximum value possible in the corresponding field (column). When you click Cancel the procedure will be aborted. After you have finished selecting the variables, click OK. The file type DBase file must be used when you want to import a database file (with file name extension DBF) created by DBase III+ and compatible programs.Īfter you have selected the file name in the File selector box, select the names of the fields to be imported in MedCalc using the Select variables dialog box (see SPSS files). When you have finished selecting variables, click OK. To unselect a selected variable, click it again. The names of the selected variables are displayed in reverse. If you do not want to import all variables, then select the names of the variables you require by clicking the variables' names. If you want to import all variables, i.e.
The available variables in the file are listed in the box at the left side of the dialog box. When you open an SPSS data file (with file extension sav), MedCalc will present a Select variables dialog box in which you select the names of the variables to be imported in MedCalc.
MedCalc can read the data from OpenDocument spreadsheet files (*.ods) created by the Calc program of the LibreOffice or OpenOffice software packages. Note that it is usually faster to open the Excel file in Excel and next copy and paste the data from Excel to MedCalc. NET Framework 4.0 (a free download from Microsoft). On Windows versions prior to Windows 8 or Windows Server 2012, support for Excel *.xlsx files requires Microsoft.
It is advised that you always download and install the latest version of MedCalc. However, previous MedCalc versions may not be able to read the data files written by some newer versions of the software. MedCalc will automatically convert old files as you open and save them. To close and unlock the file, you select the New command.įrom time to time the MedCalc file format is revised. When you open a MedCalc data file (which have file extension MC1) MedCalc will lock the open file, preventing other programs and users access to the file. Text files (*.txt, *.csv, *.prn) MedCalc files (*.mc1).to combine two files into one, then select the Add file command. If you want to read a MedCalc data file without erasing existing data in memory, e.g. Together with the spreadsheet data the associated notes are loaded and the options that are also included in the MedCalc data file. In the file selector box you can select the name of the file to be read into memory.