topic Re: How to retrieve multiple range of rows from same table in SAS Programming

Just wanted to retries multiple range of rows from same table

skamal12000 — Tue, 17 Oct 2017 15:40:14 GMT

proc sql ;

CREATE TABLE WORK AS

select *

from cecl.ar_model_v_20170630

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

quit;

How to retrieve multiple range of rows from same table

skamal12000 — Tue, 17 Oct 2017 15:46:32 GMT

%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

Re: How to retrieve multiple range of rows from same table

Reeza — Tue, 17 Oct 2017 16:09:37 GMT

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

Re: How to retrieve multiple range of rows from same table

Reeza — Tue, 17 Oct 2017 16:09:27 GMT

Please do not post the same question multiple times.

Re: How to retrieve multiple range of rows from same table

PGStats — Tue, 17 Oct 2017 17:30:29 GMT

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;

Re: Just wanted to retries multiple range of rows from same table

skamal12000 — Tue, 17 Oct 2017 17:52:40 GMT

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