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
What is the maximum length of the macro variable?
How is character variable converted into numeric variable and vice versa?
Give some examples where proc report’s defaults are different than proc print’s defaults?
Explain why double trailing @@ is used in input statement?
Mention few capabilities of sas framework.
what is data access? : Sas-di
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?
What are the different types of sas functions?
What are the statements in proc sql?
What is program data vector (pdv)?
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
What is the differnce between SDTM 3.1.2 to 3.1.1 version
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
What is the difference between %put and symbolgen? : sas-macro