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 |
describe the interaction table in sas di? : Sas-di
I have 3 years of work experience at a startup and recently got certified in Data Science with SAS. I need to know how to get into the analytics industry
what is conditional processing?
PROC SQL always ends with QUIT statement.Why cant you use RUN in PROQ SQL ?
what type of graphs we will create(for 2+years candidates)?
· What are some good SAS programming practices for processing very large data sets?
how can you get the single data set from the library(which has the number of data sets)?
3 Answers Accenture, Deloitte,
Can you calculate the mean, median and mode of the following data set using data step logic? Don't use any function or procedure. data a; input age @@; datalines; 22 32 32 32 43 23 24 56 45 54 28 29 27 26 25 28 30 20 18 37 36 47 46 56 19 20 ; run; I have calculated the mean which i have posted in the answer section.
What does a PROC TRANSPOSE do?
What is SAS? is it a software just for use or we can creat something over there?
what is the difference between calculating the 'mean' using the mean function and proc means? : Sas programming
How would you delete duplicate observations?