ppt课件-sasmerging-kelloggschoolofmanagement.pptVIP

Merging in SAS These slides show alternatives regarding the merge of two datasets using the IN data set option (check in the SAS onlinedoc “BASE SAS”, “SAS Language Reference: Dictionary” “Data step options” “IN=“ In the slides, the red data goes into the merged data set. The greyed out observations are left out. The perfect merge Not so perfect (if a or b;) If a=b; (both datasets contribute) If a; (must be in dataset A) If b; (must be in dataset B) Notes The examples assume there is a unique identifier. This can be either one variable (ex, CRSPs PERMNO or Compustats GVKEY) or more than on