topic Re: Transfer data from single table to multiple child table with macro in SAS Programming

Transfer data from single table to multiple child table with macro

abraham1 — Mon, 16 Nov 2020 10:01:05 GMT

Hi All,

I have one master table (Employee) from which I need to transfer data to multiple child table with different variable name and keep same format. How can it be done with macro program.

data employee;
input eid ename $ job $ sal dept deptname $ bonus $;
cards;
10001 AB SALES 1000 10 ACCOUNT 100
10001 AC SALES 2000 20 SALES 1001
10002 AD SALES 3000 10 SALES 1002
10003 AE SALES 4000 20 SALES 1003
10003 AF SALES 5000 30 SALES 1004
10001 AG SALES 6000 10 ACCOUNT 1500
10058 AH SALES 14000 40 SALES 1006
;
RUN;


data job;
input eid job $;
cards;
run;

data dept;
input eid dept deptname$;
cards;
run;

data bonus;
input eid bonus $;
cards;
run;

Re: Transfer data from single table to multiple child table with macro

Kurt_Bremser — Mon, 16 Nov 2020 10:06:21 GMT

No macro needed:

data
  job (keep=eid job)
  dept (keep=eid dept deptname)
  bonus (keep=eid bonus)
;
set employee;
run;

Re: Transfer data from single table to multiple child table with macro

PeterClemmensen — Mon, 16 Nov 2020 10:16:37 GMT

You don't need a macro to do this. Do you want all observations from the original data in each new data set?