Desktop productivity for business analysts and programmers

Longer Column Headings in SAS EG

Reply
Contributor JSJ
Contributor
Posts: 43

Longer Column Headings in SAS EG

Hi all,

I am working in SAS EG and I need to have longer column headings than what is allowed in a query.

I made a sum and I would like to have more than the 35 or so characters.

Also, can you split the column header to be on 2 lines.

      FY15 Total Gifts

To Alloc 999999, 888888

SAS Employee
Posts: 50

Re: Longer Column Headings in SAS EG

Hi JSJ,

I believe it is the case that the column headings in a query are limited to 32 characters and can contain special characters including blanks as long as the Valid variable names option is set to "Extended variable names (ANY)." (This option is located under Tools > Options > Data > Data General) 

As far as I know, you cannot split a column heading over multiple lines, but I'll verify that with the experts here, and we will post back if there is a way to do it.

thanks!

Jennifer

SAS Employee
Posts: 50

Re: Longer Column Headings in SAS EG

Hi JSJ,

I was able to confirm with a member of our development team that the maximum length for column headers is 32 characters, and they cannot span multiple lines.

thanks,

Jennifer

Ask a Question
Discussion stats
  • 2 replies
  • 303 views
  • 0 likes
  • 2 in conversation