Length statement

[Nlr]

Hi!

How do you write the 'length' statement in the expression builder? Can it be used when you have a character column?

[ChrisHemedinger]

Are you trying to calculate the length of the character value? If so, you can use an expression like this in your calculated column:

LENGTHC( )

For example, if you want to calculate the length of each Name value in SASHELP.CLASS, use this:

LENGTHC(Name)

If you want to make sure that trailing blanks aren't counted, use this:

LENGTHC(TRIM(Name))

Chris

[ChrisNZ]

If I understand the question correctly, you can either force the length with a put statement:

put( scan(VAR,1), $32.)

or (possibly; untested) add the length after the expression

scan(VAR,1)   length = 32