SAS/ACCESS Software for PC File Formats: Reference

DBLOAD Procedure Syntax

PROC DBLOAD <DBMS=pc-file-format>

<DATA=<libref.>SAS-data-set>;

Database-Description Statement

PATH='path-and-filename<.PC-file-extension>'|
<'>filename<'>|fileref ;

Editing Statements

ACCDESC=<libref.>access-descriptor;

DELETE variable-identifier-1
<...variable-identifier-n;>

ERRLIMIT=error-limit;

LABEL;

LIMIT=load-limit;<>

LIST <ALL|COLUMNS|FIELDS|
variable-identifier>;

QUIT;

RENAME variable-identifier-1=<'>column-name-1<'>
<...variable-identifier-n<'>column-name-n<'>>;

RESET ALL|variable-identifier-1 <...variable-identifier-n >;

WHERE SAS-where-expression;

Creating and Loading Statement

LOAD;

RUN;

Additional statements may be used with your PC file format. See your PC file format chapter for more information.

Description

The DBLOAD procedure creates and loads (that is, transfers data to) PC files using data from a SAS data set. This data can be from any of the following: a SAS data file, a PROC SQL view, a DATA step view, or a view descriptor from any SAS/ACCESS interface product. The DBLOAD procedure associates each SAS variable with a PC file column and assigns a default name and data type to each column. You can use the default information or change it as necessary. When you are finished customizing the columns, the procedure creates the PC file and loads it with the input data.

PROC DBLOAD Statement Options

The following options can be used in the PROC DBLOAD statement.

DBMS=pc-file-format: specifies which PC file format that you want to access. Specify DBMS=DBF for .DBF files, DBMS=DIF for .DIF files, DBMS=WK1 | WK3 | WK4 for WKn files, or DBMS=XLS for .XLS files. The DBMS= option is required.
DATA=<libref.>SAS-data-set: specifies the input data set. The input data can be retrieved from a SAS data file, a PROC SQL view, a DATA step view, or a SAS/ACCESS view descriptor. If the data set is permanent, you must use its two-level name, libref.SAS-data-set. If you omit the DATA= option, the default is the last SAS data set that was created.

Procedure Statements

To invoke PROC DBLOAD, you use the options listed in "Options" along with certain statements. The statements that you choose are determined by your task and your PC file format. These statements vary per PC file and may be optional; see your PC file format chapter for more information.

Chapter Contents
Previous
Next
Top of Page