topic Re: how to replace a data in sas enterprise guide in SAS Enterprise Guide https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-replace-a-data-in-sas-enterprise-guide/m-p/125397#M10318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can write an expression for doing this.</P><P>Thanks,</P><P>Shiva</P><P></P><TABLE><TBODY><TR><TD>Hamburge</TD><TD>FOOD</TD></TR><TR><TD>Food</TD><TD>Food</TD></TR><TR><TD>Coke</TD><TD>Coke</TD></TR><TR><TD>Pizza</TD><TD>FOOD</TD></TR><TR><TD>Drinks</TD><TD>Drinks</TD></TR><TR><TD>Fanta</TD><TD>Fanta</TD></TR></TBODY></TABLE><P></P><P><IMG alt="EG.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/2082_EG.png" width="450" /></P></BODY></HTML> Thu, 24 May 2012 09:26:41 GMT shivas 2012-05-24T09:26:41Z how to replace a data in sas enterprise guide https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-replace-a-data-in-sas-enterprise-guide/m-p/125396#M10317 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P></P><P>So i have an excel file that i want to replace the data in the first column. </P><P>How do i do this in sas EG? </P><P>For example:</P><P></P><P>Item&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | Price</P><P>Hamburger | 5.00</P><P>Food&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 4.00</P><P>Coke&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 1.00</P><P>Pizza&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 7.00</P><P>Drinks&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 1.50</P><P>Fanta&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 1.00</P><P></P><P></P><P>I want to replace the hamburger and pizza to the word Food</P><P></P><P></P><P>how do i do this?</P></BODY></HTML> Thu, 24 May 2012 06:04:44 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-replace-a-data-in-sas-enterprise-guide/m-p/125396#M10317 sugita 2012-05-24T06:04:44Z Re: how to replace a data in sas enterprise guide https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-replace-a-data-in-sas-enterprise-guide/m-p/125397#M10318 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can write an expression for doing this.</P><P>Thanks,</P><P>Shiva</P><P></P><TABLE><TBODY><TR><TD>Hamburge</TD><TD>FOOD</TD></TR><TR><TD>Food</TD><TD>Food</TD></TR><TR><TD>Coke</TD><TD>Coke</TD></TR><TR><TD>Pizza</TD><TD>FOOD</TD></TR><TR><TD>Drinks</TD><TD>Drinks</TD></TR><TR><TD>Fanta</TD><TD>Fanta</TD></TR></TBODY></TABLE><P></P><P><IMG alt="EG.png" class="jive-image-thumbnail jive-image" src="https://communities.sas.com/legacyfs/online/2082_EG.png" width="450" /></P></BODY></HTML> Thu, 24 May 2012 09:26:41 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/how-to-replace-a-data-in-sas-enterprise-guide/m-p/125397#M10318 shivas 2012-05-24T09:26:41Z