Proc Sql; Select *,monotonic ()as c from <datasetname> group by a h

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 / limnesh

Answer Posted / limnesh

Proc Sql;
Select *,monotonic ()as c from <datasetname>
group by a having c in (100,150,180,190);
quit;

Is This Answer Correct ?

20 Yes

5 No

Please Help Members By Posting Answers For Below Questions

What function CATX syntax does?

1258

how does sas handle missing values in assignment statements? : Sas programming

1072

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

1202

what is the limit of the number of the rows and columns available in the worksheet? : Sas-bi

1143

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

1092

What is the work of tranwrd function?

1301

Explain why double trailing @@ is used in input statement?

1116

What areas of SAS are you most interested in?

1583

Enlist the functions performed by sas.

1197

What is the maximum and minimum length of macro variable

1344

Explain append procedure?

1134

what are the types of interactive display types? : Sas-bi

1151

Describe the ways in which you can create macro variables?

1256

What is maximum storage capability of SAS?

1491

Explain how merging helps to combine data sets.

1117