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

In SAS explain which statement does not perform automatic conversions in comparisons?

1363

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

1398

Mention the validation tools used in SAS?

1229

How would you code a merge that will write the matches of both to one data set, the non-matches from the left-most data?

1152

For what purposes have you used sas macros? : sas-macro

1046

what are the considerations when picking a SAS/STAT procedure?

3415

Give some ways by which you can define the variables to produce the summary report (using proc report)?

1132

what are the component of range? : Sas-bi

1147

how many types prompting framework can be broken down to? : Sas-bi

1114

what versions of sas have you used (on which platforms)? : Sas programming

1128

what is the difference between nodup and nodupkey options? : Sas programming

1265

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

1035

What are all the problems you faced while validating tables and reports?

3509

what type of graphs we will create(for 2+years candidates)?

2357

Enlist the functions performed by sas.

1188