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 would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
Can you explain the process of calendar?
What is your favorite all time computer book? Why?
What is the SAS data set?
What are the special input delimiters used in SAS?
If money were no object, what would you like to do?
What is the general format of function in sas? : sas-grid-administration
How to create list output for cross-tabulations in proc freq?
what is the use of proc contents and proc print in sas? : Sas-administrator
what is the difference between nodup and nodupkey options? : Sas programming
How would you identify a macro variable? : sas-macro
what is transformation in sas data integration? : Sas-di
Name few SAS functions?
What is the maximum length of the macro variable? : sas-macro
How do you convert basic cube to transaction cube and transaction cube to basic cube?