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
- 10753 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 to add distinctly var variable values ex.. Data a; input var; datalines; 0 1 2 3 -1 -2 -3 ; run; adding all +ve value in one varibale n do the same for -ve too
Please, anyone, let me know the style or an example of using 'by='/'by' variable of a PDV(Program Data Vector)
3 Answers Verinon Technology Solutions,
how do i get last 10obs from a dataset when we don't know about the number of obsevations in that dataset?
If you were told to create many records from one record show how you would do this using arrays and with PROC TRANSPOSE?
What was the last computer book you purchased? Why?
What is the function of output statement in a SAS Program?
Can you execute a macro within a macro? Describe. : sas-macro
for report generation which one you used proc report or data_null_?
3 Answers Accenture, Quintiles,
how to intersect the tables by using PROC MIXED?
how can you sort the dataset having millions of OBS(instead of sort procedure?
what are sas bi dashboard components? : Sas-bi
What are SAS/ACCESS and SAS/CONNECT?
Teradata 
