Thank you for the suggestion of using coalesce! I have gotten the desired results with the following code: Select a.Acct ,a.EntryDte ,coalesce(min(b.PostDte), min(a.EntryDte)) as PostDate
... View more
Use a datastep? Extract data from the database, then run a proc surveryselect over that to get your sample:
https://support.sas.com/documentation/cdl/en/statug/63347/HTML/default/viewer.htm#statug_surveyselect_sect003.htm
... View more
