Answer Posted / pricil kurian

This message occur when we merge two datasets having the by
variables with more than one observation in both datasets.
In such scenarios we can't tell the result is true...We are
expecting really a carteisan product in such situation but
it is not the case..Inside the by values it will do a 1-1
merge only. So this note is very important. Use
nomergeby=error option in sas as a option so that we will
get this message as a error. This will avoid ignoring this
message. Use proc sql to merge the dataset such type
situation and proc sql will give a carteisan product. If u
are doing with datastep create unique variable and then
merge.

Did you used proc test? when?

2044

---

Explain how you can debug and test your SAS program?

1016

---

what is sas business intelligence? : Sas-bi

1183

---

What are the prime responsibilities of data integration administrator? : Sas-di

1073

---

What are the differences between proc means and proc summary?

1146

---

What are the table names in oracle database...?

2758

---

what is the basic structure sas administrator? : Sas-administrator

1006

---

What is the basic structure of the SAS base program?

1332

---

How to import multiple xls files into sas. Out of those files, how to get different values from a single variable and how to find number of rows per value type? We can do this using group by for one xls file with proc sql. Was wondering how I can achieve this for multiple files at the same time. Any ideas?

2934

---

What is program data vector (pdv) and what are its functions?

1252

---

What are the statements that are executed only?

1153

---

Explain the main difference between the sas procedures and functions? : Sas-administrator

1077

---

What is the difference between reading data from an external file and reading data from an existing data set?

1183

---

how to generate the test data in sas without input data? : Sas-administrator

1138

---

what is intially documentation in sas?

5054

---