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...

in data set200 observation how to take 110,150,170 using sql procedure?

Answer Posted / ram

We have number of options to select or retrieve the data
data part_of;
/*do slice = 100,200,300,400,550,600,700,800,900;*/
do slice = 100 to 900;
set example_1 point=slice;
output;
end;
stop;
run;
Proc Sql;
Select *,monotonic ()as c from example_1
group by date having c in (110,150,170,190);
quit;
Proc Sql;
Select *from example_1
group by date having date in (100,150,180,190);
quit;

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can you create zero observation dataset? : Sas programming

1090


how to create the AE dataset by using SDTMIG specifications and SAP plan by using UNIX platform?

2706


Which command is used to perform sorting in sas program?

989


what type of graphs we will create(for 2+years candidates)?

2242


How you can read the variables that you need?

1072


explain about data integrator metadata reports? : Sas-di

1040


Mention the category in which sas informats are placed?

977


is data integration and etl programming is same? : Sas-di

1010


WHAT IS SAS WEB SERVICE and what are the steps to create an xml service ?

2738


What is the difference between input and infile statement?

1116


What are the five ways to do a table lookup in sas? : sas-grid-administration

995


Describe the function and utility of the most difficult SAS macro that you have written?

2481


What are the automatic variables for macro? : sas-macro

1144


if the Id has more then two transcatiion then show the first observation, IF Id has only two observation then It show both the observation

1555


Approximately what date is represented by the SAS date value of 730?

1162