Interested to Buy Any Domain ? << Click Here >> for more details...
There are 200 observations in a dataset, i want to pull out
the observation no's 100, 150,180,190 by using Proc SQL? How
you can get it?
- 5 Answers
- 13317 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / limnesh
Proc Sql;
Select *,monotonic ()as c from <datasetname>
group by a having c in (100,150,180,190);
quit;
| Is This Answer Correct ? | 20 Yes | 5 No |
Answer / limnesh dominic
Before saying answer is not correct, please try this
Data f;
do i=1 to 200;
output;
end;
run;
Proc Sql;
Select *,monotonic ()as c from f
group by i having c in (100,150,180,190);
quit;
Proc print;
run;
| Is This Answer Correct ? | 15 Yes | 0 No |
Answer / jim
* Setup test data;
data test;
do i=1 to 200;
j=ranuni(i);
output;
end;
run;
Proc Sql;
Select *,monotonic ()as c from test
having c in (100,150,180,190);
quit;
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / pranoy tikadar
PROC SQL;
SELECT*,
MONOTONIC() AS COUNT
FROM TEST
HAVING COUNT IN(100,150,180,190);
QUIT;
| Is This Answer Correct ? | 11 Yes | 3 No |
Answer / vipin choudhary
Proc Sql;
Select * from <dataset name>
where _n_ in (100,150,180,190);
quit;
| Is This Answer Correct ? | 12 Yes | 29 No |
what does .. meant in sas macros
how can u create zero observation dataset?
What are the special input delimiters used in SAS?
what is PhaseIII, ODS, TLG, Macro and Proc in SAS
what are several options for creating reports in web report studio? : Sas-bi
do you need to know if there are any missing values? : Sas programming
What is the difference between informat and format statement?
What do the PUT and INPUT functions do?
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?
How might you use MOD and INT on numeric to mimic SUBSTR on character Strings?
What does error:1 mean?
What do you feel about hardcoding?
Teradata 
