topic Re: Subset in SAS Programming

Subset

HeatherNewton — Fri, 12 May 2023 20:05:00 GMT

What is the command to run the transformation (within a data step)
To only a small no of rows?

Re: Subset

Tom — Fri, 12 May 2023 20:10:04 GMT

You need to provide more details about what you are trying to do to get a better answer.

In general to execute some statements for only some of the observations you would use an IF statement.

Something like this:

data want;
  set have;
   if sex='M' then do;
     num_births=.;
  end;
run;

Re: Subset

SASKiwi — Fri, 12 May 2023 23:05:39 GMT

Another common technique to do this is to limit the number of rows read.

data want;
  set have (obs = 100);
 <My logic here>;
run;

Re: Subset

HeatherNewton — Sat, 13 May 2023 01:27:10 GMT

yes this is what I know. but my boss said even if I have many data step for different datasets, I can just add some statement at the top and it can apply to all subsequent data steps say only 10 obs for each dataset in each data step but only need to specify once, have you heard??

Re: Subset

mkeintz — Sat, 13 May 2023 02:30:02 GMT

You could use

options obs=10;

which will imply an (OBS=10) dataset name parameter for all datasets in a SET or MERGE statement.

Editted note: you can use this options obs= statement anywhere in the program, and it will be honored for the rest of the program until overwritten. The default value is

options obs=max;

Re: Subset

HeatherNewton — Mon, 15 May 2023 11:01:24 GMT

does this include set statement inside a macro ?

Re: Subset

PaigeMiller — Mon, 15 May 2023 11:06:34 GMT

@HeatherNewton wrote:

does this include set statement inside a macro ?

Try it

Although I will give you a hint ... if the macro creates valid SAS code, then the macro should run.

Re: Subset

Kurt_Bremser — Mon, 15 May 2023 11:49:54 GMT

OBS= is a system option. Think about the meaning of "system" 😉