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

how does sas handle missing values in functions? : Sas programming

1280

what is sas database server? : Sas-di

1190

In proc transpose and data step with arrays which one you pick?

3171

How do you debug and test your SAS programs?

1607

what is operational data and operational system? : Sas-di

1155

How do dates work in SAS data?

1227

how can you put a "trace" in your program? : Sas programming

1108

How to limit decimal places for the variable using proc means?

1120

For a user to have access to a standard workspace server, is internal authentication alone is sufficient? : sas-grid-administration

1057

what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming

1309

Did you used proc test? when?

2088

what is metadata? : Sas-bi

1072

explain the difference between proc means and proc summary?

1181

What is the use of PROC gplot?

1203

How necessary is it to be creative in your work?

2524