Hi All,
I would like to use a macro variable to determine the number of columns in a data set. I've tried looking up the syntax but can't seem to find it. Any help would be appreciated.
There is no need for a macro. The following Proc SQL code will display the number in results:
proc sql;
select nvar
from dictionary.tables
where libname='SASHELP' and memname='CLASS';
quit;
If you want the result in a data set then preface the select NVAR with : create table yourtablename as
Or in a data step:
data want;
set sashelp.vtable (where=(libname='SASHELP' and memname='CLASS'));
keep nvar;
run;
The SQL version may run faster depending on how many libraries, number of data sets and locations of the libraries.
%let dsid=%sysfunc(open(sashelp.class)); %let nvars=%sysfunc(attrn(&dsid,nvars)); %let dsid=%sysfunc(close(&dsid)); %put &nvars;
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.