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.
Save $250 on SAS Innovate and get a free advance copy of the new SAS For Dummies book! Use the code "SASforDummies" to register. Don't miss out, May 6-9, in Orlando, Florida.
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.
Ready to level-up your skills? Choose your own adventure.