Do you need to combine data sets? How should you combine
data sets– MERGE or SET statements in DATA steps,PROC
APPEND,PROC SQL?
- 3 Answers
- 5891 Views
- I also Faced
- E-Mail Answers
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
Differentiate between format and informat? : sas-grid-administration
How does proc sql work?
Explain the special input delimiters used in sas programming.
Hi all, If Anybody has Advance SAS Certification dumps??? Please share with me. Email: pramod.kalugade03@gmail.com
Which statement does not perform automatic conversions in comparisons?
how we can create a FLAG datasets? Ex:-ID age_group no_persons 1 to 10 10 to 20 3 11 to 20 21 to 30 7 21 to 3o 31 to 40 5
How can sas program be validated?
what is enterprise guide? What is the use of it? : Sas programming
What is the basic structure of a sas program?
Which command is used to save logs in the external file?
what are input dataset and output dataset options? : Sas programming
What is the basic structure of the SAS base program?
Are you involved in writing the inferential analysis plan? Tables specfications?
What versions of SAS have you used (on which platforms)?
if a variable contain dates like "2015/01"---"2015/12" (yymm) ,How to add day to those dates,if them month is jan then 31 if the month is feb then 28 so on ...
