in data set200 observation how to take 110,150,170 using sql procedure?
Answers were Sorted based on User's Feedback
Answer / anji
Proc sql;
create table ab as select * from SASHELP.class where monotonic() in (10,12,14);
quit;
Is This Answer Correct ? | 14 Yes | 1 No |
Answer / ashish
Hey , your anwer is almost right but the only correction is
we derived the count variable by using monotonic() function
so that we have to use "calculated count" in where
statement or we can also use HAVING in palce of WHERE..
PROC SQL;
CREATE TABLE TEST AS SELECT
*,
MONOTONIC() AS COUNT
FROM TEST1
HAVING COUNT IN (110,150,170);
QUIT;
Is This Answer Correct ? | 4 Yes | 3 No |
Answer / ram
We have number of options to select or retrieve the data
data part_of;
/*do slice = 100,200,300,400,550,600,700,800,900;*/
do slice = 100 to 900;
set example_1 point=slice;
output;
end;
stop;
run;
Proc Sql;
Select *,monotonic ()as c from example_1
group by date having c in (110,150,170,190);
quit;
Proc Sql;
Select *from example_1
group by date having date in (100,150,180,190);
quit;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / alok karan
proc sql;
select *,monotonic()as obs from alok.countries
where calculated obs in(1,4,8,7,21,23)
;
quit;
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
What do the mod and int function do? : Sas programming
WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?
What data sets do you need to produce the report?
i have a null dataset with 10 variables; i want to print only name of the varibales in log window and also output window.how can we do this one?
what is in stream data in SAS?
why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?
What is LAG function?How is it used? can any one explain
3 Answers TRE, Verinon Technology Solutions,
What is the difference between using drop = data set option in data statement and set statement?
What would you change about your job?
In which case u go for libname and in which case u go for proc sql pass thru facilit diff?
what is chi-square test? have you used that?
1 Answers Accenture, Quintiles,
How can a SAS WEB REPORT STUDIO USER identify which report tabs they have been permitted without entering the SAS WEB REPORT STUDIO