what is Difference between PROC SQL JOINS and MERGE?
Answer Posted / siddu
Before doing the merge process we have to do sorting depended the key variable, but in proc sql joins no need to do sorting.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the purpose of trailing @ and @@? How do you use them?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What is the order of application for output data set options, input data set options and SAS statements?
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
Explain proc univariate?
What does the RUN statement do?
what is the primary data source for the wrs? : Sas-bi
what is snowflake schema? : Sas-di
Explain proc sort?
What are the differences between sum function and using “+” operator?
What is a put statement?
how do the in= variables improve the capability of a merge? : Sas programming
What is the role of sas grid administrator? : sas-grid-administration
What is the difference between where and if statement?
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