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...


whenever we using the merging through data set merging ,we can
get note in log like this "MERGE STATEMENT HAS MORE THAN ONE
ONE DATASET BY REPEATED BY VAIABLES" but the output has come
in good manner,whenever in in sql(full join) we can get
cartion product.so How do overcome this problem in sql?



whenever we using the merging through data set merging ,we can get note in log like this "MERG..

Answer / alok karan

if we have exactly same number of observation for each BY value in two data sets and we use merge statement to merge them then within log window we got message"MERGE STATEMENT HAS MORE THAN ONE
ONE DATASET BY REPEATED BY VAIABLES"

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SAS Interview Questions

what is data governance? : Sas-di

0 Answers  


Do you need to know if there are any missing values?

0 Answers  


what is OLAP?

4 Answers   CitiGroup, TCS,


Explain the difference between using drop = data set option in set and data statement?

0 Answers  


Hi im new to sas. I have a file with some charecter variables and some numeric variables now i want to load charecter variables into one datastep and numeric variables into another data step pls let me know Thanks

2 Answers  


how do you want missing values handled? : Sas programming

0 Answers  


Which function is used to count the number of intervals between two sas dates?

0 Answers  


What are the special input delimiters used in SAS?

0 Answers  


What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,


how to display duplicated observations in a data using base sas.

13 Answers   HCL, TCS,


what is sas metadata repository? : Sas-bi

0 Answers  


How do i read multiple spaces in datasets?

4 Answers   Quintiles,


Categories