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
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 |
In PROC PRINT, can you print only variables that begin with the letter “A”?
How to convert a given date value into SAS date
9 Answers CitiGroup, Quintiles,
Describe the ways in which you can create macro variables?
what is the difference between unique key and primary key? : Sas-di
What are the different operating system platforms in which we can use sas? : sas-grid-administration
How would you remove a format that has been permanently associated with a variable? ________________
how can you improve the performance of a query, If it is excuting very slowly?
diff between nodup rec and ondup key???
I have a dataset concat having a variable a b & c. How to rename a b to e & f?
What data sets do you need to produce the report?
What are the analysis datasets created, and what are the new variables created in CLINICAL SAS
1 Answers Accenture, Sciformix,
in which companies SAS openings are there? List of companies using SAS technology.