How would you combine 3 or more tables with different
structures?
Answer Posted / ameenpasha
I think sort them with common variables and use merge statement.
No matter if they are of different structures, only that the result will have missing values for nonmatching records. If you wanna avoid this use In() operator OR
use proc sql with Join clause which will just pick matching records.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain why double trailing @@ is used in input statement?
what are the types of interactive display types? : Sas-bi
List down the reasons for choosing sas over other data analytics tools.
Can you execute macro within another macro? If so, how would sas know where the current macro ended and the new one began? : sas-macro
Name few SAS functions?
what is the use of sas management console? : Sas-di
What is the difference between INPUT and INFILE ?
what r the job openings SAS for fresher graduates !
Do you know the features of sas?
How do you define proc in sas? : sas-grid-administration
how does sas handle missing values in a merge? : Sas programming
What is the length assigned to the target variable by the scan function?
In sas, what are the areas that you are most interested in? : sas-grid-administration
Will it bother you if the guy at the next desk times the frequency and duration of your bathroom or coffee breaks on the grounds that ?you are getting paid twice as much as he is??
What is data _null_?