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

Name validation tools used in SAS

1176


In ARRAY processing, what does the DIM function do?

1168


How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1093


how sas deals with business intelligence? : Sas-bi

1053


What are the new features included in the new version of SAS Programming Language?

1205


what is snowflake schema? : Sas-di

1213


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

1058


Mention how to limit decimal places for the variable using proc means?

1111


What are SAS/ACCESS and SAS/CONNECT?

1140


Explain bmdp procedure?

1032


Differentiate input and infile.

1099


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

947


What do you know about sas and what we do? : sas-grid-administration

1138


Are you involved in writing the inferential analysis plan? Tables specifications?

3950


How do you use the do loop if you don’t know how many times you should execute the do loop?

1256