topic Re: how to count variables with similar name patten in SAS Programming

how to count variables with similar name patten

stataq — Fri, 26 Apr 2024 13:29:27 GMT

Hello,

If I have a dataset which have a large amount variables with name like colXX. Is it a way to found out how many variables with this type of name and assign it to a macro variable COLNUM?

Thanks.

Re: how to count variables with similar name patten

Tom — Fri, 26 Apr 2024 13:50:39 GMT

If they are all of the same type (numeric or character does not matter) then a simple data step should do the job.

data _null_;
  if 0 then set have;
  array __xx col: ;
  call symputx('colnum',dim(__xx));
  stop;
run;

Otherwise you could try using the SAS dictionary metadata view/table to check.

proc sql noprint;
select count(*) format=32. into :colnum trimmed
from dictionary.columns
where libname='WORK'
  and memname='HAVE'
  and upcase(name) eqt 'COL'
;
quit;

Re: how to count variables with similar name patten

stataq — Fri, 26 Apr 2024 13:59:47 GMT

May I ask why we need to use 'if 0 then' instead of directly 'set have'?

Re: how to count variables with similar name patten

Tom — Fri, 26 Apr 2024 14:06:43 GMT

Since 0 is treated as FALSE by SAS the SET statement will never actually execute, but it will be checked by the data step compiler to find the list of variables.

Two reasons.

1) If the HAVE dataset has zero observations the data step will stop at the SET statement and never execute the CALL SYMPUTX()

2) If the HAVE dataset is large it might take more resources to actually read even just the first observation from it.