The basic command used when running the Stat/Transfer command processor is COPY, which has the following form:
infilename.ex1 outfilename.ex2 -x1 -x2 ...
where infilename.ex1 and outfilename.ex2 are the input and output files, respectively and .ex1 and .ex2, are standard extensions used to determine the type of file that is read and written. The file names can be complete file specifications.
An alternative for specifying the file type is to use a file-type tag instead of a standard extension.
Parameters -xi following the file names allow some options to be selected, such as selecting tables and pages, optimization of variables or controlling messages from Stat/Transfer.
You can give additional commands before you give the COPY command. These allow you to select cases and variables, to manually change output variable types, to set a number of options and to use other commands. (Note that these commands can be given only at the Stat/Transfer prompt or in a command file or in a startup file. They cannot be used when running interactively from the operating system prompt.)
If no commands for selecting cases or variables are given, then by default, all of the variables and cases will be transferred.
For example, to copy all of the variables and all of the cases from an Excel file, indata.xls, to a SAS file, outdata.sas7bdat, type:
copy indata.xls outdata.sas7bdat
where the file type is given by using standard extensions.
Instead of entering commands directly, you can store them in a command file and execute that file at the Stat/Transfer prompt.