topic Re: Conditional Merge of 2 Datasets in SAS Programming

Conditional Merge of 2 Datasets

cawada — Wed, 13 Mar 2019 12:10:47 GMT

Hi. I am trying to merge 2 datasets by ID and based on quarterly date range. How can I do this?

What I have:

ID Date

1111 01/01/2018

2222 04/03/2018

etc etc

ID Amount 01/012018-03/31/2018 Amount 04/01/2018-07/30/2018 etc

1111 $1 $2

2222 $3 $4

etc etc etc

What I want:

ID Date Amount for that period

1111 01/01/2018 $1

2222 04/03/2018 $4

Re: Conditional Merge of 2 Datasets

RW9 — Wed, 13 Mar 2019 12:23:01 GMT

That data is not presented in a way which is useful for us. Please post a datastep with some test data so we have something that actually represents the data that we can run:

https://communities.sas.com/t5/SAS-Communities-Library/How-to-create-a-data-step-version-of-your-data-AKA-generate/ta-p/258712

I can provide some tips however:

1) Re-model dataset 2, it is rarely a good idea to have wide (transposed) datasets, and will make your code far more complex and less robust. Remodel to:
ID START END AMOUNT

In this way your merge will become a lot simpler.

Re: Conditional Merge of 2 Datasets

Ksharp — Wed, 13 Mar 2019 13:06:02 GMT

" Amount 01/012018-03/31/2018" is not real or validate sas variable name.

Post your real variable name .