topic Re: Length statement in SAS Enterprise Guide

Length statement

Nlr — Tue, 21 Mar 2006 12:32:56 GMT

Hi!

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

Re: Length statement

ChrisHemedinger — Fri, 24 Mar 2006 21:19:26 GMT

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

Re: Length statement

ChrisNZ — Tue, 21 Jan 2020 11:22:58 GMT

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