SAS How to transfer a field with different values to another table (like a left join with condition)

t34 — Fri, 23 Oct 2020 20:21:13 GMT

Hello,

I show you what I want to do. I have to tables: have1 and have2 and I want to have the table "want". If date of have2 is between start_date and end_date I want to copy this field.

Please, can you help me with this?

Thanks for your help!!

data have1;
informat Start_Date End_Date ddmmyy10.;
format Start_Date End_Date ddmmyy10.;
input id  Start_Date  End_Date;
datalines;
10 08/02/2020 07/03/2020
10 02/10/2020 18/10/2020
;;;;
run;
data have2;
infile datalines delimiter=',';
informat Date ddmmyy10.;
format Date  ddmmyy10.;
input id  Date  ;
datalines;
10,01/01/20
10,15/02/20
10,01/04/20
10,05/05/20
10,05/10/20
;;;;;
run;
data want;
infile datalines delimiter=',';
informat Date Start_Date End_Date ddmmyy10.;
format Date Start_Date End_Date ddmmyy10.;
input id  Date  Start_Date  End_Date;
datalines;
10,01/01/20,.,.
10,15/02/20,08/02/2020,07/03/2020
10,01/04/20,.,.
10,05/05/20,.,.
10,05/10/20,02/10/2020,18/10/2020
;;;;
run;

Re: SAS How to transfer a field with different values to another table (like a left join with condit

ballardw — Fri, 23 Oct 2020 19:56:58 GMT

Your have2 does not have a value of 15/02/20. Is that a typo?

Re: SAS How to transfer a field with different values to another table (like a left join with condit

t34 — Fri, 23 Oct 2020 20:18:16 GMT

Yes, It has got it. It´s a typo. thanks

topic Re: SAS How to transfer a field with different values to another table (like a left join with condit in New SAS User

SAS How to transfer a field with different values to another table (like a left join with condition)

Re: SAS How to transfer a field with different values to another table (like a left join with condit

Re: SAS How to transfer a field with different values to another table (like a left join with condit