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 change analysis in sas di ? : Sas-di
What is the basic syntax style in SAS?
What is the purpose of _character_ and _numeric_?
How do you control the number of observations and/or variables read or written?
how does sas handle missing values in a merge? : Sas programming
how many display types available in sas bi dashboard? : Sas-bi
how many types of prompts are there? : Sas-bi
what are the softwares and applications that are used most frequently used by sas bi applications developers? : Sas-bi
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
What are the data types that sas contain?
What are the ways in which macro variables can be created in sas programming?
Do you need to know if there are any missing values?
how does sas handle missing values in formats? : Sas programming
how does sas handle missing values in assignment statements? : Sas programming
What is the purpose of trailing @ and @@? How do you use them?