How to get the number of variables in one list?

[MikeTurner]

If I create one variable list like this,

%let varlist=c1-c9;

How to get the number of variables in &varlist?

If I %let  n=%sysfunc(countw(&varlist)), &n will be 2.

Any way to get the exact number of variables in &varlist?

Thanks!

[Ksharp]

How about :

%let varlist=c1-c9;

%let start=%scan(&varlist,1, ,kd);

%let end=%scan(&varlist,-1, ,kd);

%let n=%eval(&end-&start+1) ;

%put &n ;

Ksharp

[Ksharp · Accepted solution]

Second way :

%let varlist=c1-c9;

data _null_;
array a{*} &varlist;
call symputx('n',dim(a));
stop;
run;
%put &n ;

Ksharp

[MikeTurner]

Thank you, Ksharp!

[MikeTurner]

Another question.

%let varlist=c1-c4 d1 d9;

How can I  get the variable name list like c1 c2 c3 c4 d1 d9?

Thanks!

[data_null__]

proc transpose data=have(obs=0) out=varlist;

   var c1 c2 ..... ;  * any list of variables that exist in have;

   run;

You get a SAS data set and you can use it to answer all kinds of questions including how many.

[Ksharp]

Acutally NULL has already given you a good solution.

%let varlist=c1-c4 d1 d9;

data _null_;
length list $ 200;
array a{*} &varlist;
do i=1 to dim(a);
 list=catx(' ',list,vname(a{i}));
end;
call symputx('list',list);
stop;
run;
%put &list ;

Ksharp