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 |
What are the functions done while Compilation...?
What is the work of tranwrd function?
In the following DATA step, what is needed for ‘fraction’ to print to the log? data _null_; x=1/3; if x=.3333 then put ‘fraction’; run;
how to generate report for 0 observation dataset?
What is difference between N and n????
what is the use of LRECL option.
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
Which date functions advances a date time or date/time value by agiven interval?
hi i am nipun can anybody tell me that if a clinical sas programmer write the code and after successfull execution where do they store it. how they submit tables to TL how work is assigned to programmers either both code, log, output to be submitted. can any one tell me the process
how does sas handle missing values in procs? : Sas programming
What are the special input delimiters used in SAS?