Hi, I am facing issue related to macro. I have created macro Trans_data_IncrementLoad and Business_freez_dates which contains multiple do loop and if condition. In Trans_data_IncrementLoad macro there are multiple do loop and inside one of do loop I am using oracle pass through , which insert data into trans_data table by joining 2 table. Macro Business_freez_dates also contains multiple do loops and if condition and it create the dataset which contains the business date's for which incremental load should happen. once dataset created which contains the business date's for which incremental load should happen, I'm calling Trans_data_IncrementLoad macro from data step. Issue facing: Now issue is that most of the time my code running successfully but sometime it seems that code not completing it's execution. ex: suppose 100 obs needed to be inserted into trans_data but it inserting only 10 obs in trans_data table, but later if I run the code again then it properly inserting 100 obs in trans_data. I am really not able to figure out why this kind of issue coming. I am attaching the screenshot of code structure, it's not entire code but sample of code. screenshot 1: Screenshot 2: screenshot 3: Thanks in advance for your valuable solution/suggestion/advice and would be very grateful for your valuable input.
... View more