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;

What are the special input delimiters used in SAS?

1099

---

What would be the value of month at the end of data step execution and how many observations would be there?

1059

---

Difference between nodup and nodupkey options?

1109

---

how can you import .csv file in to sas? : Sas programming

1044

---

What was the last computer book you purchased? Why?

2314

---

what is sas enterprise intelligence architecture? : Sas-bi

934

---

How sas treats the dsd delimiters?

1151

---

How do you control the number of observations and/or variables read or written?

1190

---

How can you create a macro variable with in data step? : sas-macro

983

---

Mention few capabilities of sas framework.

1126

---

What is the maximum length of the macro variable?

1131

---

How will you use the WHO Drug Dictionary for Reporting Clinical Trials?

2280

---

In SAS explain which statement does not perform automatic conversions in comparisons?

1262

---

what are sas/access and sas/connect? : Sas programming

941

---

explain the proc in sas? : Sas-administrator

1033

---