@Patrick My clarification for your queries. 1. You've got a "large" source table with dates - right? yes 2. You've got a reference table with dates which are holidays - yes 3. You want to add a column to your large source table which contains a count of remaining working days - yes i have a large dataset it contains 2 lack observations and around 150 variables. In this job date variables are there. in date variable date count i want(31MAR2017-date) without repeating the count is correct but my values are repeating so my count is decreasing 1 for every repeating value,it effect to all other values,so i need to change code for your conformation a) All dates that are not in the holidays reference table - yes b) Count per month so last day of month gets always a count of zero - yes thanks Rajkumar
... View more