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 is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

963

: and & modifiers.

1336

Describe what are the different levels of administrative users in sas? : sas-grid-administration

982

what is star schema? : Sas-di

1075

What are the differences between proc means and proc summary?

1068

What is factor analysis?

1079

What is data _null_?

1081

How are numeric and character missing values represented internally?

1608

What is a method for assigning first.VAR and last.VAR to the BY group variable on unsorted data?

2532

Describe 5 ways to do a “table lookup” in SAS?

1087

how could you generate test data with no input data? : Sas programming

1116

For what purposes have you used sas macros? : sas-macro

954

What are symget and symput? : sas-macro

1244

How can sas program be validated?

975

what techniques and/or procs do you use for tables? : Sas programming

997