topic Re: sas web studio error in SAS Programming

sas web studio error

Amar — Mon, 26 May 2014 15:58:37 GMT

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.

Re: sas web studio error

RichardinOz — Tue, 27 May 2014 00:44:06 GMT

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

Re: sas web studio error

Amar — Tue, 27 May 2014 15:30:23 GMT

<<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...