Characteristics of variables
in the DATA= data set
|
FORCE required?
|
Consequences of using
the FORCE option
|
---|---|---|
They are in the BASE=data
set, but the BASE= data set has more variables.
|
no
|
Missing values are assigned
to the extra BASE= data set variables.
|
They are not in the
BASE= data set.
|
yes
|
Extra DATA= data set
variables are dropped.
|
They are longer than
the corresponding variables in the BASE= data set.
|
yes
|
DATA= data set variable
values might be truncated.
|
They do not have the
same type as the corresponding variables in the BASE= data set.
|
yes
|
Missing values are assigned
to the DATA= data set variables with the data type mismatch.
|
data quarter (drop=monthnum midmon lastmon); monthnum=month(today()); midmon=month(intnx('month',today(),-1)); lastmon=month(intnx('month',today(),-2)); do month = monthnum, midmon, lastmon; nextfile="c:sasusermonth" !!compress(put(month,2.)!!".dat",' '), do until (lastobs); infile temp filevar=nextfile end=lastobs; input Flight $ Origin $ Dest $ Date : date9. RevCargo : comma15.; output; end; end; stop; run;