Hi, Try this code. I have used Firestobs and obs options. Also i have tried as Cynthia suggested, it is also working. I have suggested another logic. Kindly let me know your reviews. data a ; input x y $; cards; 1 a 2 b 3 NA 4 d 5 e 6 f 7 g 8 h 9 i 10 j 11 k 12 NA 13 NA 14 a 15 b 16 NA 17 d 18 d 19 i 20 e 21 f 22 m 23 x 24 v 25 NA ; /* if I don't want to include observations between 8 and 14 and observations having "NA" values*/ data a1; set a (obs=7); if y="NA" then delete; run; data a2; set a (firstobs=15 obs=max); if y="NA" then delete; run; data a_final; set a1 a2; run; /* As per Cynthia's suggestion */ data a_111; set a; if _N_ ge 8 and _N_ le 14 or y in ('NA' 'N/A' 'Not Applicable') then delete; run;
... View more