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 .

Answer / shambhu verma

Options firstobs=10 obs=20;
proc print data= sas data set;
run;

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

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;

Answer / na

Options Firstobs=10 obs
=20;
Proc print data = xxx;
Run;

Answer / jonathan o&

data Subset;
set whatever;
if _N_ not in (10-20) then delete;
run;

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;

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

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

/* This is example of age caluculate wihtout to display perfect days and years in output window */ data age; retain dob "12jun2003"d now "24may2011"d; age1=now-dob; age=(now-dob)/365.25; years=int(age); days1=round((age-years)*365.25); months=month(now)-1; if days1 gt 30 and months in(12,10,8,6,4,2)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month)*30.4375)+1; drop days1 month1 month; end; else if days1 gt 30 and months in (1,3,5,7,9,11)then do; month1=days1/30.4375; month=int(days1/30.4375); if day(now)=1 then days=1; else days=round((month1-month) *30.4375); drop days1 month1 month; end; drop age age1; proc print data=age; format dob now date.; run;

1 Answers   Emerio,

what is the frontend and backend of sas? Is sas is a progaming langauge or tool? on which langauge sas depends?

3 Answers  

Give some ways by which you can define the variables to produce the summary report (using proc report)?

0 Answers  

How sas treats the dsd delimiters?

0 Answers  

how does sas handle missing values in sort order? : Sas programming

0 Answers  

How do you control the number of observations and/or variables read or written?

0 Answers  

How can you put a "trace" in your program?

2 Answers   Quintiles,

hi guys ...i have one query... data abc; input s w k g o t a m; cards; 1 2 3 4 5 6 7 8 2 3 4 5 6 7 8 9 ; run; i want the output to be the sorted order(only variables).observations should not be changed..

14 Answers  

What is PROC in SAS?

0 Answers  

whenever we using the merging through data set merging ,we can get note in log like this "MERGE STATEMENT HAS MORE THAN ONE ONE DATASET BY REPEATED BY VAIABLES" but the output has come in good manner,whenever in in sql(full join) we can get cartion product.so How do overcome this problem in sql?

1 Answers   Accenture,

how to import HTML files into SAS datasets?

3 Answers   HP,

What is the work of tranwrd function?

0 Answers