topic Re: %sysfunc in SAS Programming

%sysfunc

vandhan — Tue, 24 Nov 2015 11:10:28 GMT

Can I use all datastep function in macro using %sysfunc??

OR do we have limited function where I can use with %sysfunc??

Please help

Re: %sysfunc

LinusH — Tue, 24 Nov 2015 11:31:48 GMT

RTM

http://support.sas.com/documentation/cdl/en/mcrolref/67912/HTML/default/p1o13d7wb2zfcnn19s5ssl2zdxvi.htm

Re: %sysfunc

FreelanceReinh — Tue, 24 Nov 2015 11:33:47 GMT

There are exceptions. Please see the list of "SAS Functions Not Available with %SYSFUNC and %QSYSFUNC" in the documentation.

Re: %sysfunc

RW9 — Tue, 24 Nov 2015 11:45:45 GMT

A more important question than "do we have limited function where I can use with %sysfunc?", is when is it a good idea to go down that route. Sysfunc is a great command, and useful in many situations, but if you find your using it a lot, then you may want to look at your code and see if it can be written in such a way as to be more readble. To often things like:

%sysfunc(intnx(%sysfunc(input(...),%sysfunc(...

is used just to squeeze normal Base SAS code into macro form. I rarely come across situations where base SAS cannot do something far simpler, and easier to read.

Re: %sysfunc

dcruik — Tue, 24 Nov 2015 14:09:21 GMT

There are limited SAS functions that can be used with %sysfunc, and there are also macro specific functions you can use without the %sysfunc. I would suggest looking at the documentation that has been provided to determine which function you want and if it's already a macro function, or if you can use it inside a %sysfunc.

Re: %sysfunc

kannand — Tue, 24 Nov 2015 14:25:37 GMT

Would it be possible to elaborate on what you are trying to accomplish with the function ?