what is Difference between PROC SQL JOINS and MERGE?
- 3 Answers
- 24401 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answer Posted / nrtya vardhanapu
merge is a statement which is used in the data step Whereas
join is a procedure which is used in the proc step. But the
outputs produced are the same !!!!
| Is This Answer Correct ? | 0 Yes | 13 No |
Post New Answer View All Answers
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
What would be the result of the following SAS function (given that 31 Dec, 2000 is Sunday)?
what does the run statement do? : Sas programming
what is hierarchy flattening? : Sas-di
Describe a time when you were really stuck on a problem and how you solved it?
what are the new features included in the new version of sas i.e., Sas 9.1.3? : Sas programming
Explain the special input delimiters used in sas programming.
Describe the ways in which you can create a macro variable?
Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.
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? : sas-macro
How can you limit the variables written to output dataset in data step?
Differentiate between ceil and floor functions.
what is proc Index? and what is proc document?
What does PROC print, and PROC contents do?
how does sas handle missing values in a merge? : Sas programming
