fixing a macro autopopulated set statement when datasets are missing

jteague — Tue, 15 Apr 2025 14:08:33 GMT

%macro populate_set_statement(current_date);

    %let current_date_num = %sysfunc(inputn(&current_date., yymmdd10.));
    %let current_date_minus_363 = %eval(&current_date_num - 363);
    %let current_date_minus_347 = %eval(&current_date_num - 347);

    data all;
        set
            %do i = %sysfunc(inputn(20250317, yymmdd10.)) %to &current_date_num;
                %if %sysfunc(exist(both_%sysfunc(putn(&i., mmddyy6.)))) %then both_%sysfunc(putn(&i., mmddyy6.));
            %end;
            %do j = &current_date_minus_363 %to &current_date_minus_347;
                %if %sysfunc(exist(all22_%sysfunc(putn(&j., mmddyy6.)))) %then all22_%sysfunc(putn(&j., mmddyy6.));
            %end;
        ;
    run;

%mend populate_set_statement;
%populate_set_statement(%sysfunc(today(), yymmdd10.));

Using SAS 9.4 (TS1M7).

I have this part of a program that auto populates a dataset "all" based on dates. There is a chance in the future that some of the datasets used to create the datasets in the set statement above will be empty causing All not to be created. Can someone give me a work around so that if a dataset is empty it is removed from the set statement? Thanks.

Re: fixing a macro autopopulated set statement when datasets are missing

Quentin — Tue, 15 Apr 2025 14:15:16 GMT

When you say some of the datasets are empty, you mean some of them have 0 records? That should not stop your dataset work.ALL from being created.

Re: fixing a macro autopopulated set statement when datasets are missing

jteague — Tue, 15 Apr 2025 14:41:58 GMT

Thank you. You are right and I was confused. When testing the code the issue was datasets that do not exist rather than ones with zero observations. But that shouldn't be an issue the way the code above this is written. So thanks again.

topic fixing a macro autopopulated set statement when datasets are missing in SAS Programming

fixing a macro autopopulated set statement when datasets are missing

Re: fixing a macro autopopulated set statement when datasets are missing

Re: fixing a macro autopopulated set statement when datasets are missing