Desktop productivity for business analysts and programmers

EG query builder : character computed columns length

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 7
Accepted Solution

EG query builder : character computed columns length

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.


Accepted Solutions
Solution
‎11-18-2011 06:27 AM
Esteemed Advisor
Posts: 5,198

EG query builder : character computed columns length

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

Data never sleeps

View solution in original post


All Replies
Solution
‎11-18-2011 06:27 AM
Esteemed Advisor
Posts: 5,198

EG query builder : character computed columns length

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

Data never sleeps
Occasional Contributor
Posts: 7

EG query builder : character computed columns length

it works for me, if i give a character format

Thank you

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 199 views
  • 0 likes
  • 2 in conversation