Append the data based on conditional statements

[NagendraBS]

Hi All,

I have 3 datasets seperately

Data A;
Input Name $
Cards;
ABC
Bcd
Cde
;
Run;

Data B;
Input name $;
Cards;
Wer
Try
Uni
; run;

Data C;
Input name $;
Cards;
Gfh
Hij
Klm
; run;

So I need the output based on condition with macro variable value.
Let say if city = blr then dataset A should append and if city = hyd then dataset B should append to base dataset and if city is blank then dataset C should append to base dataset.

Here is the code I have tried on.

%let city = blr;

Data new;
If city = "blr" then set A end=done;
Else if city = "hyd" the set B end=done;
Else set C end=done;
Run;

Here I see all the records are populating.

Please provide Ur inputs to recreate the code.

Thanks in advance.

[RW9]

Please post an actual example.  Why would you have a macro variable which indirectly points the data to append?  I mean you could do:

%macro appnd ();
  data want;
    set a
  %if "&city."="blr" %then %do;
    b;
  %end;
  %else %do;
    c;
  %end;
  run;
%mend appnd;

%appnd;

But you could vastly simplfy it just by having the macro variable point to the actual table you want to append:

%let city=b;

data want;
  set a &city.;
run;

I suppose the key question here is why your doing this at all.  The data should have all the information needed, i.e. a variable in there for filtering.  So you would simply do:

data want;
  set a b c;
  where city="blr";
run;

I think your just complicating the whole thing.

[NagendraBS]

Hi RW9,

I'll make it simple example based on macro value I need to append the data let say
%let Var = A;

Dataset A should get appended and if the macro variable is blank then Dataset C should append
It is like if u have variable value append that respective dataset and if variable value is blank the by default need to append the dataset C.

[RW9]

Maybe:

data want;
  set %sysfunc(coalescec(&var.,C));
run;

This will set the first if non-missing, otherwise c.  I still don't see any value in this approach however.  macro is not for data processing, put data in the dataset, then use where filtering its quicker, uses less resources, and is simpler coding.

[NagendraBS]

Thanks for your inputs got to solve it

[RW9]

Cool, please remember to mark appropriate posts as the answer when you have what you need.