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 to read an input file in sas?

1101

what are the component of range? : Sas-bi

1034

If you were told to create many records from one record, show how you would do this using array and with proc transpose?

1425

how would you create multiple observations from a single observation? : Sas programming

959

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

1168

What are the uses of sas?

1185

What is the good sas programming practices for processing large data sets?

1067

what are the benefits of data integration? : Sas-di

1034

for what purpose would you use the retain statement? : Sas programming

1029

What are the difference between ceil and floor functions in sas?

1283

Are you involved in writing the inferential analysis plan? Tables specfications?

2516

Name some categories in sas 9? : sas-grid-administration

921

What is the use of PROC gplot?

1071

describe about physical data integration? : Sas-di

1000

What are types of transport files?

7891