Interested to Buy Any Domain ? << Click Here >> for more details...
You have a data set of 100 observations,how can you
restrict the output so that the output has only data from
row no. 10 to row no. 20
- 9 Answers
- 12201 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / reema
For that u have to use fistobs and obs both.
Eg:- firstobs 10 obs 20
Firstobs :- Will start observing from the row 10 ..
Obs:- will show till 20th observation .
| Is This Answer Correct ? | 21 Yes | 3 No |
Answer / shambhu verma
Options firstobs=10 obs=20;
proc print data= sas data set;
run;
| Is This Answer Correct ? | 9 Yes | 0 No |
Answer / amit gupta
SELECT *
FROM (SELECT ROWNUM srno, a.*
FROM emp a)
WHERE srno >= 10 AND srno <= 20
/
SELECT *
FROM (SELECT ROWNUM srno, a.*
FROM emp a)
WHERE srno between 10 and 20
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / suri
output window
1)proc print data=ds1(firstobs=10 obs=2);
run;
2)data ds1;
set ds(firstobs=10 obs=20);
run;
3)data ds1;
set ds;
where _n_ in(10:20);
run;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jonathan o&
data Subset;
set whatever;
if _N_ not in (10-20) then delete;
run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / monika
Data test;
input a 8. @@;
datalines;
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
;
run;
Data Result;
Set test(firstobs=10 obs=20);
Run;
Proc print data = Result;
Run;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / dharani
Corection to Reema's answer :
Eg:- firstobs 10 obs 10
Firstobs :- Will start observing from the row 10 ..
Obs:- will show total 11 observations .from 10 - 20
| Is This Answer Correct ? | 1 Yes | 5 No |
Answer / xxxx
Corection to Reema's answer :
Eg:- firstobs 10 obs 10
Firstobs :- Will start observing from the row 10 ..
Obs:- will show total 10 observations .from 10 - 20
| Is This Answer Correct ? | 1 Yes | 7 No |
if x=round(26.3,10)-1 then x= how much and how explain?
what are the methods that you would employ to fine tune your SQL extract process using SAS/Access or Proc SQL?
what is change analysis in sas di ? : Sas-di
Name any two sas spawners? : sas-grid-administration
How many versions came upto now in SAS?
HOW MANY WAYS YOU CAN RETRIEVE THE DATA FROM ORACLE TABLES? WHAT IS ORACLE CLINICAL? HOW IT IS USEFUL?
3 Answers Accenture, Novartis,
what is _error_?
2 Answers Axis Bank, Cognizant, JPMorgan Chase,
what are validation tools that are used in sas? : Sas-administrator
What is highest missing value for numeric?
Tell e how how dealt with..
Why and when do you use proc sql?
Name statements that are recognized at compile time only?
Teradata 
