PROC SQL; SELECT*, MONOTONIC() AS COUNT FROM TEST HAVING COUNT IN(100,1

There are 200 observations in a dataset, i want to pull out
the observation no's 100, 150,180,190 by using Proc SQL? How
you can get it?

Question Posted / pranoy tikadar

Answer Posted / pranoy tikadar

PROC SQL;
SELECT*,
MONOTONIC() AS COUNT
FROM TEST
HAVING COUNT IN(100,150,180,190);
QUIT;

Is This Answer Correct ?

11 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain input and put function?

1146

What is the purpose of _character_ and _numeric_?

1068

what are sas bi dashboard components? : Sas-bi

1174

Describe the function and utility of the most difficult SAS macro that you have written?

2569

Which date function advances a date, time or datetime value by a given interval?

1155

What is program data vector (pdv)?

1298

What do the put and input function do?

1067

what are the considerations when picking a SAS/STAT procedure?

3376

How necessary is it to be creative in your work?

2476

what is sas database server? : Sas-di

1136

What are the advantages of using sas?

1147

How to include or exclude specific variables in a data set?

1123

Difference between SAS STATA & SPSS?

1125

Describe a time when you were really stuck on a problem and how you solved it?

2552

what is sas business intelligence? : Sas-bi

1183