I have 10 SAS data set with different columns (Some columns are same, and some are different). All these data sets are without identical IDs. My goal is to combine these 10 SAS data sets to 1 single master data set with identical IDs. By doing this, I will be able to retrieve any records with their original columns from master data set by select the unique IDs. Like say, these 10 data set are from year 1990 to 2000.(e.g. DSN90 : DSN00), and I already created IDs '9000001','0900002'...for data set DSN90, and "9100001','9100002' for data set DSN91 and so on. What I want is: If I select ID='9000001' from master data set, I will get the first record of data set DSN90 with the its columns. If I select ID='9100001' from master data set, I will get the first record of data set DSN91 with the its columns. However, the columns from DSN90 is different with DSN91. What my master data set should look like? Please advise. Thanks in advance.
... View more