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 do you test for missing values?

1059

Are you sensitive to code walk-throughs peer review or QC review?

2611

sas implementing companies in pune implementing clinical projects if anyone knows plz send ans immediately

3112

how does sas handle missing values in a merge? : Sas programming

555

What is a method to debug and test your SAS program?

721

How do you connect the desktop application to metadata server? : sas-grid-administration

585

What is the difference between reading data from an external file and reading data from an existing data set?

637

What is the role of sas grid administrator? : sas-grid-administration

829

what is sas metadata server? : Sas-di

593

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

568

Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?

1915

What do you code to create a macro? : sas-macro

582

How long can a macro variable be? A token? : sas-macro

718

Explain bmdp procedure?

614

how does sas handle missing values in formats? : Sas programming

583