If you want missing values in the transaction data set to replace existing values in the master data set, use UPDATEMODE=NOMISSINGCHECK.
This variable is initialized to 0 and is set to 1 when UPDATE processes the last observation. However, to reduce processing time, you can create a transaction data set that contains only those variables that are being updated.
If you want the resulting value in the master data set to be a regular missing value, use a single underscore (_) to represent missing values in the transaction data set.
The resulting value in the master data set will be a period (.) for missing numeric values and a blank for missing character values.
For more information about defining and using special missing value characters, see MISSING Statement. WEEK4, and its values in the master data set should be unique: This example shows renaming a variable in the FITNESS data set so that it will not overwrite the value of the same variable in the program data vector. 4 gain 1994 mark yellow 165 174 9 5 same 2304 joe red 170 170 0 options nodate pageno=1 linesize=80 pagesize=60; /* Create the Master Data Set */ data payroll; input ID SALARY; datalines; 011 245 026 269 028 374 034 333 057 582 ; /* Create the Transaction Data Set */ data increase; input ID SALARY; missing A _; datalines; 011 376 026 .
These program statements create a new data set (OHIO. Also, the WEIGHT variable is renamed in each data set and a new WEIGHT variable is calculated.