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
;
CFC_SAS_Communities_400x225.jpg
It's your turn to help shape SAS Innovate 2027. Share your expertise and inspire the SAS community.
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.