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

What is the difference between order and group variable in proc report?

1366

What are the different operating system platforms in which we can use sas? : sas-grid-administration

1011

Name any two sas spawners? : sas-grid-administration

984

Differentiate between ceil and floor functions.

1105

What are the difficulties u faced while doing vital signs table or dataset?

2340

Compare sas with other data analytics tools.

983

Explain what is data step?

1132

how to do user inputs and command line arguments in sas?

2977

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

944

What are the 3 components in sas programming?

1151

What is the difference between class statement and by statement in proc means?

1195

what is hierarchy flattening? : Sas-di

1033

How do you connect the desktop application to metadata server? : sas-grid-administration

1033

Describe the ways in which you can create macro variables? : sas-macro

1015

Differentiate between sas functions and sas procedures.

1148