Updating Observations

Working with SAS Data Sets

Updating Observations

Suppose you have updated data and want to change some values in the CLASS data set. For instance, suppose that the student named HENRY has had a birthday since the data were added to the CLASS data set. You can

make the data set CLASS current for input and output
read the data
change the appropriate data value
replace the changed data in the data set

First, submit an EDIT statement to make the CLASS data set current for input and output. Then use the FIND statement, which finds observation numbers and stores them in a matrix, to find the observation number of the data for HENRY and store it in the matrix d.

   > edit class;
   > find all where(name={'HENRY'}) into d;
   > print d;

                                D
                               12

List the observation containing the data for HENRY.

   > list point d;

        OBS NAME     SEX            AGE    HEIGHT    WEIGHT
     ------ -------- -------- --------- --------- ---------
         12 HENRY    M          14.0000   63.5000  102.5000

As you see, the observation number is 12. Now read the value for AGE into a matrix and update its value. Finally, replace the value in the CLASS data set and list the observation containing the data for HENRY again.

   > age=15;
   > replace;

                          1 observations replaced.

   > list point 12;

        OBS NAME     SEX            AGE    HEIGHT    WEIGHT
     ------ -------- -------- --------- --------- ---------
         12 HENRY    M          15.0000   63.5000  102.5000

Chapter Contents
Previous
Next
Top