what is the difference between SET and MERGE?
Answer Posted / kithsiri
Data C;
Set A B;
run;
Concaternate A and B data sets and make c Data set. Then data of B data set is placed after data of A data set. If A has n1 number of observation and B set has n2 number of observation. Then C(new set has n1+n2 number of data)
Data C;
set A B;
By var1;
run;
If var1 variable is exist in both A and B data sets, in C data set rows are arrenged according to var1 variable(ascending order).
Data C;
merge A B;
By var1;
run;
Data are arrenged side by side if there are var1 in both data sets and match rows of both sets. If A data set is not matched with B then display records of A in left side and right side data is missing values. If B data is not matched with A then display records of B in right side and left side data is missing values. If there is same variable in both tables, observation of that variable of first table is replaced by observation of the same variable of second table when match observation of var1 in both tables.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Difference between SAS STATA & SPSS?
Intern stastical programmer written test
Which command is used to save logs in the external file?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
Describe the function and untility of the most difficult SAS macro that you have written.
What are the parameters of scan function?
what are some differences between proc summary and proc means? : Sas programming
What is the length assigned to the target variable by the scan function?
If a variable contains letters or special characters, can it be numeric data type?
what type of graphs we will create(for 2+years candidates)?
Explain the use of proc print and proc contents?
Explain how you can debug and test your SAS program?
Mention what is SAS data set?
Explain how merging helps to combine data sets.
in the flow of data step processing, what is the first action in a typical data step? : Sas programming