Interested to Buy Any Domain ? << Click Here >> for more details...
in data set200 observation how to take 110,150,170 using sql procedure?
- 7 Answers
- 12330 Views
- Accenture, I also Faced
- E-Mail Answers
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 is connection profile? : sas-grid-administration
what are informats in sas? : Sas-administrator
Have you ever linked SAS code? If so, describe the link and any required statements used to either process the code or the step itself.
how to handle in stream data containing semicolon in it?
What is the purpose of the trailing and How would you use them?
Is the physical structure of the data set in the same orientation as the report? Do you need to reshape the data sets? What method should you use to reshape the data–DATA steps,PROC TRANSPOSE,output data set from a procedure?
What is maximum number of rows and cols can be handled in SAS?
how to get second highest salary from a employee table and how get a 5th highest salary from a employee table?
What is the difference between match merge and one to one merge?
What does P-value signify about the statistical data?
i have a null dataset with 20 variables. i want to upload the variables which contain name like a or k or anything in another dataset.how can we create the dataset?
What are the different servers in sas? : sas-grid-administration
Teradata 
