Proc sql; create table ab as select * from SASHELP.class where monotonic()

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

Question Posted / anji

Answer Posted / anji

Proc sql;
create table ab as select * from SASHELP.class where monotonic() in (10,12,14);
quit;

Is This Answer Correct ?

14 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are all the problems you faced while validating tables and reports?

3478

How we can create SAS USER DEFINED CODE?

2102

what are the component of range? : Sas-bi

1102

Give e an example of..

2346

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

970

What is a method to debug and test your SAS program?

1381

what are _numeric_ and _character_ and what do they do? : Sas programming

1159

what versions of sas have you used (on which platforms)? : Sas programming

1076

Describe a time when you were really stuck on a problem and how you solved it?

2641

Name few SAS functions?

1101

how would you determine the number of missing or nonmissing values in computations? : Sas programming

1159

How would you code a macro statement to produce information on the sas log? This statement can be coded anywhere? : sas-macro

1052

what is broad cast agent? : Sas-bi

1075

what are the categories that sas informats are used to the place the data? : Sas-administrator

1055

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1801