When merging 2 datasets with a common variable (not merge
key), how to keep both?
- 3 Answers
- 6227 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / madhavi.nowduru@gmail.com
set dataset1 dataset2;
by var;
| Is This Answer Correct ? | 0 Yes | 3 No |
what is difference in window SAS & Unix SAS.....how do define working environment in both???
How would you combine 3 or more tables with different structures?
What is the SAS data set?
What does the trace option do?
what is the difference between DUPKEY and NODUPKEY???
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
when we are using the PROC TRANSPOSE? OBSERVATIONS are repeated then what will happen and what it will show in log window.
what is option year cuttoff in sas
In proc transpose and data step with arrays which one you pick?
0 Answers Accenture, Quintiles,
how to read the variables in sas? : Sas-administrator
how are numeric and character missing values represented internally? : Sas programming
Did you used proc test? when?
0 Answers Accenture, Quintiles,
Teradata 
