Interview Questions   Tutorials   Discussions   Programs   Videos   

SAS - There are 200 observations in a dataset, I want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?




317
views
asked mar September 20, 2014 06:29 AM  

There are 200 observations in a dataset, I want to pull out the observation no's 100, 150,180,190 by using Proc SQL? How you can get it?


           

1 Answers



 
answered By vishnoiprem   0  

We can use be below SQL:

PROC SQL;

SELECT*,
MONOTONIC() AS COUNT
FROM EMP

HAVING COUNT IN(100,150,180,190);
QUIT; 
flag   
   add comment

Your answer

Join with account you already have

FF

Preview

 Write A Tutorials
Online-Classroom Classes
www.writeabc.com


  1 person following this question

  Question tags

sas × 1

Asked 2 years and 3 months ago ago
Number of Views -317
Number of Answers -1
Last updated
3 years and 2 months ago ago

  Similar questions


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert