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
What are the different servers in sas? : sas-grid-administration
How to sort in descending order?
How do you use the do loop if you don’t know how many times you should execute the do loop?
List out some key concept of SAS
Explain the use of proc gplot? : sas-grid-administration
what is SAS OPTIMIZATION?
Briefly explain input and put function?
for whom is sas data integration studio designed? : Sas-di
What are the default statistics for means procedure?
What are SAS/ACCESS and SAS/CONNECT?
what is sas database server? : Sas-di
How we can call macros with in data step? : sas-macro
What is the purpose of _character_ and _numeric_?
describe about metadata object? : Sas-di
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.