Help using Base SAS procedures

repeat data based on set of dates

Reply
Frequent Contributor
Frequent Contributor
Posts: 79

repeat data based on set of dates

I have a set of dates in dataset A

A

07/30/2001

08/01/2006

09/30/2005 etc

and I have another dataset B which has dates and some columns... I would like to create a new dataset that  repeat each row B for all dates in A that lie between any 2 dates in B ... such that the final dataset has all dates from A and B ...

dataset

B

dates       values       num

06/30/2001    2         5

06/30/2005    3          8


Final set

dates       values       num

06/30/2001    2         5

07/30/2001    2         5

06/30/2005    3          8

08/01/2006    3         8

09/30/2005    3          8

Thanks for your help!

Ask a Question
Discussion stats
  • 0 replies
  • 138 views
  • 0 likes
  • 1 in conversation