topic Re: Base SAS in SAS Programming

Base SAS

SandeepAmte — Wed, 14 Oct 2015 15:39:31 GMT

Hi,

How to select observation between 10 to 20 using proc sql?

stat_sas — Wed, 14 Oct 2015 15:57:55 GMT

Please provide a sample data set.

Jagadishkatam — Wed, 14 Oct 2015 16:03:16 GMT

Please try firstobs and obs options

here sas applies the formula

(obs - firstobs) + 1 = resulting obs number

proc sql;
create table test as select * from sashelp.class(firstobs=10 obs=20);
quit;

Thanks,

Jag

LinusH — Thu, 15 Oct 2015 12:45:59 GMT

Even if the solution provided by https://communities.sas.com/t5/user/viewprofilepage/user-id/12151 is feasible, SQL is not by nature a row oriented language. The data step is.

Why SQL? What is the underlying requirement?