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;

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

1658

---

what is factor analysis? : Sas-administrator

600

---

Describe the function and untility of the most difficult SAS macro that you have written.

1552

---

what is the use of proc sql? : Sas programming

582

---

what is sas business intelligence? : Sas-bi

582

---

---

If you could design your ideal job, what would it look like?

2363

---

What is the difference between SAS functions and procedures?

652

---

what is enterprise guide? What is the use of it? : Sas programming

528

---

What are the automatic variables for macro? : sas-macro

667

---

what is metadata? : Sas-bi

590

---

What is the general format of function in sas? : sas-grid-administration

559

---

Explain what is the use of proc gplot?

692

---

How you can read the variables that you need?

645

---

how do you debug and test your sas programs? : Sas programming

553

---

Give an example where SAS fails to convert character value to numeric value automatically?

598

---