Hello, i have a data set which i created in a work library. i want to drop one column and also copy the values of dropped column in another column which is blank. how do i do that? here is an example. Suppose i have a dataset which has 4 columns: Name      ID           address      ID_2 Sam                        xyz             123 Bob                         abc             456   i want to be able to modify the dataset to drop the column "ID_2" and move the values from the column "123" and "456" to "ID" how can i acheive it using proc sql? here is what i have done so far   data want; set have; ID=ID_2; run;   the issue with this stateent is that it only captures the first letter of the column "ID_2". so using the above example, when i run the code mentioned above, i get: Name    ID   Address    ID_2 SAM      1     xyz           123 Boc        4     abc           456     please guide thanks in advance here is  ... View more