Desktop productivity for business analysts and programmers

how to replace a data in sas enterprise guide

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 15
Accepted Solution

how to replace a data in sas enterprise guide

Hi,

So i have an excel file that i want to replace the data in the first column.

How do i do this in sas EG?

For example:

Item           | Price

Hamburger | 5.00

Food          | 4.00

Coke         |  1.00

Pizza        | 7.00

Drinks       | 1.50

Fanta        | 1.00

I want to replace the hamburger and pizza to the word Food

how do i do this?


Accepted Solutions
Solution
‎05-24-2012 05:26 AM
Super Contributor
Posts: 349

Re: how to replace a data in sas enterprise guide

Hi,

You can write an expression for doing this.

Thanks,

Shiva

HamburgeFOOD
FoodFood
CokeCoke
PizzaFOOD
DrinksDrinks
FantaFanta

EG.png

View solution in original post


All Replies
Solution
‎05-24-2012 05:26 AM
Super Contributor
Posts: 349

Re: how to replace a data in sas enterprise guide

Hi,

You can write an expression for doing this.

Thanks,

Shiva

HamburgeFOOD
FoodFood
CokeCoke
PizzaFOOD
DrinksDrinks
FantaFanta

EG.png

🔒 This topic is solved and locked.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 771 views
  • 0 likes
  • 2 in conversation