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

Enlist the syntax rules followed in sas statements.

872


how would you create multiple observations from a single observation? : Sas programming

801


explain about data integrator metadata reports? : Sas-di

850


what is operational data and operational system? : Sas-di

892


if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

784


What is a put statement?

971


What are the five ways to do a table lookup in sas? : sas-grid-administration

847


what are sas bi dashboard components? : Sas-bi

911


WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2566


What is the use of stop statement?

864


what is the purpose of _error_? : Sas programming

885


Why double trailing @@ is used in input statement?

952


How to sort in descending order?

1041


how does sas handle missing values in functions? : Sas programming

877


Name and describe few sas character functions that are used for data cleaning in brief.

903