topic Re: merge data Table in SAS Programming

merge data Table

invitro — Sun, 04 Feb 2018 04:05:30 GMT

How to merge non-empty tables only? skip empty tables.

Re: merge data Table

PGStats — Sun, 04 Feb 2018 04:41:41 GMT

In what way are empty datasets causing a problem during your merge operation. In the following example, merging with an empty dataset isn't a problem, except for the presence of an empty column

data a;
id=1; x=1; output;
id=1; x=2; output;
run;

/* Empty dataset */
data b;
length id x y 8;
stop;
run;

data c;
id=1; z=3; output;
id=1; z=4; output;
run;

data d;
merge a b c;
by id;
run;

proc print data=d noobs; run;

                                 id    x    y    z

                                  1    1    .    3
                                  1    2    .    4

Re: merge data Table

Satish_Parida — Sun, 04 Feb 2018 14:51:31 GMT

I have created a simple macro. You can use it.

%macro tablesize(tablename=);
	proc sql noprint;
	select count(*) into :cnt from &tablename.;
	quit;
	%if &cnt. ne 0 %then %do;
		%let &tablename.=&tablename.;
	%end;
	%else %do;
		%let &tablename.=;
	%end;
%mend tablesize;

%tablesize(tablename=A);
%tablesize(tablename=B);
%tablesize(tablename=C);

data d;
merge &A. &B. &C.;
by common_var;
run;

/*Which of the table is empty its corresponding macro will be initialized to null 
so they wont be merged in the data step as the macro resoves to null
Remember to call macronames insted of tablenames.
Remember Not to have any macro variable same name as tablenames*/

Please let us know if it worked for you.

Re: merge data Table

invitro — Sun, 04 Feb 2018 20:21:03 GMT

Thank you, PG. There is no issue to merge empty tables. I just don't want to keep columns from empty tables.

Re: merge data Table

invitro — Sun, 04 Feb 2018 20:21:57 GMT

Thank you, Satish_Parida. It should work.