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 do dates work in SAS data?
Approximately what date is represented by the SAS date value of 730?
What is the role of administrative users? : sas-grid-administration
Have you ever used the SAS Debugger?
what is data access? : Sas-di
Tell e how how dealt with..
How would you define the end of a macro? : sas-macro
name the scheduler for scheduling job and explain the scheduler? : Sas-di
how does sas handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, procs? : Sas programming
what is function of retain statment
how do you debug and test your sas programs? : Sas programming
State the difference between INFORMAT and FORMAT ?
what is the use of proc sql? : Sas programming
How would you identify a macro variable? : sas-macro
What are the new features included in the new version of SAS Programming Language?