sas web studio error

Reply
Occasional Contributor
Posts: 13

sas web studio error

hi sas gurus

i created a data item called "A" which has the logic below in my information map studio CASE

WHEN <<root.Header>> = "Overall" THEN <<root.Amt>>

end

with this simple logic.....when i create a cross tab report in web studio it gives me an error

ERROR: Expression using equals (=) has components that are of different data types.

please advice.

Super Contributor
Posts: 644

Re: sas web studio error

It seems that the quantity <<root.Header>> is not character.  You may need to use the PUT( ) function to convert the value to a character for comparison in the When clause.

Richard

Occasional Contributor
Posts: 13

Re: sas web studio error

<<root.Header>> is the business column not the physical column. when i use the physical column, it works fine. when i say put(<<root.Header>>, 30.) = "overall" it gives an error...

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