topic Re: How to merge two data sets in New SAS User

How to merge two data sets

fongdo — Tue, 27 Aug 2019 12:41:45 GMT

I would like to merge two data sets as an example below. Could you kindly advise?

Thank you very much in advance

HAVE_1

FIRM

HAVE_2

DATE

12/08/2017

22/12/2018

06/10/2019

WANT

FIRM DATE

1 12/08/2017

1 22/12/2018

1 06/10/2019

2 12/08/2017

2 22/12/2018

2 06/10/2019

Re: How to merge two data sets

novinosrin — Tue, 27 Aug 2019 12:42:58 GMT

Try cartesian

proc sql;
create table want as
select firm, date
from have_1, have_2;
quit;

Re: How to merge two data sets

PeterClemmensen — Tue, 27 Aug 2019 12:54:35 GMT

data have_1;
input firm;
datalines;
1
2
;

data have_2;
input date :ddmmyy10.;
format date ddmmyy10.;
datalines;
12/08/2017
22/12/2018
06/10/2019
;

data want;
   set have_1;
   do i=1 to n;
      set have_2 point=i nobs=n;
      output;
   end;
run;

Re: How to merge two data sets

fongdo — Tue, 27 Aug 2019 12:57:03 GMT

Many thanks @novinosrin

Re: How to merge two data sets

fongdo — Tue, 27 Aug 2019 12:57:46 GMT

Thank a lot @PeterClemmensen