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
How would you determine the number of missing or nonmissing values in computations?
Mention few capabilities of sas framework.
what is the difference between unique key and primary key? : Sas-di
what is hierarchy flattening? : Sas-di
Do you need to know if there are any missing values?
How do you define proc in sas? : sas-grid-administration
why is sas data integration studio important? : Sas-di
what are _numeric_ and _character_ and what do they do? : Sas programming
Did you used proc test? when?
Differentiate input and infile.
What do the put and input function do?
what is information maps?
Explain translate function?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
in the flow of data step processing, what is the first action in a typical data step? : Sas programming