Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

for whom is sas data integration studio designed? : Sas-di

947


How to include or exclude specific variables in a data set?

1063


What are common programming errors committed in sas

1097


what is snowflake schema? : Sas-di

1145


Explain translate function?

1128


What versions of SAS have you used (on which platforms)?

1456


Name few SAS functions?

1041


State the difference between INFORMAT and FORMAT ?

1039


what other sas products have you used and consider yourself proficient in using? : Sas programming

1055


Explain data_null_?

1003


what is the different between functions and procs that calculate the same simple descriptive statistics? : Sas programming

992


Explain the main difference between the sas procedures and functions? : Sas-administrator

1012


I have a dataset concat having variable a b & c. How to rename a b to e & f?

962


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

994


name the scheduler for scheduling job and explain the scheduler? : Sas-di

998