Mplus version 5.2 was used for these examples.
1.0 Entering free format data
Data files for Mplus are just plain ASCII text files. "Free format", where the values for
each of the variables are separated by a delimiter like a blank or a comma, is
one way in which data can be found in a text file. The
example below contains the first 20 lines from a file called
https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsb-1.dat. Here you can see the
variables are separated by commas, and the variable names are not on the
first line. The
variables in the file are id, female, race, ses, schtyp,
prog, read, write, math, science and socst.
70,0,4,1,1,1,57,52,41,47,57 121,1,4,2,1,3,68,59,53,63,61 86,0,4,3,1,1,44,33,54,58,31 141,0,4,3,1,3,63,44,47,53,56 172,0,4,2,1,2,47,52,57,53,61 113,0,4,2,1,2,44,52,51,63,61 50,0,3,2,1,1,50,59,42,53,61 11,0,1,2,1,2,34,46,45,39,36 84,0,4,2,1,1,63,57,54,58,51 48,0,3,2,1,2,57,55,52,50,51 75,0,4,2,1,3,60,46,51,53,61 60,0,4,2,1,2,57,65,51,63,61 95,0,4,3,1,2,73,60,71,61,71 104,0,4,3,1,2,54,63,57,55,46 38,0,3,1,1,2,45,57,50,31,56 115,0,4,1,1,1,42,49,43,50,56 76,0,4,3,1,2,47,52,51,50,56 195,0,4,2,2,1,57,57,60,58,56 114,0,4,3,1,2,68,65,62,55,61 85,0,4,2,1,1,55,39,57,53,46
The Mplus commands to read the data are shown below. These are the
commands that you can enter into a blank Mplus text file and save as an
input file (.inp). The title, data and variables command blocks are required.
The Analysis command block
is included so that we can check the data. We will go into this command block
in more detail in the next unit.
Title:
Entering data example free format using https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsb-1.dat
Data:
File is "D:/https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsb-1.dat";
Variable:
Names are
id female race ses schtyp prog read write math science socst;
Usevariables are
id female race ses schtyp prog read write math science socst;
Analysis:
Type = basic;
After saving and running the .inp file, you can look in the output file for
"INPUT READING TERMINATED NORMALLY" appearing below the entered code. This is a
good first check that your data were read in successfully. We will discuss
further checks in the next section.
2.0 Entering fixed format data
The file https://stats.idre.ucla.edu/wp-content/uploads/2016/02/fixed-1.dat contains ten observations with the data in fixed columns.
The codebook for the data is given below.
195 094951 26386161941 38780081841 479700 870 56878163690 66487182960 786 069 0 88194193921 98979090781 107868180801
codebook variable name column number id 1-2 a1 3-4 t1 5-6 gender 7 a2 8-9 t2 10-11 tgender 12
Fixed format data are handled using a fortran-type format statement in the
data command
block. The Mplus commands are shown below. 3F2.0 indicates that
the file begins with three variables each of length two. These are
followed by one variable of length one (F1.0), then two of length 2
and one of length 1 (2F2.0, F1.0). This matches what we see in
the codebook.
Title:
Entering data example fixed format using https://stats.idre.ucla.edu/wp-content/uploads/2016/02/fixed-1.dat
Data:
File is "D:/https://stats.idre.ucla.edu/wp-content/uploads/2016/02/fixed-1.dat";
Format is (3F2.0, F1.0, 2F2.0, F1.0);
Variable:
Names are
id a1 t1 gender a2 t2 tgender;
Usevariables are
id a1 t1 gender a2 t2 tgender;
Analysis:
Type = basic;
Again, after saving and running this input, you can check the output to see
if “INPUT READING TERMINATED NORMALLY” appears.
3.0 Entering data using Stata
If you are a Stata user, ATS has written a command, stata2mplus, that will
convert a Stata dataset to an Mplus ASCII data file plus the necessary commands
to read in the data. You can get the stata2mplus ado file by typing
search stata2mplus.Here is the Stata command to load and convert the Stata dataset hsb2.dta to Mplus.
It generates a .dat file containing the dataset and the input file
needed to read the dataset into Mplus. It stores both in the present
working directory in Stata (enter pwd to get the path) with the
dataset name: hsb2.dat and hsb2.inp.
use "https://stats.idre.ucla.edu/stat/stata/notes/hsb2.dta", clear stata2mplus using hsb2 Looks like this was a success. To convert the file to mplus, start mplus and run the file hsb2.inp
The code from the input file created appears below. The file contains more detail
about the data file than our earlier examples but all of the same command
blocks are present. Again, the analysis type = basic is included to
allow you to run descriptive statistics in order to insure that the data
were input correctly.
Title:
Stata2Mplus conversion for hsb2.dta
List of variables converted shown below
id :
female :
0: male
1: female
race :
1: hispanic
2: asian
3: african-amer
4: white
ses :
1: low
2: middle
3: high
schtyp : type of school
1: public
2: private
prog : type of program
1: general
2: academic
3: vocation
read : reading score
write : writing score
math : math score
science : science score
socst : social studies score
Data:
File is hsb2.dat ;
Variable:
Names are
id female race ses schtyp prog read write math science socst;
Missing are all (-9999) ;
Usevariables are
id female race ses schtyp prog read write math science socst;
Analysis:
Type = basic ;
4.0 Entering missing data using Stata
Our next example of entering data is to enter a version of the hsb
dataset that has missing data. Below is the Stata code for reading the
missing data file and converting
it to an Mplus data file along with an Mplus input file (hsbmis.inp).
use https://stats.idre.ucla.edu/stat/mplus/seminars/IntroMplus/hsbmis.dta, clear stata2mplus using hsbmis Looks like this was a success. To convert the file to mplus, start mplus and run the file hsbmis.inp
The input file for this example is identical to the previous
example except for the file name.
5.0 Entering data from SPSS
If you are an SPSS user, you can prepare your data to be read into Mplus with a few steps detailed in
SPSS FAQ: How can I move my data from SPSS to Mplus?.
Starting from the hsb2.sav dataset, once
you have created a .csv file, https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsb2.csv, without variable names, the code below can read
in your data.
Title: Entering data from SPSS Data: File is "D:/data/https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsb2.csv"; Variable: Names are id female race ses schtyp prog read write math science socst; Analysis: Type = basic;
6.0 Entering missing data from SPSS
If your SPSS data contains missing data, complete the same steps you would for non-missing SPSS
data, but note the values used for missing values. For example, if -999 is
the value used in coding missing values, then the previous example’s code
would be amended with a Missing line in the Variable: block
indicating this. Below, we use https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsbmis.csv.
Title:
Missing data from SPSS
Data:
File is "D:datahttps://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsbmis.csv" ;
Variable:
Names are
id female race ses schtyp prog read write math science socst;
Missing are all (-999) ;
Analysis:
Type = basic ;
7.0 Entering missing data from a raw data file with dots (.)
Our last example of entering data is entering data with a raw data file
that has dots (.) to represent missing values. Say that you had a data file
that was either comma separated, tab separated, or space separated where .
was used to indicate missing values. You can indicate such missing
values with a Missing are .; statement in the variable block like in
the example below which reads the https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsbmisdot-1.dat
data file.
Title: Missing with dots; Data: File is https://stats.idre.ucla.edu/wp-content/uploads/2016/02/hsbmisdot-1.dat ; Variable: Names are id female race ses schtyp prog read write math science socst; Missing are .; Analysis: Type = basic;
The results of this are identical to the above example.