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

how will you location sas platform applications available from web browser? : Sas-bi

1076

What is the use of divide function?

1067

Explain data step in SAS

1101

how would you create a data set with 1 observation and 30 variables from a data set with 30 observations and 1 variable? : Sas programming

1345

how to read the variables in sas? : Sas-administrator

1023

How can you create a macro variable with in data step? : sas-macro

1044

What do you know about sas data set?

1118

What is maximum storage capability of SAS?

1425

Describe the function and untility of the most difficult SAS macro that you have written.

2109

What is the maximum length of the macro variable? : sas-macro

1094

Describe the ways in which you can create a macro variable?

1084

What is a pdv and what are its functions?

1153

Where do you use proc means over proc freq?

1122

how do you pull data from equifax?tell me the process?

1799

Explain the difference between using drop = data set option in set and data statement?

1156