HELLO! I have a technical problem that needs to be solved urgently

[_Sas_Beginner_]

各位专家您好，我有一个技术问题亟待解决，如果可以通过 fcmp 函数中的“run_macro”语句调用宏语句，并且在数据程序步骤中调用 PROC 过程步骤，但是 fcmp 函数在 proc ds2 中无法使用，则会提示无法识别“run_macro”的错误消息， 如何解决这个问题？

/*Runs successfully*/
%macro distinct_values;

%let input_table = %sysfunc(dequote(&input_table));

%let column = %sysfunc(dequote(&column));

%let output_table = %sysfunc(dequote(&output_table));

proc sql;

create table &output_table as

select distinct &column

from &input_table;

%mend;

proc fcmp outlib=work.funcs.sql;

function get_distinct_values(input_table $, column $, output_table $);

rc = run_macro('distinct_values', input_table, column, output_table);

return (rc);

endsub;
run;
data _null_;

rc = get_distinct_values('sashelp.shoes', 'region', 'work.regions');

id=open('work.regions');

if id then nobs=attrn(id,'NOBS');

put nobs;

run;

/*If you use proc DS2 instead of the data step, the run fails*/
PROC DS2 ;
PACKAGE FUNCTION_PACK / OVERWRITE=YES LANGUAGE='FCMP' TABLE='WORK.FUNCS';
ENDPACKAGE;
RUN;
QUIT;
PROC DS2;
DCL PACKAGE FUNCTION_PACK P();
MENTHOD RUN();
rc = get_distinct_values('sashelp.shoes', 'region', 'work.regions');

id=open('work.regions');

if id then nobs=attrn(id,'NOBS');

put nobs;

run;
END;
ENDDATA;
RUN;
QUIT;

[_Sas_Beginner_]

Hello experts, I have a technical problem that needs to be solved urgently, if you can call the macro statement through the "run_macro" statement in the fcmp function, and call the PROC procedure step in the data program step, but the fcmp function cannot be used in proc ds2, it will prompt the error message that "run_macro" is not recognized, how to solve this problem?

[yabwon · Accepted solution]

Some interesting facts described by @RichardDeVen can be read in this thread:

https://communities.sas.com/t5/SAS-Programming/Output-to-a-Macro-variable-within-DS2/td-p/692726

Bart

[_Sas_Beginner_]

thanks！but I tried the code you sent me to my website with the error message "Cannot find function" run_macro"";

[_Sas_Beginner_]

I mean, run the macro with the fcmp function and then call the fcmp function with proc ds2, but always prompt an error message！

[_Sas_Beginner_]

sorry,I didn't pay attention to the content of the answer，thank you very much！