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
Mention how to limit decimal places for the variable using proc means?
how do you debug and test your sas programs? : Sas programming
Explain the use of proc print and proc contents?
where to use sas business intelligence? : Sas-bi
Can you explain the process of calendar?
Difference between informat and format?
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?
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Explain what is SAS informats?
To what type of programms have you used scratch macros?
What system options would you use to help debug a macro? : sas-macro
Which are the statements whose placement in the data step is critical?
Describe the function and untility of the most difficult SAS macro that you have written.
what are the considerations when picking a SAS/STAT procedure?
How to limit decimal places for variable using proc means?