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 dominic

Before saying answer is not correct, please try this
Data f;
do i=1 to 200;
output;
end;
run;

Proc Sql;
Select *,monotonic ()as c from f
group by i having c in (100,150,180,190);
quit;

Proc print;
run;

Is This Answer Correct ?    15 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the purpose of substr functions in sas programming.

1003


What is the difference between class statement and by statement in proc means?

1187


What Proc glm does?

1020


Can you explain the process of calendar?

1051


what is the use of proc contents and proc print in sas? : Sas-administrator

996


What is the difference between INPUT and INFILE ?

1236


Explain the use of proc gplot? : sas-grid-administration

926


What would be the value of month at the end of data step execution and how many observations would be there?

1053


How to create list output for cross-tabulations in proc freq?

1060


Tell e how how dealt with..

2167


which date functions advances a date time or date/time value by a given interval? : Sas programming

898


What is a pdv and what are its functions?

1041


What is the sas data set? : sas-grid-administration

917


what are the component of range? : Sas-bi

1015


why is sas data integration studio important? : Sas-di

971