Hi,   I try to check if a table exist and I can't manage this, can you help? I call a macro A:   %A ( ext_output_table = GG ); In this macro, there is a loop. For each item I create a temporary table:     &ext_output_table._tmp Then (still inside the loop) I call another macro     %union( input_table = &ext_output_table._tmp., output_table = &ext_output_table.);   The union macro is defined like this: %macro union( input_table, output_table); %if NOT(%sysfunc(exist(WORK.&output_table.))) %then %do; data &output_table.; set &input_table.; run; %end; %else %do; PROC APPEND BASE= &output_table. DATA= &input_table. force; %end; PROC DELETE DATA= &input_table.; %mend union; The purpose of this is to create the table as equal to the temporary table if it is not existing otherwise just append the current version of the table by adding the rows of the temporary table.   In the log I receive the opposite answer than the one I should,   NOT(%sysfunc(exist(WORK.&output_table.))) IS FALSE   For the first item of my loop, it should be true. Do you know what could go wrong here?   Thanks   ... View more

Hi,   I have a macrovariable: %LET A = 01,02,03; I have a macro: %macro B(A); I want to call my macro %B(&A.) I undestood that because of the commas, I should write %B(%superq(&A.)) It is working when I call the macro. But when the macro begins to be written I got this error:   ERROR: Invalid symbolic variable name 01,02,03. Can you tell me what I should do here? Thanks. ... View more

Hi,   filename code temp; data C; set A nobs=nobs ; file code ; do part=0 to int(nobs/1000); put '%macro1(inputtable=A, outputtable = B_P, size=1000,part=' part')' ; end; stop; run; %include code / source2 ;   I have a table A which create several B tables named B_P0, B_P2,...,B_P(n-1) I would like to create in the same datastep the table C as an union of all B_P tables, and then delete B_P tables.   How can I do this?   Thanks   ... View more