Creating dataset with Unique list of ID's and dates

[Scott13]

Hi all.  I have what I feel should be a simple question, but seem to be struggling to find a way to do it.  Ex:  I have a dataset that contains a list of 10 ID's and I have a separate dataset that contains 6 years of month end dates.  There is not a join key between the 2 files, but I need to have all dates grouped into each ID.

Dataset 1 contains list of unique ID's

ID

1

2

3

Dataset 2 contains list of month dates

MonthEndDates

Mar 2016

Apr 2016

May 2016

I am looking for a way to create this

ID 1  Mar 2016

ID 1 Apr 2016

ID 1 May 2016

...

ID 2 Mar 2016

ID 2 Apr 2016

and so on.  Any help would be greatly appreciated!

[Satish_Parida · Accepted solution]

This will work

data tab1;
input id;
cards;
1
2
3
;
run;

data tab2;
input mend:date9.;
format mend date9.;
cards;
31Jan2018
28Feb2018
31Mar2018
;
run;

proc sql;
create table want as
select * from tab1,tab2
order by id;
quit;

Let us know if it worked for you.

[Scott13]

It appears that did exactly what I needed.  I am a little embarrassed that it was something so easy...I think I was over complicating it!  Thank you for your help!