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!
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.
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.
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!
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.