PROC SQL; CREATE TABLE TEST AS SELECT *, MONOTONIC() AS COUNT FROM TEST

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

Question Posted / pranoy

Answer Posted / pranoy

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

Is This Answer Correct ?

2 Yes

5 No

Please Help Members By Posting Answers For Below Questions

what are sas bi dashboard components? : Sas-bi

1169

Mention what are the data types does SAS contain?

1147

How is character variable converted into numeric variable and vice versa?

1170

This entry was posted in General. Bookmark the permalink. Post a comment or leave

4573

What are the difference between sas functions and procedures?

1149

Explain the difference between informat and format with an example.

1162

what is star schema? : Sas-di

1123

What is interleaving in SAS?

1107

explain the proc in sas? : Sas-administrator

1086

How would you identify a macro variable? : sas-macro

1016

how will you locate the sas platform applications? : Sas-bi

1026

What are the special input delimiters used in SAS?

1176

what do the sas log messages "numeric values have been converted to character" mean? : Sas programming

1030

Explain data_null_?

1052

Tell me about % include and % eval? : sas-macro

1138