home | schedules | software | help | who we are | about | workshops | links | data access | contact us | print version

AMT home page ITS home page Yale Front Door Contact us Search Yale Statlab

<  July 2008 >
(Leap Year)
Su Mo Tu We Th Fr Sa
    1
 2
 3
 4
 5
6
 7
 8
 9
 10
 11
 12
13
 14
 15
 16
 17
 18
 19
20
 21
 22
 23
 24
 25
 26
27
 28
 29
 30
 31

Reserve a classroom

Schedule for
07/03/2008

Main Lab
140 Prospect St.
Room 101
No Events Today

Brewster Hall
124 Prospect St.
Room B-13
No Events Today

Consultant's Desk
140 Prospect St.
Room 100
10am- 1:30pm Matt Johnson
1:30- 5pm Kyle Hood

schedules

software

help

who we are

data access

about

workshops

links

DBMS/COPY converts datasets between different software formats. It supports a whole range of formats, from ASCII text files to Excel spreadsheets and SAS datasets.

Make sure your input data file names have the standard three-charcter extension. For example an Excel file has a default extension of .XLS , SAS 6.04 uses .SSD . If the file you want to translate does not have the default extension, DBMS/COPY will not recognize it.

Interactive Converting

In the following we describe step by step the process of converting a dataset.
  1. Start DBMS/COPY by clicking the icon in the Windows Application Group.
  2. In the DBMS/COPY Program Window, click Interactives.
  3. In the Input Database Window, select the format of your original file in Files of Type.
  4. Depending on the type of your original file, you have to supply different information.
    Original File is a Spreadsheet
    In the SpreadSheet Grabber, select the Data Area by either dragging the mouse or using the cursor keys while holding down the shift key.
    Still in the SpreadSheet Grabber, select the row of Variable Names (if you supply them)
    Original File is an ASCII file
    In ASCII Input Format Options, check the options.
    In the ASCII Dictionary Builder, check the variable names and types as well as the exact length of each variable.
  5. In the Power Panel, you get a chance to filter data and drop or rename variables.
    Let's assume, we don't want any change, so click OK.
  6. In the Output Database Window, select the format you want to convert to in List Files of Type
  7. In the Transfer Verification Window, you can save this batch file, if you plan to rerun the conversion.
    Usually, you just click Do-It!
  8. The Processing Window displays some information on the status of conversion.
    If you don't plan to convert a second dataset, close it by clicking Done

Batch mode

While most users will find the ability to translate files using the interactive screen sufficient, DBMS/COPY includes a batch language. This feature is most useful for people who need to perform repeated conversions of the same files or are simply looking for an easy way to make modifications to their datasets, without going through all these different menus.

The easiest way to use the batch language is, converting one dataset interactively, and save the batch file displayed in the Transfer Verification Window. Now you can edit this file and run it again using Open Batch in DBMS/COPY.

Other resources