When merging 2 datasets with a common variable (not merge
key), how to keep both?
Answer Posted / reshma
data newdata;
merge dataset1 (in=a) datset2 (in=b);
if a or b;
by commonvar;
run;
| Is This Answer Correct ? | 7 Yes | 2 No |
Post New Answer View All Answers
How do you define proc in sas? : sas-grid-administration
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
Which command is used to perform sorting in sas program?
what is function of retain statment
Explain by-group processing?
What does PROC print, and PROC contents do?
What is the difference between %local and %global? : sas-macro
How to create a permanent sas data set?
what is enterprise guide? What is the use of it? : Sas programming
what is the function of catx syntax? : Sas-administrator
explain the main difference between the nodup and nodupkey options? : Sas-administrator
What do you understand by the term Normal Distribution?
what are some problems you might encounter in processing missing values? In data steps? Arithmetic? Comparisons? Functions? Classifying data? : Sas programming
What would be the value of month at the end of data step execution and how many observations would be there?
what is the purpose of _error_? : Sas programming