topic EG query builder : character computed columns length in SAS Enterprise Guide

EG query builder : character computed columns length

checkno — Thu, 17 Nov 2011 18:51:50 GMT

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 — Fri, 18 Nov 2011 11:27:47 GMT

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 — Fri, 18 Nov 2011 16:17:36 GMT

it works for me, if i give a character format

Thank you