topic Re: How to use %synfunc option to count all of the variables? in SAS Procedures

How to use %synfunc option to count all of the variables?

ybz12003 — Mon, 19 Jun 2017 18:04:28 GMT

Hello:

Could anyone let me know if the %synfunc option to count the total of all the variables? I know the ATTRC and ATTRN are list below. Is there another option contain both of them? Thanks.

ATTRC - Returns the value of character attributes of a data set.

ATTRN - Returns the value of numeric attributes of a data set.

And I got the codes list below, I assume it only count thetotal numberic variables below. Please correct me if I am wrong.

%let cnt=%sysfunc(attrn(&dsid,nvars));

Re: How to use %synfunc option to count all of the variables?

PeterClemmensen — Mon, 19 Jun 2017 18:34:41 GMT

Try this

%let nvar=%sysfunc(attrn(%sysfunc(open(sashelp.cars)),nvar));
%put &nvar ;

Re: How to use %synfunc option to count all of the variables?

art297 — Mon, 19 Jun 2017 18:39:34 GMT

The nvar attritute with the attrn functions provides the number of all variable, regardless of whether they are character or numeric. Thee attrc function provides a different set of attributes (see: http://support.sas.com/documentation/cdl/en/lrdict/64316/HTML/default/viewer.htm#a000147794.htm)

Art, CEO, AnalystFinder.com