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
- 13375 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 |
. Which date advances a date, time or date/time value by a given interval?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
libname deepak 'C:\SAS Files'; proc format; invalue convert 'A+' = 100 'A' = 96 'A-' = 92 'B+' = 88 'B' = 84 'B-' = 80 'C+' = 76 'C' = 72 'F' = 65; data deepak.grades; input ID $3. Grade convert.; *format Grade convert. ; datalines; 001 A- 002 B+ 003 F 004 C+ 005 A ; proc print data = deepak.grades; run; I get the following output Obs ID Grade 1 001 . 2 002 . 3 003 . 4 004 . 5 005 . I don’t understand why Grade shows up as a missing value. Everything seems fine, including ID $3. Now, in case I use ID : $3. Or use column input, I get the desired output. Kindly help Deepak
Explain the message 'Merge has one or more datasets with repeats of by variables'.
what is AE onset date and what is RDS?
What is the difference between INPUT and INFILE ?
how can you code the confidence intervals?
6 Answers Cytel, IIT, Ranbaxy,
Can you explain the process of calendar?
what do the mod and int function do? What do the pad and dim functions do? : Sas programming
how we can call macros with in data step?
how to generate report for 0 observation dataset?
Explain substr function?
Teradata 
