in data set200 observation how to take 110,150,170 using sql procedure?

Answers were Sorted based on User's Feedback



in data set200 observation how to take 110,150,170 using sql procedure?..

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

in data set200 observation how to take 110,150,170 using sql procedure?..

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

in data set200 observation how to take 110,150,170 using sql procedure?..

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

in data set200 observation how to take 110,150,170 using sql procedure?..

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

in data set200 observation how to take 110,150,170 using sql procedure?..

Answer / naveen

proc sql;
select *
from qqq
where Height in(69);
quit;

Is This Answer Correct ?    0 Yes 2 No

in data set200 observation how to take 110,150,170 using sql procedure?..

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

in data set200 observation how to take 110,150,170 using sql procedure?..

Answer / naveen

proc sql;
select *
from
where obs, in(11, 23,44);
quit;

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SAS Interview Questions

What do the mod and int function do? : Sas programming

0 Answers  


WHAT IS DEBUGGING? HOW TO TEST THE DEBUGGING IN SAS?

3 Answers   Accenture,


What data sets do you need to produce the report?

2 Answers   Novartis,


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?

6 Answers   GSK,


what is in stream data in SAS?

1 Answers  






why only we use SAS? their r many programmin language like SPSS, Oracle... Why SAS?

2 Answers   Accenture,


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?

0 Answers  


What would you change about your job?

0 Answers   Oracle,


In which case u go for libname and in which case u go for proc sql pass thru facilit diff?

1 Answers  


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

2 Answers   TCS,


Categories