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
How we can create SAS USER DEFINED CODE?
List down the reasons for choosing sas over other data analytics tools.
Which are the statements whose placement in the data step is critical?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
How necessary is it to be creative in your work?
What are the special input delimiters used in SAS?
Describe 5 ways to do a “table lookup” in SAS?
What are the parameters of scan function?
what is data access? : Sas-di
what is the basic structure sas administrator? : Sas-administrator
Mention what are the data types does SAS contain?
What are the ways in which macro variables can be created in sas programming?
what is sas metadata server? : Sas-di
what are input dataset and output dataset options? : Sas programming
what is data governance? : Sas-di