Answer Posted / ashish

Hey , your anwer is almost right but the only correction is
we derived the count variable by using monotonic() function
so that we have to use "calculated count" in where
statement or we can also use HAVING in palce of WHERE..

PROC SQL;
CREATE TABLE TEST AS SELECT
*,
MONOTONIC() AS COUNT
FROM TEST1
HAVING COUNT IN (110,150,170);
QUIT;

Mention some common errors that are usually committed in sas programming.

1045

---

How does the internal authentication work in sas? : sas-grid-administration

1119

---

is data integration and etl programming is same? : Sas-di

1080

---

What are the difference between the sas data step and sas procs?

1185

---

explain the concepts and capabilities of business object? : Sas-bi

962

---

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

1174

---

What is a macro routine?

2723

---

How do you test for missing values?

1636

---

in the flow of data step processing, what is the first action in a typical data step? : Sas programming

1076

---

Differentiate between proc means and proc summary.

1060

---

how can you create zero observation dataset? : Sas programming

1146

---

What is a pdv and what are its functions?

1148

---

Describe the ways in which you can create macro variables?

1193

---

How does SAS handle missing values in: assignment statements, functions, a merge, an update, sort order, formats, PROCs?

1537

---

what is sas metadata repository? : Sas-bi

1117

---