topic Re: Strange bug with week prompts in SAS Enterprise Guide

Strange bug with week prompts

TimCampbell — Mon, 18 Jan 2016 14:06:02 GMT

Hi all,

I am hitting a slight bug with prompts in Enterprise guide 7.11 HF3 (7.100.1.2805).

I have built a reporting process for our users in EG where they select a week to report on in a prompt.

The prompt is built as shown in the image below, as a date prompt where users enter a value with the date type set to week.

When the process using the prompt is run, enterprise guide sets some macro variables, prompt_1 and prompt_1_end as date9 format dates for the first and last date from the week selected.

The bug I am getting is that, generally the dates selected will be Mon-Sun for the week selected except for when week 1 of any year is selected where, the prompt examples show the correct dates but the actual values are Thu-Wed.

This behaviour seems to be true for most years not just 2016.

e.g.

Week53 2015 = 28DEC2015 - 03JAN2016

Week01 2016 = 07JAN2016 - 13JAN2016 (should be 04JAN2016-10JAN2016)

Week02 2016 = 11JAN2016 - 17JAN2016

Screen shots of prompt selecting and log after running:

Has anyone else come across this or found a solution?

Obviously it won't be difficult to change my process to select a single date and then calculate the week required myself but if i can just fix EG it will probably be less work...

Tim

Re: Strange bug with week prompts

Kurt_Bremser — Mon, 18 Jan 2016 14:48:02 GMT

Wow. Looks like you discovered a bug. Happens here with EG 4.3 and 6.1, SAS 9.2 (AIX) as backend.

This is a case for SAS TS, IMO.

Edit: the funny thing about this is that, while selecting the week and before hitting run, the correct dates are displayed.

Re: Strange bug with week prompts

TimCampbell — Tue, 19 Jan 2016 08:26:32 GMT

Have raised with SAS TS as well, will post back if i hear anything from them.

Added excitement is that the same thing happens if I am running a stored process in enterprise guide, but not if i run it in the stored process web app.

Re: Strange bug with week prompts

Kurt_Bremser — Tue, 19 Jan 2016 09:43:16 GMT

This seems to isolate EG as the culprit. Please keep us informed on further developments.

Re: Strange bug with week prompts

TimCampbell — Mon, 01 Feb 2016 08:59:33 GMT

Response back from SAS support is that they are going to be raising it with R&D to consider a hotfix.

For the time being I have changed our reporting to use a normal date prompt and then am calculating the appropriate week values and label from that with the code below in case anyone else comes across this.

%let g_date_prompt_start = %sysfunc(intnx(week1.2,%sysfunc(inputn(&g_date_prompt,date9.),8.),0,B),date9.);
%let g_date_prompt_end   = %sysfunc(intnx(week1.2,%sysfunc(inputn(&g_date_prompt,date9.),8.),0,E),date9.);
%let g_date_prompt_label = %sysfunc(tranwrd(%sysfunc(scan(%sysfunc(inputn(&g_date_prompt,date9.),weekv11.),2,-)),W,Week )) %sysfunc(scan(%sysfunc(inputn(&g_date_prompt,date9.),weekv11.),1,-));

Re: Strange bug with week prompts

Kurt_Bremser — Mon, 01 Feb 2016 09:08:39 GMT

Congrats!

Now you have a real SAS bug to your name.