Export data

Selection of LIMS software should take into account both data compatibiUty and ease of use. Since a LIMS is one information system within an organization, it may need to share data with other systems. Therefore, the software should be capable of sharing data directiy or exporting data into compatible formats. 

Production and export data for U.S. borates are given in Table 15. Most United States exports are shipped to Europe, via Rotterdam, the Netherlands. In 1989 exports of borates from the United States were, in decreasing order (101) the Netherlands, Japan, Canada, Spain, Mexico, Taiwan, and South Korea. 

Consumption includes sold or used, minus exports. Data on quantities sold or used is from the quarterly gypsum canvasses of the nongypsum board producers, annual canvasses of all producers, and from data furnished by the Gypsum Association. 

In 1972, 5.68 million kg of methyl parathion were exported from the United States (HSDB 1999). Exports dropped to 3.01 million kg in 1984 (Bureau of the Census 1984). However, in 1985, exports inereased to 4.14 million kg (Bureau of the Census 1986). No reeent import/export data addressing methyl parathion are available. 

Technical endosulfan is no longer produced in the United States therefore, it is no longer exported. Data on export of formulated products containing endosulfan were not located. 

Clinical trial data that is not sent to the FDA can be exported from SAS in many ways other than SAS XPORT format files or ODM XML. This section discusses the numerous ways to export data from SAS to entities other than the FDA. 

Because the Microsoft Office suite is so widely used, it is sometimes necessary for you to export SAS data sets into Microsoft Access or Microsoft Excel files. SAS provides the Export Wizard/PROC EXPORT and the SAS Enterprise Guide interface for exporting data directly to Microsoft Office files. 

All modern relational databases include the ability to export tables as XML files. It is usually possible to apply an XSLT transformation to the data as part of the export procedure. In the interest of simplicity and compatibility across different databases, no special transformation was applied to the tables extracted from the New Brunswick till database. Therefore, after exporting data out of MS Access in a generic XML format, the first XSLT transformation involves restructuring the data to conform to a Geochemical Survey XML schema, developed at the GSC (Adcock 2009b). The second transformation produces a set of files which conform to the GML schema (OGC, 2007). KML shares many features with GML, and hence the third and final GML-to-KML transformation is very simple. 

---