Traditional web-based reporting with SAS BI tools

Using charecter fields as values in WRS crosstab

Reply
New Contributor
Posts: 2

Using charecter fields as values in WRS crosstab

whenever i use a charecter field as a value and try to use it in a crosstab i get this "cannot be included in a crosstabulation table because the aggregation type(s) are not supported" yet i set it to "MAX" which i thought was a supported aggregate type. is there a trick to making this work?

Contributor
Posts: 28

Re: Using charecter fields as values in WRS crosstab

I suppose you've found a solution but if it's a character field containing numbers you can create a new field in your information map and put your expression.

input(column_name,$8.)

Ask a Question
Discussion stats
  • 1 reply
  • 296 views
  • 0 likes
  • 2 in conversation