https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880364#M347851 <P>Hi friends,&nbsp;</P><P>&nbsp;</P><P>I have two tables salary and department . I need to bring that particular department in to the salary table. Please throw me some ideas</P><TABLE><TBODY><TR><TD>emp_no</TD><TD>salary</TD><TD>from_date</TD><TD>to_date</TD></TR><TR><TD>10010</TD><TD>72488</TD><TD>24/11/1996</TD><TD>24/11/1997</TD></TR><TR><TD>10010</TD><TD>74347</TD><TD>24/11/1997</TD><TD>24/11/1998</TD></TR><TR><TD>10010</TD><TD>75405</TD><TD>24/11/1998</TD><TD>24/11/1999</TD></TR><TR><TD>10010</TD><TD>78194</TD><TD>24/11/1999</TD><TD>23/11/2000</TD></TR><TR><TD>10010</TD><TD>79580</TD><TD>23/11/2000</TD><TD>23/11/2001</TD></TR><TR><TD>10010</TD><TD>80324</TD><TD>23/11/2001</TD><TD>01/01/9999</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>emp_no</TD><TD>dept_no</TD><TD>from_date</TD><TD>to_date</TD></TR><TR><TD>10010</TD><TD>d004</TD><TD>24/11/1996</TD><TD>26/06/2000</TD></TR><TR><TD>10010</TD><TD>d006</TD><TD>26/06/2000</TD><TD>01/01/9999</TD></TR></TBODY></TABLE> Tue, 13 Jun 2023 09:44:10 GMT nxmogil 2023-06-13T09:44:10Z https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880364#M347851 <P>Hi friends,&nbsp;</P><P>&nbsp;</P><P>I have two tables salary and department . I need to bring that particular department in to the salary table. Please throw me some ideas</P><TABLE><TBODY><TR><TD>emp_no</TD><TD>salary</TD><TD>from_date</TD><TD>to_date</TD></TR><TR><TD>10010</TD><TD>72488</TD><TD>24/11/1996</TD><TD>24/11/1997</TD></TR><TR><TD>10010</TD><TD>74347</TD><TD>24/11/1997</TD><TD>24/11/1998</TD></TR><TR><TD>10010</TD><TD>75405</TD><TD>24/11/1998</TD><TD>24/11/1999</TD></TR><TR><TD>10010</TD><TD>78194</TD><TD>24/11/1999</TD><TD>23/11/2000</TD></TR><TR><TD>10010</TD><TD>79580</TD><TD>23/11/2000</TD><TD>23/11/2001</TD></TR><TR><TD>10010</TD><TD>80324</TD><TD>23/11/2001</TD><TD>01/01/9999</TD></TR></TBODY></TABLE><P>&nbsp;</P><TABLE><TBODY><TR><TD>emp_no</TD><TD>dept_no</TD><TD>from_date</TD><TD>to_date</TD></TR><TR><TD>10010</TD><TD>d004</TD><TD>24/11/1996</TD><TD>26/06/2000</TD></TR><TR><TD>10010</TD><TD>d006</TD><TD>26/06/2000</TD><TD>01/01/9999</TD></TR></TBODY></TABLE> Tue, 13 Jun 2023 09:44:10 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880364#M347851 nxmogil 2023-06-13T09:44:10Z https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880366#M347852 <P>Please explain the logic you are using here. Please explain what the desired output is.</P> Tue, 13 Jun 2023 11:02:51 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880366#M347852 PaigeMiller 2023-06-13T11:02:51Z https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880379#M347857 <P>I want the output like this . But then if you observe the employee is with d004 department till 26th june 2000. I am really not having any clue how to do this</P><TABLE><TBODY><TR><TD>emp_no</TD><TD>salary</TD><TD>from_date</TD><TD>to_date</TD><TD>Department</TD></TR><TR><TD>10010</TD><TD>72488</TD><TD>24/11/1996</TD><TD>24/11/1997</TD><TD>d1004</TD></TR><TR><TD>10010</TD><TD>74347</TD><TD>24/11/1997</TD><TD>24/11/1998</TD><TD>d1004</TD></TR><TR><TD>10010</TD><TD>75405</TD><TD>24/11/1998</TD><TD>24/11/1999</TD><TD>d1004</TD></TR><TR><TD>10010</TD><TD>78194</TD><TD>24/11/1999</TD><TD>23/11/2000</TD><TD>d1004</TD></TR><TR><TD>10010</TD><TD>79580</TD><TD>23/11/2000</TD><TD>23/11/2001</TD><TD>d006</TD></TR><TR><TD>10010</TD><TD>80324</TD><TD>23/11/2001</TD><TD>01/01/9999</TD><TD>d006</TD></TR></TBODY></TABLE> Tue, 13 Jun 2023 11:24:27 GMT https://communities.sas.com/t5/SAS-Programming/Need-to-add-department-to-the-salary-table/m-p/880379#M347857 nxmogil 2023-06-13T11:24:27Z