https://communities.sas.com/t5/SAS-Enterprise-Guide/Length-statement-for-computed-column/m-p/2255#M753 Hi,<BR /> <BR /> How can I define a length for a computed column derived from an excisting variable ??<BR /> <BR /> The computed column: substr(nrrelat,1,9)<BR /> the variable nrrelat has a length of 12<BR /> the length I need for the computed column should be 9 Wed, 07 Feb 2007 09:42:39 GMT deleted_user 2007-02-07T09:42:39Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Length-statement-for-computed-column/m-p/2255#M753 Hi,<BR /> <BR /> How can I define a length for a computed column derived from an excisting variable ??<BR /> <BR /> The computed column: substr(nrrelat,1,9)<BR /> the variable nrrelat has a length of 12<BR /> the length I need for the computed column should be 9 Wed, 07 Feb 2007 09:42:39 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Length-statement-for-computed-column/m-p/2255#M753 deleted_user 2007-02-07T09:42:39Z https://communities.sas.com/t5/SAS-Enterprise-Guide/Length-statement-for-computed-column/m-p/2256#M754 I don't think that you can change the length in the click and point interface. But you can surely do so in the generated code : just look for the SQL procedure, then in the select statement, you have<BR /> <BR /> substr(nrrelat,1,9) AS computedVarName FORMAT=...<BR /> <BR /> Add between the new column name and the FORMAT option the following code :<BR /> LENGTH=9<BR /> and re-run the code.<BR /> <BR /> That was not really what you were looking for, I think, but I can't think of any non-coding way to do that.<BR /> Regards<BR /> <BR /> Olivier Wed, 07 Feb 2007 11:54:56 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/Length-statement-for-computed-column/m-p/2256#M754 Olivier 2007-02-07T11:54:56Z