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?
Answer Posted / 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 |
Post New Answer View All Answers
if you were told to create many records from one record, show how you would do this using array and with proc transpose? : Sas programming
what is the Population you used in your project, is it ITT or PP?
what is scheduling and how will u implement it. In scheduling 5 jobs r running if there is an error occured at 3rd job and how will u check and waht necessary steps will u take not to repeat the same mistake
what is proc Index? and what is proc document?
what is ae onset date n what is RDS
What is the basic syntax style in SAS?
what is sas application server? : Sas-di
What is the difference between one to one merge and match merge? Give an example.
what are sas bi dashboard components? : Sas-bi
What is the use of the %include statement?
What commands are used in the case of including or excluding any specific variables in the data set?
what are the types of interactive display types? : Sas-bi
What is connection profile? : sas-grid-administration
Do we follow ADAM in analysis dataset development?How? Usually which version? Why is it necessary?
What are the implications?