Help using Base SAS procedures

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

Accepted Solution Solved
Reply
Highlighted
Super Contributor
Posts: 297
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
‎06-19-2017 10:30 PM
PROC Star
Posts: 7,417

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
PROC Star
Posts: 634

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
‎06-19-2017 10:30 PM
PROC Star
Posts: 7,417

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
  • 139 views
  • 1 like
  • 3 in conversation