Just wanted to retries multiple range of rows from same table

[skamal12000]

proc sql ;

CREATE TABLE WORK AS

select *

from cecl.ar_model_v_20170630

where (firstobs = 100 obs = 200) & (first obs = 400 obs = 500) ;

quit;

[skamal12000]

%let cecl =/sas/model/model_dev/enterprise_inputs/published_data/cecl/M201706;

libname cecl "&cecl";

　

proc sql ;

CREATE TABLE WORK AS

select *

from cecl.ar_model_v_20170630

where (firstobs = 100 obs = 200) & (first obs = 400 obs = 500) ;

quit;

like try to retrieve row number 100 to 200 and then 500 to 600 from same table

[Reeza]

Try a data step instead. SQL doesn't have a good way to extract specific rows.

data want;
set have;

if 100 <= _n_ <=300 or  400 <= _n_ <= 900;

run;

---

@skamal12000 wrote:

%let cecl =/sas/model/model_dev/enterprise_inputs/published_data/cecl/M201706;

libname cecl "&cecl";

　

proc sql ;

CREATE TABLE WORK AS

select *

from cecl.ar_model_v_20170630

where (firstobs = 100 obs = 200) & (first obs = 400 obs = 500) ;

quit;

like try to retrieve row number 100 to 200 and then 500 to 600 from same table

---

[Reeza]

Please do not post the same question multiple times.

[PGStats · Accepted solution]

With SQL:

proc sql;
CREATE TABLE WORK AS
select * from cecl.ar_model_v_20170630(firstobs=100 obs=200)
union all
select * from cecl.ar_model_v_20170630(firstobs=500 obs=600);
quit;

[skamal12000]

Thank you so much for your help. I am very new to SAS database.