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
;
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.