topic Re: go over all the observations and do macro calculations in New SAS User

go over all the observations and do macro calculations

Xiyuan — Wed, 30 Mar 2022 08:21:45 GMT

hi all

I have a dataset with N observations and 2 variables X & Y.

I want to execute a macro function for each observation, that means i need to execute N times.

Each time the inputs of the macro are the values of X and Y, like %fn(input1=X,input2=Y)

How to program as quickly as possible?

Thanks very much

Re: go over all the observations and do macro calculations

Xiyuan — Wed, 30 Mar 2022 08:28:56 GMT

The format of X and Y are both numeric

Re: go over all the observations and do macro calculations

PeterClemmensen — Wed, 30 Mar 2022 08:44:17 GMT

Use Call Execute logic and the macro in combination.

For a more detailed answer, provide sample data please.

Re: go over all the observations and do macro calculations

Patrick — Wed, 30 Mar 2022 08:46:22 GMT

I'm not sure that using a SAS Macro is the technical solution to your problem. What would really help: Provide sample data in the form of a SAS data step creating this sample data, show us the desired result based on the sample data, explain the logic how to get from the sample data to the desired result.

Re: go over all the observations and do macro calculations

PaigeMiller — Wed, 30 Mar 2022 10:17:25 GMT

Okay, you told us X and Y are numeric (even though that probably doesn't help at this point in time). Now tell us what %FN does.

Re: go over all the observations and do macro calculations

tarheel13 — Thu, 31 Mar 2022 14:17:33 GMT

have you considered proc fcmp? I think it can help you here.

Re: go over all the observations and do macro calculations

Tom — Thu, 31 Mar 2022 17:06:09 GMT

Assuming you called the macro a "function" out of habit and not because you think will behave the same as a SAS function like LOG() or MEAN() you could just generate one macro call per observation.

So assuming that your dataset is named HAVE you could run something like this:

filename code temp;
data _null_;
  set have;
  file code;
  put '%fn(input1=' X ',input2=' Y ')' ;
run;
%include code / source2;

The data step will write one line of code per observation. The %INCLUDE statement will then run the generated lines of code.