Hi, all
I want to merge to datasets
data1 has VAR1 VAR2 VAR3 year
data2 has VAR1 VAR2 VAR4 VAR 5 year
I use proc sql left join data1 with data2 with the following conditions :
data1.var1=data2.var1
1993<year<2000
i got error using the code below:
proc sql;
create table WANT as select
A.*, B.*
From DATA1 as A left join DATA2 as B
WHERE 1993<=YEAR<=2000
On A.VAR1 =B.VAR2
order by VAR1, year;
quit;
please help and Thanks!
Lan
Let me try to guess and at least give you a starting point :
proc sql;
create table WANT as select
A.*, B.VAR4, B.VAR5
From DATA1 as A left join DATA2 as B
on A.VAR1=B.VAR1 and A.VAR2=B.VAR2 and A.year=B.year
WHERE A.year between 1993 and 2000
order by VAR1, year;
select * from WANT;
quit;
PG
Which of the two YEAR variables do you want to subset on?
Perhaps you want to add the condition that A.year = B.year ?
Since you are doing a LEFT JOIN perhaps you want to subset on A.year ? Or perhaps both?
Let me try to guess and at least give you a starting point :
proc sql;
create table WANT as select
A.*, B.VAR4, B.VAR5
From DATA1 as A left join DATA2 as B
on A.VAR1=B.VAR1 and A.VAR2=B.VAR2 and A.year=B.year
WHERE A.year between 1993 and 2000
order by VAR1, year;
select * from WANT;
quit;
PG
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.