https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36894#M7272 you can use dataset merge. keep column1 and column18 from datasetB in merge step.<BR /> <BR /> GL. Fri, 18 Jun 2010 13:18:37 GMT deleted_user 2010-06-18T13:18:37Z https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36892#M7270 Hi,<BR /> <BR /> I have two datasets namely A and B.<BR /> A has 400 columns in which only column number 18 is not filled(Blank).<BR /> B has 400 columns in which only column number 18 and Key (column 1) is filled and remaining all are missing(numeric) or blank(Char) based on the data type.<BR /> <BR /> Now I want new dataset as follow:<BR /> <BR /> If match on key between A and B: I want all columns of A with columns number 18 having value of dataset B.<BR /> <BR /> If exist in B and not A then I want all records in B.(Meaning columns1 and columns 18 filled and remaining missing or blank).<BR /> <BR /> Please let me know how can I do this. Thanks. Thu, 17 Jun 2010 14:18:50 GMT https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36892#M7270 SASACC 2010-06-17T14:18:50Z https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36893#M7271 You want to use <BR /> <BR /> [pre] UPDATE A B; BY ID; [/pre] Thu, 17 Jun 2010 14:43:18 GMT https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36893#M7271 data_null__ 2010-06-17T14:43:18Z https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36894#M7272 you can use dataset merge. keep column1 and column18 from datasetB in merge step.<BR /> <BR /> GL. Fri, 18 Jun 2010 13:18:37 GMT https://communities.sas.com/t5/SAS-Programming/Merge/m-p/36894#M7272 deleted_user 2010-06-18T13:18:37Z