topic Storing the number of observations when using my Macro function? in SAS Programming

Storing the number of observations when using my Macro function?

SasStatistics — Thu, 10 Jun 2021 10:15:35 GMT

I have created a macro called: num_obs that returns the number of observations in a data set.

I can save the result in an data step like:

data saved_num_obs; 
	observ = %num_obs(WORK.TEST); 
run;

Now, I would like to save the result to a macro variable instead.

So, how would i save an result from using a macro to a Macro variable?

I thought something like:

%let My_Macro = num_obs(test_table) ;

This does not work.

Any suggestions?

Re: Storing the number of observations when using my Macro function?

andreas_lds — Thu, 10 Jun 2021 10:33:50 GMT

Just call the macro the same way you use in the data step: with leading %.

Re: Storing the number of observations when using my Macro function?

Tom — Thu, 10 Jun 2021 11:52:29 GMT

If depends a lot on how the macro works.

But first make sure to actually call the macro and not just assign the name of the macro to the macro variable. You left the % out of your macro call.

%let My_Macro = %num_obs(test_table) ;