Hands-On SAS for Data Analysis

Updating

We will reuse the Table A data that was used for concatenation from the concatenation section here. The A_Alt table will be used to update the original dataset, that is, A.

Use the following code to update Table A:

Data A_Alt;Input City $12. Index;Datalines;Adelaide     85Beijing      90Copenhagen   .Copenhagen   65Dubai        75Dublin       95Hong Kong    83;Data A;Update A A_Alt;By City;Run;

This will result in the following output:

Here, we attempted to update Table A with A_Alt. Observe the following:

• The number of observations is different
• Observation 1 and 2 in A_Alt have different values for Adelaide and Beijing
• Observation 3 in A_Alt has a missing value ...