topic Re: Extract only first 100 obs in Extract Transformation in SAS Data Management

Extract only first 100 obs in Extract Transformation

David_Billa — Fri, 01 Jan 2021 06:14:38 GMT

I want to extract only first 100 obs in Extract Transformation. Input data is SQL table which was already registered in SAS. I tried with table options but it's not producing the desired output.

Re: Extract only first 100 obs in Extract Transformation

Shmuel — Fri, 01 Jan 2021 07:19:18 GMT

Add OPTIONS OBS=100; preceding the extraction step.

Don't forget to reset it after the extraction by OPTIONS OBS=MAX;

If still have the same undesired result please post the full log of the running extraction.

Re: Extract only first 100 obs in Extract Transformation

David_Billa — Fri, 01 Jan 2021 08:01:53 GMT

Should I add the options statement in precode of extract transformation?

Re: Extract only first 100 obs in Extract Transformation

Shmuel — Fri, 01 Jan 2021 08:14:39 GMT

do it as:

options obs=100;

/* extraction code put here */

options obs=max;

Re: Extract only first 100 obs in Extract Transformation

novinosrin — Fri, 01 Jan 2021 11:56:29 GMT

or You could try OBS=100 as a dataset option as an alernative to global options statement-

data want;
 set have(obs=100);	/*dataset option obs=100*/
run;

/*Or Using _N_ iteration counter*/
data want;
 set have;
 if _n_>100 then stop;
run;

/*Dataset option in SQL*/
proc sql ;
 create table want as
 select *
 from have(obs=100);
quit;