Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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?

Answer Posted / limnesh

Proc Sql;
Select *,monotonic ()as c from <datasetname>
group by a having c in (100,150,180,190);
quit;

Is This Answer Correct ?    20 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming

1067


what is the Population you used in your project, is it ITT or PP?

2749


what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake

2373


what is proc Index? and what is proc document?

2724


what is ae onset date n what is RDS

2581


What is the basic syntax style in SAS?

1174


what is sas application server? : Sas-di

1086


What is the difference between one to one merge and match merge? Give an example.

1070


what are sas bi dashboard components? : Sas-bi

1174


What is the use of the %include statement?

1173


What commands are used in the case of including or excluding any specific variables in the data set?

1098


what are the types of interactive display types? : Sas-bi

1100


What is connection profile? : sas-grid-administration

1178


Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

2417


What are the implications?

1720