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;
No macro needed:
data
job (keep=eid job)
dept (keep=eid dept deptname)
bonus (keep=eid bonus)
;
set employee;
run;
No macro needed:
data
job (keep=eid job)
dept (keep=eid dept deptname)
bonus (keep=eid bonus)
;
set employee;
run;
You don't need a macro to do this. Do you want all observations from the original data in each new data set?
Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.