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 the difference between INPUT and INFILE ?
What are the difficulties u faced while doing vital signs table or dataset?
What is PROC in SAS?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what is sas metadata server? : Sas-di
how to read the variables in sas? : Sas-administrator
which date function advances a date, time or datetime value by a given interval? : Sas programming
Describe a time when you were really stuck on a problem and how you solved it?
What do you code to create a macro? : sas-macro
how would you determine the number of missing or nonmissing values in computations? : Sas programming
If a variable contains only numbers, can it be a character data type?
What is proc sort?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
what is data integration? : Sas-di
Can you execute a macro within a macro? Describe. : sas-macro