When merging 2 datasets with a common variable (not merge
key), how to keep both?

Answer Posted / vigneshwaran.s

Rename the variable in First data or in The Second Data:

Like,

Merge A(rename=(comman_var=New_var))(in=x)
B (in=y);
by New_var;
Run;

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain data step in SAS

627


How would you define the end of a macro?

698


What system options would you use to help debug a macro? : sas-macro

636


how are numeric and character missing values represented internally? : Sas programming

619


What is program data vector (pdv)?

629






Why double trailing @@ is used in input statement?

699


What are the data types does SAS contain?

650


In sas, what are the areas that you are most interested in? : sas-grid-administration

636


What is SAS informats?

633


for what purpose would you use the retain statement? : Sas programming

579


what is study design in while working with SAS? what are screening variables in SAS?

1679


What is the difference between %local and %global? : sas-macro

666


explain the proc in sas? : Sas-administrator

619


what is sas business intelligence? : Sas-bi

584


what are several options for creating reports in web report studio? : Sas-bi

628