topic Re: How to count macro variables in log in SAS Programming

How to count macro variables in log

Kalai2008 — Thu, 02 Jan 2020 19:06:14 GMT

Hello, Need a quick help!!

I'm defining a user-defined variable number of macro variables that I want to use later in my program.

%let Alist1 = '00123','00124','00175'....; (400 variables)

%let Alist2 = '00163','00164','00165'....;(500 variables)

%let Alist3 = '00153','00154','00155'....;(300 variables)

I wanted to check the count of ALIST1 in my log using %PUT statement, not the actual values. Since I am not sure how many were there in some of the lists.

I tried like this,

%PUT = &Alist1 ;

%PUT = count( &Alist1) ;

I need something like this

Alist = 400??

Thanks for checking!

Re: How to count macro variables in log

novinosrin — Thu, 02 Jan 2020 18:25:48 GMT

%put %sysfunc(countw(%BQUOTE(&Alist1),%str(,)));

Re: How to count macro variables in log

ed_sas_member — Thu, 02 Jan 2020 18:20:17 GMT

Hi @Kalai2008

You can use the count() function and use it with the %sysfunc() function as you use macro language;

%put %sysfunc(countw("&Alist1"));

Re: How to count macro variables in log

Kalai2008 — Thu, 02 Jan 2020 18:45:36 GMT

Thanks,

Log Error:

NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 %put %sysfunc (countw(&AList1));
ERROR: The function COUNTW referenced by the %SYSFUNC or %QSYSFUNC macro function has too many arguments.
.

Re: How to count macro variables in log

Kalai2008 — Thu, 02 Jan 2020 18:48:03 GMT

Thank you, but there is no values in log.

Log:
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
24 %put %sysfunc(countw(%BQUOTE(AList1),%str(,)));
1
25

Re: How to count macro variables in log

ed_sas_member — Thu, 02 Jan 2020 18:50:47 GMT

Hi,
Have you tried this with the double quotes:
%put %sysfunc(countw("&Alist1"));

Re: How to count macro variables in log

Kalai2008 — Thu, 02 Jan 2020 18:55:29 GMT

Oh thanks, since I saw warning message, i didn't notice the output.
NOTE: Writing TAGSETS.SASREPORT13(EGSR) Body file: EGSR
22
23 GOPTIONS ACCESSIBLE;
WARNING: The quoted string currently being processed has become more than 262 characters long. You might have unbalanced quotation
marks.
24 %put %sysfunc (countw("&AList1"));
235
25

Re: How to count macro variables in log

ed_sas_member — Thu, 02 Jan 2020 19:00:30 GMT

Just a question: is it normal to have a missing quotation mark before 00124 in you macro variable definition ?
%let Alist1 = '00123',00124','00175'....; (400 variables)

Re: How to count macro variables in log

Kalai2008 — Thu, 02 Jan 2020 19:02:59 GMT

I don't have any missing quotation mark in any of the listed variable, I separated each with commas, not sure why i got that warning message,