🔒 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-18-2021 10:34 AM
(1619 views)
Hi, I need help in hard coding two variables namely Company_name & Company_code and adding them into leave table as two new columns, kindly note that the values under Company_name is always "mac" & Company_code values is always "rm"
data leave;
input calender_month leave_days leave_type_code;
datalines;
202101 2 2
202101 4 2
202101 5 2
;
data want
calender_month leave_days type_code Company_name Company_code
202101 2 2 mac rm
202101 4 2 mac rm
202101 5 2 mac rm
;
1 ACCEPTED SOLUTION
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data leave;
input calender_month leave_days leave_type_code;
company_name="mac" ;
company_code="rm" ;
datalines;
202101 2 2
202101 4 2
202101 5 2
;
2 REPLIES 2
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
data leave;
input calender_month leave_days leave_type_code;
company_name="mac" ;
company_code="rm" ;
datalines;
202101 2 2
202101 4 2
202101 5 2
;
- Mark as New
- Bookmark
- Subscribe
- Mute
- RSS Feed
- Permalink
- Report Inappropriate Content
thank you so much..