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
- 12367 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 |
How to write duplicate records into a separate dataset using sort?
what is the difference between %put and symbolgen?
Which is the Best SAS training Institute in Delhi NCR for SAS certification preparation
how can you import .csv file in to sas? : Sas programming
How are numeric and character missing values represented internally?
What type of tables you are using in YOUR reporting..???
2 Answers GSK GlaxoSmithKline,
what is snowflake schema? : Sas-di
Explain the special input delimiters used in sas programming.
how do i read multiple spaces in datasets? eg: vijaya raghava perumal.I tried with using & but it workss if its vijaya raghava but not for raghava perumal.how to do this?
1.How to draw pivot tables in Excel by using SAS and in which version we can use VB script for to draw pivot tables in Excel? Answer with example data. 2.What are the advantages of _NULL_ in Data steps? Can we use _NULL_ in Proc steps also? 3. How to call the macro variable into Data Steps? 4. Can we draw pivot tables in Excel using Proc SQL? Please post answers for the above questions with suitable examples, and how to use VB script for Excel using SAS.
What do the mod and int function do? : Sas programming
what is star schema? : Sas-di
Teradata 
