EG query builder : character computed columns length

[checkno]

Hi all,

in a query, i need to have a constant character variable,

i need this variable to be $64 length (preparing it for an append)

in the wizard for creating a new column (calculated="char"), when i change the length value to 64 ,

i have an error popup : the length value is out of range, it should be between 3 and 8

i tried to get around this by using a cat or repeat ... functions, but a length of 200 is too much

its a project for non sas specialists so less code is better.

[LinusH · Accepted solution]

The wizard is a bit tricky.

It seems that the default is numeric output column, which explains the valid range (3-8 bytes).

Id you chose a character format, it will probably work for you.

/Linus

[checkno]

it works for me, if i give a character format

Thank you