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
what is slowly changing dimension? : Sas-di
How would you identify a macro variable? : sas-macro
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what is the difference between unique key and primary key? : Sas-di
What is the work of tranwrd function?
Explain why double trailing @@ is used in input statement?
what is the use of proc contents and proc print in sas? : Sas-administrator
How is character variable converted into numeric variable and vice versa?
What are the difference between the sas data step and sas procs?
Explain what is the use of proc gplot?
Name and describe few sas character functions that are used for data cleaning in brief.
What is the sas data set? : sas-grid-administration
How do dates work in sas?
how does sas handle missing values in sort order? : Sas programming
Explain the purpose of retain statement.