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


how can u join the two tables without using proc sql Joins
and nested queries ?

Answers were Sorted based on User's Feedback



how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / rajaanku11

By using the DATA step Merge.

Is This Answer Correct ?    30 Yes 1 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / kumarravi111

we can use Merge and set statements to join the tables in
Data step

Is This Answer Correct ?    19 Yes 1 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / sai

we can join two tables by using merge statement and also by
using two SET statements .


data one;
set two;
set three;
run;

Is This Answer Correct ?    3 Yes 0 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / shiva,ibm

both above are right

Is This Answer Correct ?    4 Yes 2 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / amit

By mearge statement

Is This Answer Correct ?    1 Yes 1 No

how can u join the two tables without using proc sql Joins and nested queries ?..

Answer / vimal

actually i think UNION and UNION ALL is the correct answer.. since they ask related to that.

Is This Answer Correct ?    1 Yes 2 No

Post New Answer

More SAS Interview Questions

What are types of transport files?

2 Answers   PRA Health Sciences, Quintiles,


What data sets do you need to produce the report?

2 Answers   Novartis,


if a program has some 1000 or more line and how to know whether the syntax of the particular code is correct without checking it manually

4 Answers   Accenture,


What SAS statements would you code to read an external raw data file to a DATA step?

6 Answers   Accenture,


how would you determine the number of missing or nonmissing values in computations? : Sas programming

0 Answers  


How do handle working under pressure?

1 Answers   Oracle, Wipro,


How to Rename Library?

3 Answers  


How to read an input file in sas?

0 Answers  


What report output formats can you generate using SAS?

3 Answers   Accenture,


what is the primary data source for the wrs? : Sas-bi

0 Answers  


How do you specify the number of iterations and specific condition within a single do loop?

0 Answers  


Explain what is data step?

0 Answers  


Categories