Merge Mark Data with airSlate SignNow

Merge mark data

suppose you want to merge the tables you have one table something like this the other table something like this and you want to have them combined which looks something like this welcome to the channel now to understand the concept very clearly please watch the video till the end once you are done with watching the video do not forget to like comment subscribe and hit the bell icon so again so here we gonna learn about merging the tables all about merging the tables we will start from the beginner level and i'll take take you to the further so to merge the tables we need some prerequisites i mean if you want to merge two or more tables there are certain requirements which must be fulfilled let's look at the requirements one by one first requirement is there should be at least two tables which is very obvious either two or more tables both all both or all the tables must have at least one common variable i mean in both of these two tables you should have one common variable basis on which you could do the merging then all or both of the two tables should be or must be sorted on the common variables now let's explore it further and understand so here you have the first table which is cost one customer one then you have the second table which is customer two in the first table you can see you have customer name and the transaction amount in second table you have contact name i mean which is a customer name of course city and the country now as our first requirement say says first of all we must have at least two tables so here that is fulfilled then we should have at least one common variable in both of these two tables so we can see these two columns are common so it now when you have all of these requirements fulfilled and of course you will be sorting the data before merging that then you would just move ahead and you would like to have them combined which looks something like this now here one thing to notice all right so first let's go to the sas session and do this and then we will try to explore it so here we have the cursed one table and here we have the curse two table so let's start with sorting the data proc sort data equals to i'm sorry so if you have not seen how to sort the data uh we have already created a video on sorting the tables you can just watch them from the channel playlist or by clicking the link which is showing just right up here all right now coming back to the requirement we'll first select the first column and then give a bias statement and then contact name which is the common column and then have it running and then again...