topic Re: Location of code or definition for %fcf_get_runasofdate macro ? in Fraud, AML and Security Intelligence

Location of code or definition for %fcf_get_runasofdate macro ?

adleach2 — Thu, 06 Feb 2020 18:15:20 GMT

Hi,

I am new to SAS AML. I am trying to understand what the %fcf_get_runasofdate macro is doing so I would like to see the source cod or definition.

However, I can't find any fcf_get_runasofdate.sas in any of the sas autocall paths.

Can any one tell me where this macro is defined?

Thanks,

Alan

Re: Location of code or definition for %fcf_get_runasofdate macro ?

adleach2 — Thu, 06 Feb 2020 20:01:08 GMT

So I found the macro code. The macros where compiled and stored in a SAS CATALOG called sasmacr located in the

/opt/sas/sashome/SASFoundation/9.4/cmacros/antimnycmn directory at our install.

Unfortunately, when the macros where compiled and put the catalog they were compiled with the SECURE option which means I cannot retrieve the source code.

Does anyone know how to get the code?

Re: Location of code or definition for %fcf_get_runasofdate macro ?

SASKiwi — Thu, 06 Feb 2020 21:03:27 GMT

What happens if you run the macro with the SAS option MPRINT? It should print the source in the SAS log unless the compiled macro does not contain source.

Re: Location of code or definition for %fcf_get_runasofdate macro ?

ballardw — Thu, 06 Feb 2020 22:35:48 GMT

Who wrote the code or originally compiled the code with the option?

I would hope someone in the organization wrote or has a copy of the code. Find that person and ask for the source.

You may need to add MLOGIC to the suggestion that @SASKiwi made to find macro branching as one pass may not execute all of the paths in macro.

Re: Location of code or definition for %fcf_get_runasofdate macro ?

SASKiwi — Thu, 06 Feb 2020 23:58:59 GMT

@ballardw - I very much suspect that this is a SAS-supplied macro so it most likely compiled and secured for reasons of security, given the nature of the product. The OP will most likely need to progress this with SAS Tech Support.

Re: Location of code or definition for %fcf_get_runasofdate macro ?

adleach2 — Fri, 07 Feb 2020 13:15:09 GMT

@SASKiwi @ballardw Thanks for the replies. When I add those options and run the macro I get nothing back in the log

options mprint symbolgen source mlogic ;
%fcf_get_runasofdate ;

NOTE: PROCEDURE SQL used (Total process time):
real time 0.01 seconds
cpu time 0.02 seconds

The macros definitely are compiled. See below. Hopefully someone as SAS Saved the code before they compiled it.

proc catalog ;
27 contents cat= ECMCMAC.sasmacr out=temp;
28 run;

NOTE: The data set WORK.TEMP has 1 observations and 9 variables.
29
30
31 filename outfl "/home/e931413/ECMCMAC";
NOTE: The macro %FCF_GET_RUNASOFDATE was compiled with the /SECURE option. No output will be produced for this %COPY statement.
ERROR: The /SOURCE option was not specified when the macro FCF_GET_RUNASOFDATE was compiled.
ERROR: An error occurred during the execution of the %COPY statement.
32
33 %copy FCF_GET_RUNASOFDATE / OUTFILE=outfl source;

Re: Location of code or definition for %fcf_get_runasofdate macro ?

SASKiwi — Fri, 07 Feb 2020 21:21:20 GMT

@adleach2 - That pretty much confirms my suspicions of this being SAS-supplied. Tracking this to Tech Support seems like the only way to make progress.