topic Re: Using DATEPART in Information Map Studio in SAS Web Report Studio

Using DATEPART in Information Map Studio

carmendee — Tue, 15 Nov 2016 14:54:24 GMT

I am trying to add "datepart" to my date field in Information Map Studio and am getting an error when validating.

case when <<datepart(ZW_CURRENT_DATE_DIM.CALENDAR_DATE)>> > '08Nov2016'd then '2nd Quarter'
end

Re: Using DATEPART in Information Map Studio

RW9 — Tue, 15 Nov 2016 15:27:57 GMT

Well, never used information map, so apologies if this is not the item, but why do you have << and >> around the datepart function? Also, it may help if you actual post a picture ot the text of what the "error" is, perhaps that isn't a date variable?

Re: Using DATEPART in Information Map Studio

carmendee — Tue, 15 Nov 2016 15:34:53 GMT

Attached is the error. Also, my limited experience with Information Map has required the << and >> as part of the code.

Re: Using DATEPART in Information Map Studio

carmendee — Tue, 15 Nov 2016 15:36:14 GMT

Confirmed calendar date is a date variable.

Re: Using DATEPART in Information Map Studio

carmendee — Tue, 15 Nov 2016 18:30:50 GMT

Please see where I attached error.

Re: Using DATEPART in Information Map Studio

LinusH — Tue, 15 Nov 2016 20:51:44 GMT

In regular SQL, using the syntax "case when", you need a = between your expression and the constant.

Re: Using DATEPART in Information Map Studio

RW9 — Wed, 16 Nov 2016 09:21:46 GMT

Hi,

Why have you marked the post containing your error as the solution? Also, please post the erro as either text or picture in the post, I would not download any Office files.

The syntax of a case statement is:

case when <condition> then <result> [when...] else <result> end

case <variable> when <value> then <result> [when...] else <result> end

As I say, never heard of this information map, but I have never seen any system using << >> around variables, that is an operator in some languages.