topic Use macro to append tables in SAS Programming

Use macro to append tables

DartRodrigo — Wed, 19 Aug 2015 20:01:18 GMT

Hi guys,

I'm creating a query to append Datasets using a macro, because, sometimes i need to append data only from 3 months ago.

This code below works well until i create a data set inside of the macro to append the tables:

%GLOBAL YEARDT

ANO

MES

INTERVALO

ANOI

MESI

BASES;

%LET YEARDT = %SYSFUNC(DATE(),YYMMP10.);

%LET ANO = %SUBSTR(&YEARDT.,1,4);

%LET MES = %SUBSTR(&YEARDT.,6,2);

%PUT &ANO&MES.;

%MACRO APPEND(NUM);

%DO I = 1 %TO &NUM;

%LET INTERVALO = %SYSFUNC(PUTN(%SYSFUNC(INTNX(MONTH,%SYSFUNC(DATE()),-&&I.)),YYMMP10.));

%LET ANOI = %SUBSTR(&INTERVALO.,1,4);

%LET MESI = %SUBSTR(&INTERVALO.,6,2);

%LET BASES = BASE_WO.BASE_WO_&ANOI&MESI.;

%PUT &BASES.;

%END;

%MEND;

%APPEND(2);

In the %APPEND(2); i'd like to append how much months i need(Type a number).

My tables names has dates at the end of their names in this format = 201501;

How can i do that to append tables ?

Thank you before anything,

Rodrigo Dartibali Elias

Re: Use macro to append tables

DartRodrigo — Wed, 19 Aug 2015 20:12:28 GMT

One more thing. When i use the macro Bases in %put statement inside do loop, it prints all tables names into the log(Works),

When i put the same macro in the set statement it doesn't work.

Re: Use macro to append tables

Reeza — Wed, 19 Aug 2015 20:22:21 GMT

I think querying the Dictionary Tables is an easier method.

Take a look at the methods in this thread and see if you can expand them to your problem.

Re: Use macro to append tables

ballardw — Wed, 19 Aug 2015 20:24:46 GMT

Show the code you used that didn't work.

A likely cause is either a missing semi colon or the location of the loop:

%macro dummyset( loops=5);

data want;

set

%do I = 1 to &loops;

libref.myset&i /* NOTE: No ; here*/

%end; /* the LOOP but NOT the set statement*/

; /* This ; ends the SET statement*/

run;

%mend;

So your code should make sure you are NOT generating any extra ;

Possibly:

data want;

set

%yourmacroname ()

;

run;

Use OPTIONS MPRINT to see the resolved code and look for an extra ;

Re: Use macro to append tables

DartRodrigo — Wed, 19 Aug 2015 20:42:40 GMT

The code i used works but only prints the last table printed in the log.

Re: Use macro to append tables

DartRodrigo — Wed, 19 Aug 2015 20:54:34 GMT

Thanks Ballard it works