topic Re: Change values in a column in SAS Enterprise Guide

Change values in a column

tp10279 — Fri, 10 Jul 2009 14:49:44 GMT

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!

Re: Change values in a column

DerekAdams — Sat, 11 Jul 2009 10:15:02 GMT

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

Re: Change values in a column

RichardH_sas — Mon, 13 Jul 2009 15:08:14 GMT

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===

Re: Change values in a column

tp10279 — Tue, 14 Jul 2009 13:09:51 GMT

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