Hi Guys, I have a input file like below: customer# start_date end_date 123abd 20140830 20150120 456efg 20130101 20140421 The history file has all the transaction for that customer with below layout customer# process_date transaction_id transaction_amt For each customer#, I need to lookup in history file and extract transaction where process_date between start_date and end_date. can anyone help me with suggestion how I can accomplish this task. Should I use PROC SQL? Best Regards, Santosh Guduru.
... View more