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 do the PUT and INPUT functions do?
how can you put a "trace" in your program? : Sas programming
How to convert a numeric variable to a character variable?
What would you change about your job?
explain what is data set in sas? : Sas-administrator
how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What does the RUN statement do?
Have you ever used the SAS Debugger?
what versions of sas have you used (on which platforms)? : Sas programming
What are the data types in sas?
what is enterprise guide? What is the use of it? : Sas programming
what are some good sas programming practices for processing very large data sets? : Sas programming
how can you import .csv file in to sas? : Sas programming
what is sas metadata server? : Sas-di