Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

SAS VA specify length field for derived column

Reply
New Contributor
Posts: 4

SAS VA specify length field for derived column

for desi
HI,

How to specify length of derived column in SAS VA. It is taking default 8 Character.

Thanks

SAS Super FREQ
Posts: 275

Re: SAS VA specify length field for derived column

Hello, and thanks for your question.

There are many types of data item you can create in VA, so I'm not sure which type of derived column you are asking about.

If you mean a calculated item, the Edit Calculated Item window has a Format field at the bottom where you can set the width.

If you mean a custom category, the width should automatically match the longest label value in your custom category.

Most other types of derived columns take numeric formats.

Does that help?

Thanks,

Sam

Super User
Posts: 1,208

Re: SAS VA specify length field for derived column

Hi,

Can you please explain what you mean by derived column and also how you are loading the data into SAS Visual Analytics? If you are loading the data into SAS Visual Analytics via the data builder you can change the length of a character column by specifying its length. You can see examples of this in blog post on SAS Visual Analytics: loading data into memory As per the screenshot you can see there are columns defined as a length of 10, 3 & 5 characters in the output table.

VAloading5.jpg

Once a table is loaded into memory, the length of the field cannot be changed. You can change the format width though as Sam points out and for new calculated items you create.

Let us know if we have helped with your question and if not, please provide further details so we have a better understanding on what you are after.

Kind Regards,

Michelle

Post a Question
Discussion Stats
  • 2 replies
  • 338 views
  • 0 likes
  • 3 in conversation