topic Re: HELLO! I have a technical problem that needs to be solved urgently in SAS Programming

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

_Sas_Beginner_ — Thu, 20 Apr 2023 10:40:56 GMT

各位专家您好，我有一个技术问题亟待解决，如果可以通过 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;

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

_Sas_Beginner_ — Thu, 20 Apr 2023 10:46:54 GMT

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?

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

yabwon — Thu, 20 Apr 2023 12:17:10 GMT

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

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

_Sas_Beginner_ — Thu, 20 Apr 2023 15:45:39 GMT

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

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

_Sas_Beginner_ — Thu, 20 Apr 2023 15:48:18 GMT

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

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

_Sas_Beginner_ — Thu, 20 Apr 2023 20:15:43 GMT

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