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 / ashish

Hey , your anwer is almost right but the only correction is
we derived the count variable by using monotonic() function
so that we have to use "calculated count" in where
statement or we can also use HAVING in palce of WHERE..

PROC SQL;
CREATE TABLE TEST AS SELECT
*,
MONOTONIC() AS COUNT
FROM TEST1
HAVING COUNT IN (110,150,170);
QUIT;

Is This Answer Correct ?    4 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Name validation tools used in SAS

1176


which date function advances a date, time or datetime value by a given interval? : Sas programming

1042


What is a pdv and what are its functions?

1141


What is the work of tranwrd function?

1241


How we can create SAS USER DEFINED CODE?

2092


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

1092


what is the use of sas management console? : Sas-di

1090


what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming

1005


sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3585


what is ae onset date n what is RDS

2572


Explain how you can debug and test your SAS program?

1010


Differentiate input and infile.

1099


What are the data types does SAS contain?

1106


why a stop statement is needed for the point= option on a set statement?

1073


What is the command used to find missing values?

1097