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
;
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!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.
Select SAS Training centers are offering in-person courses. View upcoming courses for: