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 will you location sas platform applications available from web browser? : Sas-bi

0 Answers  


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

0 Answers  


what is SAS OPTIMIZATION?

0 Answers  


CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

4 Answers   CybAge,


· What are some good SAS programming practices for processing very large data sets?

6 Answers   Quintiles,


How to convert a numeric variable to a character variable?

0 Answers  


What is the sas data set? : sas-grid-administration

0 Answers  


Give an example where SAS fails to convert character value to numeric value automatically?

0 Answers  


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

0 Answers  


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

0 Answers  


Write SAS codes to compare two datasets. Suppose the allowable difference is 0.1.

2 Answers  


What do you feel about hardcoding?

4 Answers   Oracle,


Categories