in data set200 observation how to take 110,150,170 using sql procedure?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Compare sas with other data analytics tools.

572


What do the PUT and INPUT functions do?

767


how do you pull data from equifax?tell me the process?

1369


How many ways to overcome a missing values???

2323


What is the basic syntax style in SAS?

607






For what purposes have you used sas macros? : sas-macro

531


Describe the ways in which you can create macro variables? : sas-macro

568


how would you create multiple observations from a single observation? : Sas programming

560


Differences between where and if statement?

576


what cause the "error: connect:" and "error in the libname statement" when there weren't any such problems?

1673


How would you include common or reuse to be processed along with your statements?

1894


How to create list output for cross-tabulations in proc freq?

612


what is program data vector? : Sas-administrator

604


Give some ways by which you can define the variables to produce the summary report (using proc report)?

587


How would you define the end of a macro? : sas-macro

595