Two ways of importing data to Amos

By Riya Jain & Priya Chetty on February 17, 2022

To work with Structural Equation Modeling (SEM) test in Amos, the first step is to import data to Amos. The previous article explained the terminologies of the SEM test. This article explains the procedures for importing data to Amos. A dataset can be imported to Amos in two ways.

Opening Amos application from SPSS

The first step is importing the dataset into the SPSS spreadsheet, and then loading it in Amos. After doing so, the below window should appear in SPSS.

An example dataset in SPSS software
Figure 1: An example dataset in SPSS

After this, click on ‘Analyze’ and then ‘IBM SPSS Amos’ to open Amos.

Opening Amos from SPSS
Figure 2: Opening Amos from SPSS

Once Amos opens, a new graphics file will open as shown below.

Amos interface to import a dataset
Figure 3: Amos interface to import a dataset

After this, save the file by clicking on ‘Save’ under ‘File’. Select the desired location, enter the file name and then click on ‘Save’ for saving the document.

View the list of imported variables in Amos

By clicking on the icon, the imported variables list can be viewed, as shown in the image below.

List of variables in Amos
Figure 4: List of variables in Amos

Now that the dataset has been successfully imported path analysis, SEM analysis and other tests can be performed on Amos.

Importing data to Amos directly

The other and most commonly used method is to import data to Amos by using the application’s import function. For this, first, open the Amos graphics application.

Amos graphics window after importing data to Amos
Figure 5: Amos graphics window after importing data to Amos

Next, save the Amos graphics.

 Click on it to select the data file icon. The below window will appear.

Data files selection window in SPSS Amos
Figure 6: Data files selection window in SPSS Amos

On this window, click on the file name to specify the data file name. The ‘View Data’ option launches the external data file application such as MS Excel or SPSS file.

For example; to know the name of a data file and to select by using the file name, then use the ‘View Data’ option to cross-check the content of that data file as Amos launches the original data file. The ‘Grouping variable’ option allows to specifically mention the variable responsible for grouping in the database. This eases model testing and enables easy set up of the model in the case of multiple groups presence.

Amos allows accessing different file formats like:

  • MS Access
  • dbase 3-5
  • Microsoft Excel 3, 4, 5, and 8
  • Fox pro files 2.0, 2.5, and 2.6
  • lotus wk1, wk3, and wk4
  • spss .sav files

The below window appears when ‘File Name’ is clicked. Select the file which to import and click on ‘Open’.

Selecting the file to import to Amos
Figure 7: Selecting the file to import to Amos

The below window will appear.

Viewing the data file properties in Amos after importing
Figure 8: Viewing the data file properties in Amos after importing

In this window, ‘N’ represents the number of observations present in the selected file, which is 200 in this case. Once the file is loaded click on ‘OK’ for final importing. With this, the entire dataset is successfully loaded. Now formulate a model in Amos using different tests.

NOTES

Priya is the co-founder and Managing Partner of Project Guru, a research and analytics firm based in Gurgaon. She is responsible for the human resource planning and operations functions. Her expertise in analytics has been used in a number of service-based industries like education and financial services.

Her foundational educational is from St. Xaviers High School (Mumbai). She also holds MBA degree in Marketing and Finance from the Indian Institute of Planning and Management, Delhi (2008).

Some of the notable projects she has worked on include:

  • Using systems thinking to improve sustainability in operations: A study carried out in Malaysia in partnership with Universiti Kuala Lumpur.
  • Assessing customer satisfaction with in-house doctors of Jiva Ayurveda (a project executed for the company)
  • Predicting the potential impact of green hydrogen microgirds (A project executed for the Government of South Africa)

She is a key contributor to the in-house research platform Knowledge Tank.

She currently holds over 300 citations from her contributions to the platform.

She has also been a guest speaker at various institutes such as JIMS (Delhi), BPIT (Delhi), and SVU (Tirupati).

 

I am a master's in Economics from Amity University. Having a keen interest in Econometrics and data analysis, I was a part of the Innovation Project of Daulat Ram College, Delhi University. My core expertise and interest are in environment-related issues. Apart from academics, I love music and exploring new places.

Discuss

2 thoughts on “Two ways of importing data to Amos”