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 to include or exclude specific variables in a data set?

1165

Did you used proc test? when?

2088

describe the interaction table in sas di? : Sas-di

1076

what are the scrubbing procedures in sas? : Sas programming

1325

where to use sas business intelligence? : Sas-bi

1163

what is the use of sas management console? : Sas-di

1140

Name few SAS functions?

1147

Describe crosslist option in tables statement?

1266

what are sas/access and sas/connect? : Sas programming

1039

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

1194

Assuming {et} is randomly drawn from N(0,1) and e0 = 0, generate 200 observations of xt = et − 0.5e(t−1) and draw a line graph of xt.

1926

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

1222

name some data transformation used in sas di? : Sas-di

1031

describe about metadata object? : Sas-di

1123

What is the purpose of trailing @ and @@? How do you use them?

1088