topic Re: Count composite character strings, in a Macro List, that contain special character i.e. "_ in SAS Programming

Count composite character strings, in a Macro List, that contain special character i.e. "_", "."

Zeus_Olympous — Mon, 12 Jun 2017 13:09:08 GMT

Dear all, I have created a macro list (using Proc Sql). The members of this macro list are "composite" character string i.e. WORK.DSN1 WORK.DSN2 WORK.DSN3 WORK.DSN4 etc. I tried to count them by using COUNTW but the result doubles the actual number ... for each "composite" string WORK.DSN1 counts both WORK and DSN1 as separate words...I would like to my composite strings to be counted once and not be separated by "." . Any hint or advice would be lore than welcome. Thank you in advance.

Re: Count composite character strings, in a Macro List, that contain special character i.e. "_

Jagadishkatam — Mon, 12 Jun 2017 13:14:56 GMT

Not sure if you tried to include the delimiter in countw function as below


data have;
length string $100.;
string='WORK.DSN1 WORK.DSN2 WORK.DSN3 WORK.DSN4';
c=countw(string,' ');
run;

Re: Count composite character strings, in a Macro List, that contain special character i.e. "_

Tom — Mon, 12 Jun 2017 13:16:48 GMT

You need to give the COUNTW() function the optional third argument that specifies what charater(s) to consider the delimiter between words.

%put %sysfunc(countw(a.b c.d,%str( )));

Re: Count composite character strings, in a Macro List, that contain special character i.e. "_

PeterClemmensen — Mon, 12 Jun 2017 13:17:13 GMT

use COUNTW function with ' ' as second parameter

Re: Count composite character strings, in a Macro List, that contain special character i.e. "_

RW9 — Mon, 12 Jun 2017 13:53:41 GMT

In the same step as you create the macro list just add:

select count(*) from SASHELP.VTABLES
where LIBNAME="WORK" and memname like "DSN%";

In fact, you could use the data returned from the metadata to directly work with, taking out a layer of abstraction:

E.g.:

data _null_;
  set sashelp.vtable (where=(libname="WORK" and substr(memname,1,3)="DSN"));
  call execute('%do_somthing(indata='||strip(name)||';');
run;

This would generate a % call for each dataset fulfilling the where clause, in your example, for example:

%do_something(indata=dsn1);

%do_something(indata=dsn2);

%do_something(indata=dsn3);

Re: Count composite character strings, in a Macro List, that contain special character i.e. "_

Zeus_Olympous — Tue, 13 Jun 2017 08:14:22 GMT

Many thank to all of you for your prompt and helpful response. Unfortunately I cannot give "the solution" remark to all of the answers