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 do you debug and test your SAS programs? What can you learn from the SAS log when debugging? How do you test for missing values? How would you create multiple observations from a single observation? What are some good SAS programming practices for processing very large data sets? Briefly describe 5 ways to do a "table lookup" in SAS. Why is SAS considered self-documenting? Are you sensitive to code walk-throughs, peer review, or QC review? What other SAS features do you use for error trapping and data validation? How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

2 Answers  

---

1 new york 7,262,700 2 los angeles 3,259,340 3 philadelphia 1,642,900 how to read the above data using input statement consider the above data is in txt format externally u have to use infile and input statement.

9 Answers   Quintiles,

---

What are the different servers in sas? : sas-grid-administration

0 Answers  

---

how do u test a pros sql(works or not) without executing it?

1 Answers   DELL, HSBC,

---

how to know the attributes of first five datasets in a library

2 Answers  

---

In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?

6 Answers   Cognizant,

---

What has been your most common programming mistake?

4 Answers   Wipro,

---

how to delete the duplicates by using proc sql?

3 Answers   Genpact,

---

Describe the types of SAS programming tasks that you performed like Tables? Listings? Graphics? Ad hoc reports? Other?

4 Answers   HP, Oracle,

---

I Here clinical SAS training by Ramesh Azmeera is good. Is it confirm ?

2 Answers  

---

please can you tell me that in companies sas work are doing by through sas coding or sas wizard ??

0 Answers  

---