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
- 11879 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 |
How would you code the criteria to restrict the output to be produced?
Name statements that are recognized at compile time only?
Explain the message 'Merge has one or more datasets with repeats of by variables'.
In the SAS Data step what is the difference between the subsetting done by Where and subsetting done by If?
Explain proc univariate?
When you will use nowd option in report???
What is the difference between nodup and nodupkey options?
20 Answers iFlex, Makro, Talwar,
SAS using companies in chennai
sas macros
do you need to know if there are any missing values? : Sas programming
data voter; input Age Party : $1. (Ques1-Ques4)($1. + 1); datalines; 23 D 1 1 2 2 45 R 5 5 4 1 67 D 2 4 3 3 39 R 4 4 4 4 19 D 2 1 2 1 75 D 3 3 2 3 57 R 4 3 4 4 ; Idont understand what the (Ques1-Ques4)($1. + 1) means. I have seen (Ques1-Ques4)(4*$1.), but what is (Ques1-Ques4)($1. + 1)? Appreciate all help Thanks
What is the sas data set? : sas-grid-administration
Teradata 
