How would you combine 3 or more tables with different
structures?
- 7 Answers
- 17376 Views
- I also Faced
- E-Mail Answers
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
Which date function advances a date, time or datetime value by a given interval?
For what purposes have you used sas macros? : sas-macro
Which command is used to perform sorting in sas program?
Hi Jeevan/Akshara I have tried to contact SASI Vats for latest Advanced SAS Programming Certification Dumps (A00-212) but have not got any response. I would highly and gratefully appreciate your assistance in this regard. If you guys have access to this, would you be kind enough to forward it to me ? I would abide by all the terms you have for this. Please, note my email id: upretigopi@yahoo.com Preti Sharma
What are the prime responsibilities of data integration administrator? : Sas-di
Explain the special input delimiters used in sas programming.
what are input dataset and output dataset options? : Sas programming
How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?
Difference between sum function and using “+” operator?
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
how could you generate test data with no input data? : Sas programming
What are the different operating system platforms in which we can use sas? : sas-grid-administration
What was the last computer book you purchased? Why?
How would you include common or reuse to be processed along with your statements?
how can you import .csv file in to sas? : Sas programming
