how can u join the two tables without using proc sql Joins
and nested queries ?
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 |
How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?
How long can a macro variable be? A token? : sas-macro
This entry was posted in General. Bookmark the permalink. Post a comment or leave
what is the difference between: x=a+b+c+d; and x=sum (of a, b, c ,d);? : Sas programming
What are the 3 components in sas programming?
How do you add a number to a macro variable? : sas-macro
I have 50 variables in one data set, In reports i want to generate every 10 variables in one page how we will write code in proc report.
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
Tell e how how dealt with..
how to assign a macro value to a variable?
What is the function of output statement in a SAS Program?
What was the last computer book you purchased? Why?