topic Re: Count number of variables in dataset - for DDE in SAS Procedures

Count number of variables in dataset - for DDE

vomer — Mon, 18 Jun 2012 18:14:35 GMT

Hi guys,

I have used the following macro to count the number of rows and use it in my dde:

data _NULL_;

if 0 then set TEST nobs=nr;

index=nr+1;

CALL SYMPUT('row2', PUT(index, 5.));

stop;

run;

usage in DDE: FILENAME dataZ13 DDE "excel|[&template.]&section2.!r2c30:r&row2.c36" notab;

I am wondering how I can do the same for the number of columns? I have a dataset where we add a new variable (column) every month. I was wondering if there was some similar macro that can count the number of columns so I do not have to keep changing the column limits in DDE.

Thanks.

Re: Count number of variables in dataset - for DDE

MikeZdeb — Mon, 18 Jun 2012 19:18:15 GMT

hi ... one idea (use a separator that's not a character in your data ... I used a TAB) ...

question ... what's that +1 for (index=nr+1) ... it's added in both examples below

data _null_;

set sashelp.class nobs=obs;

call symputx('obs',obs+1);

call symputx('vars',countc(catx('09'x,of _all_),'09'x)+1);

stop;

run;

or dictionary tables (separated by removes leading spaces in macro vars)...

proc sql noprint;

select nobs+1, nvar into :obs separated by ' ', :vars separated by ' '

from dictionary.tables

where libname eq 'SASHELP' and memname eq 'CLASS';

quit;

Re: Count number of variables in dataset - for DDE

Ksharp — Tue, 19 Jun 2012 02:54:21 GMT

Or compressing code.

%let dsid=%sysfunc(open(sashelp.class));

%let nvar=%sysfunc(attrn(&dsid,nvar));

%let dsid=%sysfunc(close(&dsid));

%put &nvar ;

Ksharp