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

What makes sas stand out to be the best over other data analytics tools?

1082


what is the primary data source for the wrs? : Sas-bi

1252


how do you debug and test your sas programs? : Sas programming

1137


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

2773


How to limit decimal places for the variable using proc means?

1089


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

1000


Differentiate between proc means and proc summary.

1069


how do you want missing values handled? : Sas programming

966


How will you react when, while consulting a SAS documentation manual to get an answer to a problem, someone says hey, I thought you were supposed to know all that stuff already, and not have to look it up in a book?

2473


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

2198


how do you pull data from equifax?tell me the process?

1809


What can you learn from the SAS log when debugging?

1397


where are dashboard components are created and maintained? : Sas-bi

1025


for report generation which one you used proc report or data_null_?

7810


Hi Friends, Am Priya,new to your forum. am looking for Interview questions on SAS Platform Administration. I searched everywhere but I couldn't find them,please can anyone help me with complete interview questions normally everyone will face in the interviews on SAS Administration. am really facing problems in the interviews,am not able to answer any of their questions. I would really appreciate all your help if you can email the complete Interview Questions to priyafeb84@gmail.com Kindly awaiting for your reply with eager

2092