Re: Iterative Macro Variable code

Tom — Wed, 19 Mar 2014 16:56:04 GMT

To get the number of observations in multiple tables just use PROC CONTENTS or DICTIONARY.TABLES.

proc sql noprint ;

create table counts as

select memname,nlobs

from dictionary.tables

where libname = 'NACO'

and upcase(memname) like 'NACO_%'

order by 1

;

quit;

Re: Iterative Macro Variable code

Aljay — Mon, 30 Jun 2014 13:51:44 GMT

I am trying to get record count form updated datasets using naming convention financial_account_YYYYMM that range from 201212 back to 200706. The datasets are stored in the following path: '/sas/data/dds_test/

The below code is not working for me and I am new to do loops> any help would be appreciated...

LIBNAME DDSTEST '/sas/data/dds_test/

proc sql;
create table rl_668_SUM
(
MNTH num,
CNT num
);
quit;

data _null_;
do i=200706 to 201212;
call execute('proc sql;
insert into rl_668_SUM

set MNTH='||strip(put(i,best.))||',

CNT = (select count(1) from DDSTEST.Financial_account_'||strip(put(I,best.)||');

                                                              quit;');
    end;
run;

topic Re: Iterative Macro Variable code in SAS Programming

Re: Iterative Macro Variable code

Re: Iterative Macro Variable code