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

which date function advances a date, time or datetime value by a given interval? : Sas programming

993

it will become easy if uuu provide website linkssss and list of consultanciessssss

1920

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

1012

what is the effect of the options statement errors=1? : Sas programming

1000

Tell me more about the parameters in macro? : sas-macro

1008

Mention what is the difference between nodupkey and nodup options?

954

How to limit decimal places for the variable using proc means?

999

What is the difference between %local and %global? : sas-macro

1118

what is change analysis in sas di ? : Sas-di

994

how does sas handle missing values in sort order? : Sas programming

871

What is the SAS data set?

1081

how can you put a "trace" in your program? : Sas programming

1003

Describe the ways in which you can create macro variables?

1109

what is the difference between unique key and primary key? : Sas-di

1058

what is hierarchy flattening? : Sas-di

1031