🔒 This topic is solved and locked.
Need further help from the community? Please
sign in and ask a new question.
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
Posted 05-01-2021 02:13 PM
(456 views)
I want to distribute equal amount of bonus from bonus table to all the employee of emp table.
data bonus;
input deptid $ bonus;
datalines;
HR 4000
Fin 3000
;
run;
data emp;
input deptid $ empid;
datalines;
HR 1
HR 2
HR 3
HR 4
Fin 1
Fin 2
Fin 3
;
run;
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you sort both of your data sets by DEPTID, then this works:
proc freq data=emp;
table deptid/noprint out=_counts_;
run;
data want;
merge emp bonus _counts_(drop=percent);
by deptid;
indiv_bonus=bonus/count;
run;
--
Paige Miller
Paige Miller
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
If you sort both of your data sets by DEPTID, then this works:
proc freq data=emp;
table deptid/noprint out=_counts_;
run;
data want;
merge emp bonus _counts_(drop=percent);
by deptid;
indiv_bonus=bonus/count;
run;
--
Paige Miller
Paige Miller