Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Highlighted
Regular Contributor
Posts: 207
Accepted Solution

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

[ Edited ]

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));

 

 


Accepted Solutions
Solution
Monday
Esteemed Advisor
Posts: 7,052

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

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

 

View solution in original post


All Replies
Super Contributor
Posts: 472

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

Try this

 

%let nvar=%sysfunc(attrn(%sysfunc(open(sashelp.cars)),nvar));
%put &nvar ;
Solution
Monday
Esteemed Advisor
Posts: 7,052

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

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

 

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 79 views
  • 1 like
  • 3 in conversation