Date:         Thu, 20 May 1999 14:19:15 -0700
Reply-To:     "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@UGA.CC.UGA.EDU>
From:         "Terjeson, Mark" <TERJEMW@DSHS.WA.GOV>
Subject:      FW: Question on SQL
Comments: To: "Peter_Chen@POLK.COM" <Peter_Chen@POLK.COM>
Content-Type: text/plain

Hi Peter,
    Try the dataset options found below.
 
HTH,
Mark Terjeson
Washington State Department of Social and Health Services
Research and Data Analysis
(360) 902-0741
terjemw@dshs.wa.gov
 
 
 
 
data t1;
    do i = 1 to 500;
       output;
    end;
run;
 
 
proc sql;
    create table t2 as
    select
            *
    from
            t1(firstobs=100 obs=200)
    ;
quit;
 
 
> -----Original Message-----
> From: Peter Chen [SMTP:Peter_Chen@POLK.COM]
> Sent: Thursday, May 20, 1999 1:30 PM
> To:   SAS-L@UGA.CC.UGA.EDU
> Subject:      Question on SQL
>
> Hi, there,
>    Can somebody tell me how to use SELECT statement to retrieve
> the data from record 100 up to record 200 from a table?
>
>    Thanks in advance!
>
> Peter
>
> **********************************************************************
> This message has originated from The Polk Company.
>
> This email and any files transmitted with it are confidential and
> intended solely for the use of the individual or entity to whom they
> are addressed.
>
> If you have received this email in error please delete this message and
> notify the Polk system administrator at postmaster@polk.com.
>
> This message has been scanned for Viruses.
>
> **********************************************************************