Change values in a column

[tp10279]

Hi,

I am trying to change the value in a column using EG. I want to change the full name of the product to an abbreviated name. Is there a function that will allow me to do this?

Thanks!

[DerekAdams]

Have you tried the Recode option in the Computed Columns or create a format

[RichardH_sas]

Recode or user-defined format that Derek mentioned are probably the best solutions for what you want.

If you want to abbreviate by literally take the first X characters from each product name, you can use a SUBSTR function to do that. Create a computed column based on an expression, and for the expression use something like

SUBSTR(column1,1,8)

===starts at the first character of column1 and extracts exactly 8 characters===

[tp10279]

Thanks, I tired the recode a column, and it did exactly what I needed!