05-11-2015 02:27 AM
I have two data sets with collective ID variables. That is, each of these variable may not be unique across the data set (i.e., duplicated), but together they form a unique set of ID. Suppose the first hypothetical data set looks like:
ID1 ID2 Var1 Var2
The second hypothetical data set looks like:
ID1 ID2 Var3 Var4
So how can I merge these variable using data step?
05-11-2015 04:15 AM
You can also use SQL joins, example:
create table WANT as
select COALESCE(A.MAKE,B.MAKE) as MAKE,
A.MODEL as BASE_MODEL,
B.MODEL as COMP_MODEL
from SASHELP.CARS A
full join SASHELP.CARS B
Need further help from the community? Please ask a new question.