**merge** -> merge usually joins datasets with different variable. output datasets contain all the variables from all datasets. up to 100 datasets can merge i one step. observations are match merge with BY statement ex= data onetoonemerging; merge one two; run; ex2= data matchmerge; merge one two ; by id; run; **SET** -> combining two or more sas datasets into a single sas datasets one after another using SET stmt that is also called concatation. if original datasets contai diff. data types for variables concatenation wont happen. ex= data sada; set one two; run; in SET stmt we can also use a dataset table option like obs,firstobs,keep,rename and drop. **Update** -> if we want to update a dataset if the record exist in dataset then it update otherwise insert it . ex= data one ; update one two; by id ; run;
... View more
