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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between input and infile statement?

684


what is star schema? : Sas-di

647


what can you learn from the sas log when debugging? : Sas programming

610


For what purposes have you used sas macros? : sas-macro

540


How does the internal authentication work in sas? : sas-grid-administration

584






How we can create SAS USER DEFINED CODE?

1614


Differentiate between format and informat? : sas-grid-administration

581


Explain the use of proc gplot? : sas-grid-administration

556


Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1461


What is a macro routine?

2104


what is sas olap server? : Sas-di

689


What is the role of administrative users? : sas-grid-administration

660


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2293


what is the use of sas management console? : Sas-di

613


Explain the purpose of retain statement.

603