General Import/Export

AM can directly import/export data from/to a large number of databases directly as well as via ODBC. This functionality requires AM's DFTransfer component.

If DFTransfer is not installed, you can get it from http://am.air.org.

You can access the general import/export component from the file menu (File|Import|General Import.). If the component is installed, this selection will bring up a dialog box that will enable you to import your data.

If you are going to use the MML procedures, you may still require a dictionary file after you import data. The MML procedures for test data require that tests and item parameters be specified (see Importing AM text for more details). In these cases, your dictionary need only include the data that is not included in the dataset header.Specifically, the dictionary must contain information about the tests, such as item parameters and the arrangement of items into subtests. After the initial import, select File|Update Metadata from the File menu to read in the dictionary.

The DFTransfer component is built on the import/export engine from DataFlux(tm), which we have licensed for distribution and distribute with AM. The component comes with it's own help system, so press the help button on the dialog box. A few important things to keep in mind:

Attention SAS(tm) users:

If you want to preserve your SAS value labels (formats), you have to save them as a SAS dataset first. You can do this by running the following line in SAS:

proc format data=XXX cntlout=yyy;

where xxx is your SAS dataset and yyy is the new dataset to be created. When importing, you will be prompted to specify which dataset contains the formats.

When exporting data to SAS, the value labels (formats) will be output in a sas program named zzz.pgm, where zzz is the name of the file to which you exported. You should use this program to create the formats prior to reading the SAS file. if you choose not to use the formats, you will have to add the following system option to your SAS program:

options nofmterr;