SPLICE normally requires reformatting the records of two or more data sets so they can be JOINED. In other words,…