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 does the trace option do?

1054

what has been your most common programming mistake? : Sas programming

1024

what is star schema? : Sas-di

1071

what is sas metadata repository? : Sas-bi

1049

To what type of programms have you used scratch macros?

2522

How can sas program be validated?

971

Can you execute macro within another macro? : sas-macro

933

Mention what is the difference between nodupkey and nodup options?

954

Differentiate between proc means and proc summary.

994

What can be the size of largest dataset in SAS?

1169

How would you determine the number of missing or nonmissing values in computations?

1005

Explain the difference between nodup and nodupkey options?

956

What is the function of Stop statement in a SAS Program?

1087

for what purpose would you use the retain statement? : Sas programming

1016

What is SAS informats?

1051