https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Joins/m-p/450314#M29115 <TABLE><TBODY><TR><TD>SF_EMPLOYEE__C</TD><TD>SF_DIARY_ENTRY__C</TD></TR><TR><TD>employee_number__c</TD><TD>hours__c</TD></TR><TR><TD>own_labour__c</TD><TD>job_hours__c</TD></TR><TR><TD>&nbsp;</TD><TD>own_labour__c</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>On which condition we have to join to the Master dataset ?</P><P>and the condition should be like 0 as contract and 1 as non-Contract for own_labour__c</P> Mon, 02 Apr 2018 09:50:42 GMT saikiran_nemani 2018-04-02T09:50:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Joins/m-p/450314#M29115 <TABLE><TBODY><TR><TD>SF_EMPLOYEE__C</TD><TD>SF_DIARY_ENTRY__C</TD></TR><TR><TD>employee_number__c</TD><TD>hours__c</TD></TR><TR><TD>own_labour__c</TD><TD>job_hours__c</TD></TR><TR><TD>&nbsp;</TD><TD>own_labour__c</TD></TR></TBODY></TABLE><P>&nbsp;</P><P>On which condition we have to join to the Master dataset ?</P><P>and the condition should be like 0 as contract and 1 as non-Contract for own_labour__c</P> Mon, 02 Apr 2018 09:50:42 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Joins/m-p/450314#M29115 saikiran_nemani 2018-04-02T09:50:42Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Joins/m-p/450315#M29116 Too little information provided.<BR />Exactly what is you want to know/don't understand?<BR />Know your data, othwrwise you can't perform data operations. Mon, 02 Apr 2018 10:43:29 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Regarding-Joins/m-p/450315#M29116 LinusH 2018-04-02T10:43:29Z