Please write codes to merge two datasets and keep every
record in the first dataset.
Answer / 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 |
describe how to adjust the performance of data integrator? : Sas-di
Name statements that function at both compile and execution time?
i am importing large data from oracle to work library. in log there is a error message worklibrary space is not enough. then how to import the data safely to sas environment.
how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming
how does sas know on which server the piece of code to be executed ? say if a proc olap code is written then how the sas application would detect on which server to execute.
If you need the value of a variable rather than the variable itself what would you use to load the value to a macro variable?
Difference Between Scan and Substr
Explain proc sort?
What is the purpose of _character_ and _numeric_?
In sas, what are the areas that you are most interested in? : sas-grid-administration
Explain why double trailing @@ is used in input statement?
Which are the statements whose placement in the data step is critical?