General form, MODIFY
statement with a BY statement:
DATA SAS-data-set;
MODIFY SAS-data-set
transaction-data-set;
BY key-variable;
RUN;
SAS-data-set
is the name of the
SAS data set that you want to modify (also called the master data
set).
transaction-data-set
is the name of the
SAS data set with updated values.
key-variable
is the name of the
variable whose values are matched in the master and transaction data
sets.
|
proc print data=capacity(obs=5); run; data capacity; modify capacity sasuser.newrtnum; by flightid; run; proc print data=capacity(obs=5); run;
data m; modify m t; by a; run;
General form, MODIFY
statement with the UPDATEMODE= option:
MODIFY master-data-set
transaction-data-set
UPDATEMODE=MISSINGCHECK
| NOMISSINGCHECK;
master-data-set
is the name of the
SAS data set that you want to modify.
transaction-data-set
is the name of the
SAS data set in which the updated values are stored.
MISSINGCHECK
prevents missing values
in the transaction data set from replacing values in the master data
set unless they are special missing values. MISSINGCHECK is the default.
NOMISSINGCHECK
allows missing values
in the transaction data set to replace the values in the master data
set. Special missing values in the transaction data set still replace
values in the master data set.
|