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,

---

How to create a permanent sas data set?

0 Answers  

---

How do dates work in SAS data?

0 Answers  

---

Differentiate input and infile.

0 Answers  

---

describe the interaction table in sas di? : Sas-di

0 Answers  

---

---

what is the diff. b/w proc means and proc summary?

12 Answers   CitiGroup,

---

How would you invoke a macro? : sas-macro

0 Answers  

---

How to do user inputs and command line arguments in SAS? D&B

2 Answers   BoA, Quintiles,

---

What is the basic structure of the SAS base program?

0 Answers  

---

In this question, I rename the numeric variable phone to numphone and then try use phone=put(numphone,comma16.) to store the numeric value numphone as a string value in phone. But I get a warning tha numphone already exists and in the data sat phone doesnt exist and numphone is set to missing. Why? data names_and_more; input Name $20. Phone : comma16. Height & $10. Mixed & $8.; Name = tranwrd(Name,' ',' '); rename phone = numphone; phone = put(numphone,comma16.); datalines; Roger Cody 9,087,821,234 5ft. 10in. 50 1/8 Thomas Jefferson 3,158,488,484 6ft. 1in. 23 1/2 Marco Polo 8,001,234,567 5Ft. 6in. 40 Brian Watson 5,183,551,766 5ft. 10in 89 3/4 Michael DeMarco 4,452,322,233 6ft. 76 1/3 ;

1 Answers  

---

What is the purpose of the trailing @? The @@? How would you use them?

10 Answers   Accenture,

---

what is the difference between proc means and proc summary?

2 Answers   Accenture,

---