StatTransfer


About StatTransfer

StatTransfer is a software utility that converts data files from one proprietary format to another

  • It is available in Lehman Library's Digital Social Science Center
          in IAB323 on 10 of the 22 DSSC workstations (those where persons seated face the CUIT lab)
          in IAB215, the Data Service, on all the workstations.
  • All major statistical formats are supported like SAS [.sps], Stata [.dta], SPSS [.sav], and Excel [.xls]. Refer to the vendor page for the full list of supported formats.
  • For special instructions relating to Osiris files, see below.

StatTransfer for Windows

Navigate among screens with different functionality using the tabs across the top of the StatTransfer window. The tabs bring up the following screens.

The 'Transfer' Tab: Doing a Simple Transfer

stattransfer_tran120a_1

On the Transfer screen use the pull down menus to specify:

  • format of input file,
  • location of input file,
  • format of output file,
  • location of output file (only if you want to change the defaults).

Then click on the transfer button and you are done.

By default, all variables and cases are selected.

Use the tabs to move to screens for changing the defaults.

The 'Variables' Tab

stattransfer_var120a_1

On the Variables screen, customize the output by:

  • checking to see what variables are recognized on the input file
  • selecting variables using the variable list and the "keep" and "drop" buttons;
  • changing to the format of specific variables using the "factor type" buttons,
  • minimizing the space needed for the output using the "optimize" button

The 'Observations' Tab

stattransfer_observ12_1

The Observations screen allows you to customize cases.

Each of these operations is documented and can be done from this screen:

  • select cases by setting filters,
  • set missing values,
  • select cases by row number,
  • select based on random or fixed sampling methods.

The 'Options' Tabs

The options tabs allow for changing the default handling for specific types of variable types or formats.

  • Options(1) handles permissions, variable names and labels, missing values and date fields.
  • Options(2) handles the options for reading in ASCII files.
  • Options(3) handles the options for reading SAS files.
  • Options(4) handles the output options for SAS and options for JMP and R files.

StatTransfer for Windows

Osiris is a format once used by ICPSR and may still be found in older studies.

  • Osiris data always has a data file and a dictionary file.
  • For input into StatTransfer;
    • both files must have the same file name;
    • the dictionary file must have the extension .dct or .dict;
    • the data file must have the extension .dat.
  • The File Specification input box must be the dictionary file.

Special SAS Options in Stat/Transfer

Stat/Transfer can use value labels stored in a PROC FORMAT libraries, however, these labels must first be converted to a special format. To do this, run the following SAS program:

libname mylib "[path]";
proc format library=mylib cntlout=mylib.sas_fmts;
run;

where path is the full path to the directory that contains your format library. You must use .sas_fmts as the file name. The resulting file will have the name sas_fmts.sas7bdat.

Once you have prepared the format library, you must set two options within Stat/Transfer:

set read-sas-fmts yes
set read-fmt-name sas_fmts.sas7bdat

Now you are ready to do the transfer. For example:

copy mydata.sas7bdat mydata.por

Note that Stat/Transfer cannot convert all types of SAS PROC FORMAT definitions. In particular, you will lose definitions of the type:

VALUE DAYFMT  0 = 'DIDNT HAVE WAIT'
                        1-24 = 'LESS THAN 1 DAY'
                        24-48 = '1 UP TO 2 DAYS';


For more information about StatTransfer visit Lehman Library's Digital Social Science Center or email eds@columbia.edu