SAS Advanced programming 정리- SAS programming (24)

Creating Functions with PROC FCMP

함수 지정

proc fcmp outlib=orion.functions.dev;
function ReverseName(name $) $40;
return(catx('',scan(name,2,','),scan(name,1,',')));
endsub;
quit;

data step에서 활용하려면 options cmplib 실행

options cmplib=orion.functions;

data step에서 function 적용

data work.emplist;
set orion.employeeaddresses;
NewName=ReverseName(EmployeeName);
run;