Please write codes to merge two datasets and keep every
record in the first dataset.
Answer Posted / reshma
proc sort data=dataA;
by commonvar;
run;
proc sort data=dataB;
by commonvar;
run;
data new;
merge dataA (in=a) dataB (in=b);
if a ;
by commonvar;
run;
| Is This Answer Correct ? | 14 Yes | 0 No |
Post New Answer View All Answers
what are 5 ways to perform a table lookup in sas? : Sas-administrator
describe the interaction table in sas di? : Sas-di
How to limit decimal places for the variable using proc means?
Mention how to limit decimal places for the variable using proc means?
How would you define the end of a macro? : sas-macro
what do the sas log messages "numeric values have been converted to character" mean? : Sas programming
What Proc glm does?
Name some categories in sas 9? : sas-grid-administration
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
name several ways to achieve efficiency in your program? : Sas programming
Explain the special input delimiters used in sas programming.
Explain what is SAS informats?
What is the difference between the proc sql and data step?
Explain translate function?
How would you identify a macro variable?