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));
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
Try this
%let nvar=%sysfunc(attrn(%sysfunc(open(sashelp.cars)),nvar));
%put &nvar ;
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
Available on demand!
Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.
Learn the difference between classical and Bayesian statistical approaches and see a few PROC examples to perform Bayesian analysis in this video.
Find more tutorials on the SAS Users YouTube channel.