topic Re: Macros for extracting observation from dataset in All Things Community

Macros for extracting observation from dataset

uspanchal — Sat, 30 Mar 2019 08:58:02 GMT

following data step extracting data from 5th observation to 10th observation from datafile

data newfile;
set datafile;
if _N_ in (5,6,7,8,9,10,11,12,13,14) then output;

run;

I am trying same output using macros but it could not give result

I use %obs()

any one can help me on this

Re: Macros for extracting observation from dataset

Kurt_Bremser — Sat, 30 Mar 2019 09:15:32 GMT

Much better do do it with the respective dataset options:

data newfile;
set datafile (firstobs=5 obs=14);
run;

You do not do data manipulation with the macro preprocessor. The macro preprocessor is for creating dynamic code. So unless there is something in this code that you want to make dynamic, there is no need for macro processing.

Re: Macros for extracting observation from dataset

uspanchal — Sat, 30 Mar 2019 09:37:18 GMT

Yes it is much better and easy

thanks a lot sir.

Re: Macros for extracting observation from dataset

Kurt_Bremser — Sat, 30 Mar 2019 09:47:25 GMT

An example for dynamic code expanded from the current one:

%macro mymac(fobs,lobs);

data newfile;
set datafile (firstobs=&fobs. obs=&lobs.);
run;

%mend;

%mymac(5,14)

The "action" is still in the data step, but the parameters are now dynamic.

Re: Macros for extracting observation from dataset

uspanchal — Sat, 30 Mar 2019 09:52:38 GMT

same result appear as you code in macros

thanks a lot