SAS包含动态路径 [英] SAS include dynamic path

问题描述

我尝试构建小宏，该宏应在循环中运行其他SAS程序. 表Control_files具有两个字段，其中是正确的sas程序路径的其他部分.

I have tryed build little macro which in loop it should runother SAS programs. Table Control_files has two field, where are other part of path to proper sas program.

%LET PATH_TO = '%include "T:\XXX\YYY\ZZZ\';
%LET PATH_end = '.sas"';
data _null_;
set CONTROL_FILES;
call execute ('%runlimitsquery('||&PATH_TO||SCHEMA_NAME||'\'||PROCES_NAME||&PATH_end||');');
run;

我尝试使用runlimitsquery，因为我发现了那个提示. 当我运行代码时，日志返回:

I tryed used runlimitsquery because I found somewhere that tip.. When I run my code, log returns:

NOTE: CALL EXECUTE generated line.
NOTE: Line generated by the CALL EXECUTE routine.
1         + %runlimitsquery(%include "T:\XXX\YYY\ZZZ\XXX_TECHNICAL_AAAAA\001_AAAAA.sas");
            _
            180
WARNING: Apparent invocation of macro RUNLIMITSQUERY not resolved.

ERROR 180-322: Statement is not valid or it is used out of proper order

有人可以帮助我吗?

推荐答案

好，我有问题的答案... 下面的代码有效:

Ok, I have answer for my problem... Below code works:

%LET PATH_TO = '%include "T:\XXX\YYY\ZZZ\';
%LET PATH_end = '.sas"';
data _null_;
set CONTROL_FILES;
call execute ('('||&PATH_TO.||SCHEMA_NAME||'\'||PROCES_NAME||&PATH_end.||';');
run;

这篇关于SAS包含动态路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！