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

what can you learn from the sas log when debugging? : Sas programming

601

In ARRAY processing, what does the DIM function do?

703

What are the different operating system platforms in which we can use sas? : sas-grid-administration

582

What are common programming errors committed in sas

663

How do you control the number of observations and/or variables read or written? Approximately what date is represented by the SAS date value of 730?

1154

what is factor analysis? : Sas-administrator

600

Name and describe few sas character functions that are used for data cleaning in brief.

658

Mention sas system options to debug sas macros.

655

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

587

Do you need to know if there are any missing values?

587

Explain proc sort?

657

Explain data step in SAS

619

What is the different between functions and PROCs that calculate the same simple descriptive statistics?

1219

How are numeric and character missing values represented internally?

1130

How you can read the variables that you need?

645