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
;
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
;
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
;
Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!
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.
Ready to level-up your skills? Choose your own adventure.