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
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.
Ready to level-up your skills? Choose your own adventure.