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

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

0 Answers   Accenture,


How long can a macro variable be? A token? : sas-macro

0 Answers  


This entry was posted in General. Bookmark the permalink. Post a comment or leave

0 Answers   Quintiles,


what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming

0 Answers  


What are the 3 components in sas programming?

0 Answers  


How do you add a number to a macro variable? : sas-macro

0 Answers  


I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.

4 Answers  


PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?

7 Answers   HP,


Tell e how how dealt with..

0 Answers   Wipro,


how to assign a macro value to a variable?

8 Answers   CitiGroup,


What is the function of output statement in a SAS Program?

0 Answers  


What was the last computer book you purchased? Why?

0 Answers   Oracle,


Categories