https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742331#M232171 thank you so much.. Wed, 19 May 2021 06:09:43 GMT Solly7 2021-05-19T06:09:43Z https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742173#M232079 <P>Hi, I need help in hard coding two variables namely<STRONG> Company_name</STRONG> &amp; <STRONG>Company_code</STRONG> and adding them into leave table as two new columns, kindly note that the values under&nbsp;&nbsp;<STRONG>Company_name&nbsp;</STRONG>is always&nbsp;<SPAN>"mac</SPAN><SPAN>"&nbsp; &amp; <STRONG>Company_code </STRONG>values is always&nbsp;"rm"</SPAN></P> <P>&nbsp;</P> <PRE>data leave;<BR />input calender_month leave_days leave_type_code;<BR />datalines;<BR />202101 2 2 <BR />202101 4 2 <BR />202101 5 2 <BR />;</PRE> <P>&nbsp;</P> <P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<STRONG>data want</STRONG></P> <P><STRONG>calender_month&nbsp; &nbsp; &nbsp; &nbsp; leave_days&nbsp; &nbsp; &nbsp; &nbsp; type_code&nbsp; &nbsp; &nbsp; Company_name&nbsp; &nbsp; &nbsp; &nbsp; Company_code&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;</STRONG></P> <P>202101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mac&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rm<BR />202101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mac&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rm<BR />202101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; mac&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;rm<BR /><BR /><BR />;</P> Tue, 18 May 2021 14:34:27 GMT https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742173#M232079 Solly7 2021-05-18T14:34:27Z https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742175#M232081 <PRE><CODE class=" language-sas">data leave; input calender_month leave_days leave_type_code; company_name="mac" ; company_code="<SPAN>rm</SPAN>" ; datalines; 202101 2 2 202101 4 2 202101 5 2 ;</CODE></PRE> Tue, 18 May 2021 14:37:26 GMT https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742175#M232081 AMSAS 2021-05-18T14:37:26Z https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742331#M232171 thank you so much.. Wed, 19 May 2021 06:09:43 GMT https://communities.sas.com/t5/SAS-Programming/Hard-Coding-Variables/m-p/742331#M232171 Solly7 2021-05-19T06:09:43Z