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
Name validation tools used in SAS
which date function advances a date, time or datetime value by a given interval? : Sas programming
What is a pdv and what are its functions?
What is the work of tranwrd function?
How we can create SAS USER DEFINED CODE?
What commands are used in the case of including or excluding any specific variables in the data set?
what is the use of sas management console? : Sas-di
what is a method for assigning first.var and last.var to the by groupvariable on unsorted data? : Sas programming
sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately
what is ae onset date n what is RDS
Explain how you can debug and test your SAS program?
Differentiate input and infile.
What are the data types does SAS contain?
why a stop statement is needed for the point= option on a set statement?
What is the command used to find missing values?