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 ?
- 6 Answers
- 13321 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / kumarravi111
we can use Merge and set statements to join the tables in
Data step
| Is This Answer Correct ? | 19 Yes | 1 No |
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 |
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 |
What is the maximum and minimum length of macro variable
What versions of SAS have you used (on which platforms)?
why is sas considered self-documenting? : Sas programming
What is the difference between an informat and a format. Name three informats or formats.
How does proc sql work?
how will you locate the sas platform applications? : Sas-bi
How to write duplicate records into a separate dataset using sort?
explain the proc in sas? : Sas-administrator
how do u test a pros sql(works or not) without executing it?
Can we use where and having clauses in a single SAS program. ex: proc sql; select a,b,c from test where state in 'KA' and having <some condition>. Is the above program run correctly, if not why ?
What is the function of Stop statement in a SAS Program?
1.How many ways are there to create variables? 2.What is CLM,how can we use it? 3.what are the advontages of data step? 4.what is the extension of editor window in SAS 9.1.3? 5.How do you copy a particular data set from one library to another? 6.what is the use of double option? 7.Advontages of Proc Report? 8.what is the basic use of where statement? 9.How do you terminate the statments in SAS Programming? 10.What is the difference between symput and symget? 11.How would a identify the local and global variable? can any one answer for the 4'th question
Teradata 
