topic Creating dataset with Unique list of ID's and dates in SAS Programming

Creating dataset with Unique list of ID's and dates

Scott13 — Thu, 15 Feb 2018 13:20:13 GMT

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

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!

Re: Creating dataset with Unique list of ID's and dates

Satish_Parida — Thu, 15 Feb 2018 13:27:41 GMT

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.

Re: Creating dataset with Unique list of ID's and dates

Scott13 — Thu, 15 Feb 2018 13:33:21 GMT

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!