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

Intern stastical programmer written test

292


What is maximum storage capability of SAS?

913


What is the difference between %local and %global? : sas-macro

679


AE datasets names? how many types?

2084


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

617






How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2395


what are sas bi dashboard components? : Sas-bi

669


How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

595


what is SAS OPTIMIZATION?

1823


I need level 2 to 5 sas using companies in india

1939


Name any two sas spawners? : sas-grid-administration

568


what is hierarchy flattening? : Sas-di

633


What areas of SAS are you most interested in?

1074


How will you generate test data with no input data?

571


Mention how to limit decimal places for the variable using proc means?

653