Date:         Tue, 29 Jul 2008 13:16:21 -0500
Reply-To:     "data _null_," <datanull@GMAIL.COM>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "data _null_," <datanull@GMAIL.COM>
Subject:      Re: how to sample compressed dataset?
Comments: To: Jeff <zhujp98@gmail.com>
In-Reply-To:  <6716d5d0807291036o43df4251n53d519491bc2723f@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1

I think you have at least two options.

1) use POINTOBS when you create compress data set.
2) use SURVEYSELECT to sample.


data shoes(compress=binary reuse=yes /*pointobs=yes*/);
   set sashelp.shoes;
   run;
data sample;
   do point = 1 to nobs by 20;
      set shoes point=point nobs=nobs;
      output;
      end;
   stop;
   run;
proc sql;
   select round(20/nobs,.01) into :rate
      from dictionary.tables
      where libname eq 'WORK' and memname eq 'SHOES';
   quit;
   run;

%put NOTE: Rate=&rate;
proc surveyselect rate=&rate data=shoes out=shoes20;
   run;


On 7/29/08, Jeff <zhujp98@gmail.com> wrote:
> 12 data orig.claims;
>
> 13 do pickit=1 to totobs by 20;
>
> 14 set origdata.claims point=pickit nobs=totobs;
>
> 15 end;
>
> 16 stop;
>
> 17 run;
>
> ERROR: The POINT= data set option is not valid for the data set
> ORIGDATA.CLAIMS, the data set must be
>
> accessible by observation number for POINT= processing.
>
> NOTE: The SAS System stopped processing this step because of errors.
>
> WARNING: The data set ORIG.CLAIMS may be incomplete. When this step was
> stopped there were 0
> observations and 26 variables.
>
> ----------------------
> origdata.claim is given by someone else.
>
> How to sample this compressed dataset? thanks.
>
> Thanks.
> Jeff
>