topic Re: Append the data based on conditional statements in SAS Programming

Append the data based on conditional statements

NagendraBS — Tue, 18 Dec 2018 13:03:38 GMT

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.

Re: Append the data based on conditional statements

RW9 — Tue, 18 Dec 2018 13:14:35 GMT

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.

Re: Append the data based on conditional statements

NagendraBS — Tue, 18 Dec 2018 13:25:29 GMT

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.

Re: Append the data based on conditional statements

RW9 — Tue, 18 Dec 2018 13:35:31 GMT

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.

Re: Append the data based on conditional statements

NagendraBS — Tue, 18 Dec 2018 13:41:52 GMT

Thanks for your inputs got to solve it

Re: Append the data based on conditional statements

RW9 — Tue, 18 Dec 2018 14:07:26 GMT

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