DATA Step, Macro, Functions and more

Creating dataset with Unique list of ID's and dates

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Creating dataset with Unique list of ID's and dates

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!


Accepted Solutions
Solution
‎02-15-2018 08:33 AM
Frequent Contributor
Posts: 112

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

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.

View solution in original post


All Replies
Solution
‎02-15-2018 08:33 AM
Frequent Contributor
Posts: 112

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

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.

New Contributor
Posts: 4

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

Posted in reply to Satish_Parida

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!

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 161 views
  • 0 likes
  • 2 in conversation