BookmarkSubscribeRSS Feed
deleted_user
Not applicable
Hi,

How can I define a length for a computed column derived from an excisting variable ??

The computed column: substr(nrrelat,1,9)
the variable nrrelat has a length of 12
the length I need for the computed column should be 9
1 REPLY 1
Olivier
Pyrite | Level 9
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

substr(nrrelat,1,9) AS computedVarName FORMAT=...

Add between the new column name and the FORMAT option the following code :
LENGTH=9
and re-run the code.

That was not really what you were looking for, I think, but I can't think of any non-coding way to do that.
Regards

Olivier

sas-innovate-2024.png

Join us for SAS Innovate April 16-19 at the Aria in Las Vegas. Bring the team and save big with our group pricing for a limited time only.

Pre-conference courses and tutorials are filling up fast and are always a sellout. Register today to reserve your seat.

 

Register now!

SAS Enterprise Guide vs. SAS Studio

What’s the difference between SAS Enterprise Guide and SAS Studio? How are they similar? Just ask SAS’ Danny Modlin.

Find more tutorials on the SAS Users YouTube channel.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

Discussion stats
  • 1 reply
  • 682 views
  • 0 likes
  • 2 in conversation