is there a way to call an already created macro function and use it in another macro function that I am trying to create?
For functions you want Proc FCMP.
Macros don't return values.
You can call a macro within any other macro once it's been compiled.
%macro_name(parameters);
If your replicating R code you can consider SAS/IML instead of Base.
Otherwise you may want to define your functionality and figure out the best method in SAS. Trying to replicate exactly is more work in long run. My nickel.
Yes you can.
In the same session you can do stuff like this:
%macro outer;
%put In outer;
%inner
%mend
%macro inner;
%put In inner
%mend;
%outer;
The inner macro needs to be defined at call time, not nescecarily when %Outer is defined. And %inner can be redefined without the need for %outer to be recompiled.
Existing macros can also be defined earlier or outside SAS. Store them in a file with the .sas extension and have the SASAUTOS option point to its location.
As @Reeza pointed out, macro's do not technically return a value like a function does. But it is conceptually close enough. Just look at the %SYSRC autocall macro for a nice example.
Hope this helps,
- Jan.
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.