Diff between proc sql merge and join?
Answer Posted / anand
Merge - Data sets must be sorted by or indexed on the BY variable prior to merging.
Proc SQL - Data sets doesnot need to be sorted or indexed.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Have you ever used the SAS Debugger?
i have a dataset with 100 obs i want to generate title from 20th obs onwards with total observations. that should contain 100 obs.dont use firstobs and dnt split the data. use dataset block or proc report? how can we genarate;
What is the basic syntax of a sas program?
How do you control the number of observations and/or variables read or written?
for what purpose would you use the retain statement? : Sas programming
what does the run statement do? : Sas programming
Describe 5 ways to do a “table lookup” in SAS?
how do you pull data from equifax?tell me the process?
What is the role of sas grid administrator? : sas-grid-administration
If you have a dataset that contains 100 variables, but you need only five of those, what is the code to force SAS to use only those variables?
what is sas business intelligence? : Sas-bi
State the difference between INFORMAT and FORMAT ?
Do you need to rearrange the order of the data for the report?
name some data transformation used in sas di? : Sas-di
What is the difference between %local and %global? : sas-macro