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

Of all your work, where have you been the most successful?

4190

Given an unsorted data set, how to read the last observation to a new data set?

823

What is the difference between reading data from an external file and reading data from an existing data set?

626

Explain data step in SAS

619

What is the role of sas grid administrator? : sas-grid-administration

816

What is the general format of function in sas? : sas-grid-administration

556

What are the difficulties u faced while doing vital signs table or dataset?

1920

what is the effect of the options statement errors=1? : Sas programming

576

Difference between informat and format?

633

what is intially documentation in sas?

4317

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

584

explain about sas business intelligence? : Sas-bi

590

How you are maintaining sas programmes in your company...any specific version control software you are using? If so, tell me the name?

1569

Do you need to know if there are any missing values?

586

How do dates work in sas?

633