* Setup test data; data test; do i=1 to 200; j=ranuni(i); output; end;

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

5 Answers
12890 Views
I also Faced
E-Mail Answers

Answer Posted / jim

* Setup test data;
data test;
do i=1 to 200;
j=ranuni(i);
output;
end;
run;

Proc Sql;
Select *,monotonic ()as c from test
having c in (100,150,180,190);
quit;

Is This Answer Correct ?

8 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you convert basic cube to transaction cube and transaction cube to basic cube?

2188

What is slibref?

1213

Explain what is the use of proc gplot?

1126

Differentiate between proc means and proc summary.

1004

: and & modifiers.

1336

what is sas metadata server? : Sas-di

1050

what is information maps?

2156

what is sas data set?

1059

what is sas business intelligence? : Sas-bi

1093

what is the purpose of _error_? : Sas programming

1084

What is SAS? What are the functions does it performs?

1140

What was the last computer book you purchased? Why?

2316

What is interleaving in SAS?

1065

What is the use of %include statement?

997

What are pdv and it functions?

1038