How would you combine 3 or more tables with different
structures?

Answer Posted / piyushjk

I would use Merge statement to combine theree tables (SAS
Datasets). First you have to sort the datasets by common
variable. provide the condition with in merge statement.
For e.g. Three datasets are A, B, C and common var is SSN,
then

DATA Together;
Merge A (IN=A)
B (IN=B)
C (IN=C);
By SSN; Run;

Is This Answer Correct ?    7 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data _null_?

785


how can you put a "trace" in your program? : Sas programming

681


explain what is factor analysis? : Sas-administrator

689


how do you want missing values handled? : Sas programming

619


How will you generate test data with no input data?

664






do you prefer proc report or proc tabulate? Why? : Sas programming

661


What is the difference between SAS functions and procedures?

765


what are the component of range? : Sas-bi

704


For what purpose would you use the RETAIN statement?

1151


what can you learn from the sas log when debugging? : Sas programming

700


List out some key concept of SAS

702


What is the use of the %include statement?

783


What is the maximum and minimum length of macro variable

758


What does the RUN statement do?

950


What are the five ways to do a table lookup in sas? : sas-grid-administration

690