What is the difference between the proc sql and data step?

0 Answers  

---

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

1 Answers   Accenture,

---

Difference between nodup and nodupkey options?

0 Answers  

---

calculate the sum of value using only DATA STEP. data count_; input year name $ value; cards; 2006 xxx 10 2007 yyy 12 2006 xxx 20 2008 yyy 15 2007 xxx 15 ; out put should be like this year name T_value ----------------------- 2006 xxx 30 2007 xxx 15 2007 yyy 12 2008 xxx 15

6 Answers  

---

Can anyone help me about SAS Realtime scenarios in Clinical field

0 Answers  

---

For what purpose would you use the RETAIN statement?

0 Answers   Quintiles,

---

How do you read in the variables that you need?

9 Answers   Accenture,

---

Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.

6 Answers   HSBC,

---

CHOOSE ANY ONE OF THE PROCEDURE FOLLOWING TO GENERATE THE REPORTS? HOW CAN YOU SAY IT IS BETTER THAN THE OTHER? AND DEFERENCIATE THESE TWO ? 1). REPORT PROCEDURE 2). TABULATE PROCEDURE

4 Answers   CybAge,

---

When looking for data contained in a character string of 150 bytes, which function is the best to locate that data: scan, index, or indexc?

7 Answers  

---

Mention the difference between ceil and floor functions in sas?

0 Answers  

---

Name and describe three SAS functions that you have used, if any?

4 Answers   Accenture,

---