Do you need to combine data sets? How should you combine
data sets– MERGE or SET statements in DATA steps,PROC
APPEND,PROC SQL?
Answer Posted / charan araveti
Append/Set:
If you want to Add/Append data to Existed/Newly created
Dataset (With same variabls)
EX: you have DATA SETS Like JAN,FEB,MAR........,DEC.
and you want to create data set like "Sales_2010"
you have to use "SET/APPEND" Statements.
MERGE:
If you want add Existed variables to DataSet you have to use
Merge.
EX: If you 2 Dtasets of one person like Personal &
Professional and you want to all details in one dataset
means you have to use "Merge" with 'BY' Statement.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Hi, Does anybody has lastest SAS certification(base, adv., clinical)dumps,if anybody has please email me at mailtorajani76@gmail.com. Thanks
What is a macro routine?
which date functions advances a date time or date/time value by a given interval? : Sas programming
Mention common programming errors committed in sas ?
what is the function of catx syntax? : Sas-administrator
explain the function of substr in sas? : Sas-administrator
What is SAS? What are the functions does it performs?
what is data governance? : Sas-di
How do you convert basic cube to transaction cube and transaction cube to basic cube?
describe the interaction table in sas di? : Sas-di
What is PDV?
What is proc sort?
What are the parameters of scan function?
what is the difference between floor and ceil functions in sas? : Sas-administrator
Give an example where SAS fails to convert character value to numeric value automatically?